Icon of Imagine AI Function: Brush painting a simplified landscape

IMAGINE

Transforms text descriptions into generated images using OpenAI's DALL·E

Generate images within Google Sheets using the powerful image generator DALL·E, OpenAI's counterpart to Midjourney. This Smart Function allows for the generation of images in batch by using spreadsheets to provide image descriptions.

Examples
=IMAGINE_X("Black cat sitting on the checkered floor")

Output Example:
https://ucarecdn.com/efa8f0b0-f0f9-4b19-a736-6936a7433b43/imagine_2024-02-22_13-14-51.jpg
=IMAGINE_Y(M6,"",{"style",$I$3; "size",$J$3; "quality",$K$3})

Output Example:
https://ucarecdn.com/b11bc604-6482-4980-be37-810457c9ec4f/imagine_2024-02-22_13-25-08.jpg
=IMAGINE_X(E12, "", {"style","vivid"; "size","1024x1792"; "quality","hd";  "filename",E12; "model","dall-e-3"})

Output Example:
https://ucarecdn.com/5247aa36-9a63-46b6-91ae-a01fa3d05eb8/Panda.jpg

Arguments List
=IMAGINE_X(prompt, [placeholder], [options])
=IMAGINE_Y(prompt, [placeholder], [options])
prompt
Description of the image you want to generate, which will be used by DALL·E
For example: "Black cat jumping over a white dog in a modern interior", A2, or "A pair of people dancing, in the style of " & B2
[placeholder]
Reserved for a future OpenAI update. Currently not in use and should be skipped.
To skip: ""
Options List
Particular object at the end of a formula which contains optional parameters values in the form {"parameter_name",value; "next_parameter_name",value}
For Example: {"style","natural"; "size","1792x1024"; "quality","hd"; "filename",E14; "model","dall-e-3"}
style
Style of the image from the predefined list. It greatly affects the final result.
Options: "default", "natural", or "vivid"
size
Resolution of the image in pixels, specified as Width × Height. It can be selected from a list of options predefined by DALL·E.
Options: "1024x1024", "1024x1792", or "1792x1024"
quality
Sets the detail level of the image DALL·E creates. HD gives better quality but costs more.
Options: "default", "hd", or "standart"
model
For now, the only available model is DALL·E 3. In the future, there may be more options to choose from.
Options: "default" or "dall-e-3"
filename
Name of the file you will receive as output, aimed at clarifying the generated content and improving the spreadsheet structure.
For Example: "retrofuturism-style" or A2
generate
If TRUE, the formula executes the image generation. If FALSE, a warning message is displayed. Connect this parameter to a Google Sheets cell with a checkbox or a validating formula to avoid accidental costs.
For Example: TRUE, FALSE, or N$8
generate_warning
When 'generate' is set to FALSE, this message is displayed. It's recommended to provide directions on how to enable image generation by OpenAI's DALL·E.
Add the [STOP] codeword to stop processing related formulas, which remains hidden from the user. Input "default" for a standard message.
For Example: "default", "Choose a style", or B18