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_LIST formula

PreviousGPT_WEB formulaNextGPT_TABLE formula

Last updated 5 months ago

Generate entire lists with =GPT_LIST

Transforming your data has never been easier with GPT for Sheets. Its user-friendly custom functions enable you to swiftly cleanse and standardize any list or array of data, saving you time and hassle.

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

Parameter
Description
Default

prompt

The prompt describing the data you want to generate. (ex: "write a tagline for a waterproof t-shirt brand") required

""

value

The cell you are referring to in your prompt (ex: A1)

null

temperature

Between 0 (not creative) and 2 (very creative)

0

model

standard or advanced (gpt-4o-mini or gpt-4o)

standard

bypassCache

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

false