Create lists of data in Sheets with ChatGPT

In this video, find out how to generate multiple ideas at once using the =GPT_LIST() function in Google Sheets. Unlike the function =GPT(), =GPT_LIST() enables you to get one item per cell from a single prompt. This makes the results easier to use in your spreadsheet.
For example, you can use it to create test data, generate copy, taglines or subject lines variations.

▶️ PLAYLIST:

------------------------------------------------------------------------------------------
Like ChatGPT? Imagine using it in bulk in Google Sheets or Microsoft Excel and Word! 🤠
Make ChatGPT and other AIs write, rephrase, translate, categorize, extract, reformat, summarize, do research… 1000x faster than you could.

Popular use-cases for Excel and Sheets:
🌍 Translate in bulk
✍️ Create SEO content or ads copy at scale
🗂️ Clean and categorize your PIM or CRM
📊 Analyze survey results or customer feedback
📋 Review / Score a list of leads or candidates
🔍 Automate market research

Why use GPT for Work?
🚫 Stop copy/pasting to and from ChatGPT
⚡ Run up to 1000 prompts per minute
🎛️ Large model choice: GPT-4o, Claude 3.5 Sonnet, Gemini...
🔑 No API key required

Privacy and security:
🔒 Talarian is ISO 27001 certified and GDPR compliant
🛡️ We do not use your content to train models
🔐 Bring your own API key for enhanced privacy

Learn more:

[AlexSMontgomery]

For the new GPT model 3.5, should we be specifying that model at the end of all our formulas? Or will that end up being the new default model you think?

[automatio_co]

Hi Stan, can the inputs value be the rows previously generated by ChatGPT functions?

[AdrianBold]

Thank you for making this available. Really appreciate it.

[gamezone]

This Gpt_list is a very useful option, thank you dude 😎

[factorysales]

Is there a way to make the outputs appear in the same row instead of the same column?

[jojobee]

What's the default temperature if left it empty?

[largoenjapon]

Hey Stan, I just wanted to take a moment to say thank you for all of the helpful tutorial videos you've been putting out! Your expertise and attention to detail have been invaluable in helping me improve my own skills. Keep up the awesome work! #grateful #tutorialvideos #creativityboost #lifelonglearning @Stan #JuanUsingGPT

[designsbymelody]

After you generated the list, is there a way to make edits to the text output? I just tried this in Sheets, but it won't let me edit anything except the formula and prompt. Thanks!

[AKZGALAXY]

is there a way to list the data in a horizontal row rather than a drop-down list? Any help would be appreciated

[mill-qoly]

How do you get the bar that says GPT_LIST(promt, [value], [temperature], [max_tokens], [model])

[skillfulactor]

How close are we till you do the spread sheet formula stuff etc

[mawchy]

I'm not sure if I misunderstood the documentation but the value parameter says cell etc you want to apply your prompt to, does this mean it modifies that value and outputs in the cell where the function is completed, or writes to the cell taken as parameter input?

I've been trying to create a template for use on mobile to reduce typing but sheets lack a lot of dynamism when it comes to functions, I was trying to make some cells into basically pointers but I'm not sure if functions can write to another cell to begin with.

[anatoliioskoma]

Hello. For example, I need to compose the title text in the appropriate cell. The text should be approximately the same type because these are mats for the interior of the car. But the only thing that needs to change are the brands and models of cars that are listed in other cells. Tell me which function can be used in this case? I.e. there are two or three variables in the header that need to be changed and which are in other columns.

Example: Floor mats for HYUNDAI Solaris, 2017-, High side, 4 pcs.
The variables in this header, which are in other columns: HYUNDAI, Solaris, 2017, 4 pieces. (four variables in four different columns)

[bustelopilon]

Hello Stan. Thanks for your excellent tutorial videos. Is there any way around Google Sheets custom function 30 seconds execution time limit? (Exceeded maximum execution time (line 0).)

[milehighseo]

Is there a limit to how many characters or cells of input that GPT_list can integrate into it's output?

[lawrencecvx]

When I enter something list "List all of the refineries in the united states" it is only returning the top 10 unless I specify a specific number (ex. "List 30 refineries in the united states"). Is there anyway to have it provide an exhaustive list? I am not sure if this is a ChatGPT or extension limitation.... BTW, I am mind blown by this extension.

[mickds]

The LIST command is not working for me, I'm getting Unknown function: GPT_LIST

[ClaudWilliams]

This is so amazing, would it be possible for you to create a video which explain temperature?