GPT_LIST formula

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

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

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)

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

PreviousGPT_WEB formula NextGPT_TABLE formula

Last updated 11 days ago