GPT Workspace
  • GPT Workspace
  • Get started: Add-on
  • Get started: Chrome Extension
  • Subscription
    • Manage my subscription
    • Team subscription
    • Downloading invoices
  • Pricing and Models
    • What is a credit?
    • AI Models
    • Pay per usage
  • Products
    • GPT for Google Sheets
      • Formulas
        • GPT formula
        • GPT_WEB formula
        • GPT_LIST formula
        • GPT_TABLE formula
        • GPT_IMAGE formula
        • GPT_TRANSLATE formula
        • GPT_COMPLETE formula
      • Default Model, Temperature and Output size for GPT Formulas
      • Refresh or Freeze GPT cells
    • GPT for Google Docs
    • GPT for Google Slides
    • GPT for Gmail
  • FAQ
    • How to change the language?
    • Internet Access with GPT?
    • How to launch the GPT Gmail and GPT Drive add-on
    • I can't find the add-on from the sidebar
    • I can't install the extension
    • Is GPT Workspace included with ChatGPT Plus or Enterprise?
    • How to uninstall GPT Workspace
    • Do custom assistants have any limitations?
  • Resources
    • Common Errors
    • Tutorials and Resources
    • Data and Privacy
Powered by GitBook
On this page
  1. Products
  2. GPT for Google Sheets
  3. Formulas

GPT_IMAGE formula

PreviousGPT_TABLE formulaNextGPT_TRANSLATE formula

Last updated 11 months ago

Generate images with =GPT_IMAGE

With GPT_IMAGE, generate thousands of AI images in one click with the from OpenAI

=GPT_IMAGE formula returns the link to the image not the image itself.

You will need to Allow access to let =IMAGE formula fetch and display the image in your sheet

To get started, select a cell and input then use the following formula

=GPT_IMAGE(prompt, value, temperature, model, cache)

Parameter
Description
Default

prompt

the prompt describing the image you want to generate. (ex: "a cute dog wearing a baseball hat")

required

""

seed

Repeated requests with the same seed and parameters should return the same result

null

quality

standard , hd

standard

size

1024x1024 , 1792x1024 , 1024x1792

1024x1024

style

vivid , natural

vivid

bypassCache

Bypass the cache and query OpenAI again. The results will be differents than before.

false

To display the image in Google Sheets, use the =IMAGE(...) formula (documented )

You can retrieve the generated image

here
in your Google Drive "Generated images" folder
Dall-E 3 image generation model