List and table functions — generate structured data

Three functions in GPT for Sheets that return ranges, not single cells — for brainstorming, dataset scaffolding and pattern completion.

The functions

Function What it does
=GPT_LIST(prompt, [value]) Returns a vertical list, one item per row.
=GPT_HLIST(prompt, [value]) Same, horizontally.
=GPT_TABLE(prompt, headers) Generates a whole table under your headers.
=GPT_FILL(examples, inputs) Learns from example rows and fills the rest.

Examples

20 long-tail keyword ideas:

=GPT_LIST("20 long-tail keywords for 'ai in google sheets', one per line")

A content calendar table (headers in A1:D1: Date, Topic, Format, CTA):

=GPT_TABLE("30-day content calendar for a B2B SaaS about spreadsheets", A1:D1)

Complete a pattern — give it 3 done rows and let it fill 300:

=GPT_FILL(A2:B4, A5:A305)

Try it

Copy the template or install GPT for Sheets. Recipe: content calendar template.