Skip to main content

GPTLIST

The GPTLIST() function generates a vertical list, placing one AI-generated item per row.

It's ideal for brainstorming, creating checklists, generating suggestions, or expanding ideas based on context.

Formula Syntax​

=GPTLIST(prompt, [input], [model])

  • prompt (required): Instruction for generating a list. (e.g., "List 5 productivity tips" or "Suggest blog ideas for a new product.")
  • input (optional): Cell or range providing context for the list generation.
  • model (optional): Override the default model (e.g., gemini-1.5-pro, gpt-4o). Defaults to your sheet settings if not provided.

Example(s)​

List productivity tips​

=GPTLIST("List 5 quick productivity tips.")

Suggest gift ideas based on input​

=GPTLIST("Suggest 5 gift ideas based on the interests listed below.", A2:C2)

Create blog title ideas using a specific model​

=GPTLIST("Generate 7 blog title ideas based on these topics.", A2:A5, "gemini-1.5-pro")