GPT_LIST formula
Generate entire lists with =GPT_LIST
Section titled “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 (GLM 5.2, 1 credit/token) or advanced (GLM 5.2 nitro, 5 credits/token, paid plans) | standard |
bypassCache | Bypass the cache and query openai again. The results will be differents than before. | false |