Generate tables of data in Google Sheets with ChatGPT

In this video, we present you the GPT_TABLE function which lets you create and automatically fill tables of data super easily! Get one item per cell and parse your results easily in Google Sheets.

📖 Function in this video
Syntax: =GPT_TABLE(prompt, [headers], [temperature], [max_tokens], [model]) - model by default: gpt-3.5-turbo
Copy/Paste exemple: =GPT_TABLE("top 10 most eaten fruits and their nutrition data")
Copy/Paste exemple with custom temperature, max_tokens and model parameters: =GPT_TABLE("top 10 most eaten fruits and their nutrition data", [headers], 0.5, 600, gpt-3.5-turbo)

▶️ PLAYLIST:

------------------------------------------------------------------------------------------
GPT for Work is an AI assistant for Microsoft Excel and Word, Google Sheets and Docs. You can use it for all sorts of tasks: writing, editing, extracting, cleaning, translating, summarizing, outlining, explaining... and even analyzing pictures!

GPT for Work brings the power of OpenAI's latest models, including GPT-3.5 Turbo, GPT-4, GPT-4 Turbo and GPT-4 Vision into Microsoft Excel and Word, Google Sheets and Docs. It is like using ChatGPT directly in your spreadsheets and documents!

Our GPT functions are perfect for bulk operations in Excel and Sheets.
Our Word and Docs integrations are great for long form content.

------------------------------------------------------------------------------------------

Check out our other productivity tools for Google Workspace:

[AlexSMontgomery]

This function is a game changer. I wasnt sure how I was going to get lots of data into rows and columns but now its taken care of!

🙏🙏🙏

[alexway]

That's really cool. Can't wait to see more functions :)

[varunp]

Thank you for this video. It gave a major breakthrough. Please can you guide me on how I can accommodate 3 prompt cells in the gpt_table formula

[szijklj]

what if i want to get the details of specific fruits rather than random?

[quotablevideos]

I want to make a table based on a range of data and instructions from my prompt. Is there a way to do this?

[lunganimagwaz]

If I have My list eg: List of Fruits and I Want Data everytime I add a new Fruit
how do I do it

[bpnlmbz]

Amazing tool. Thanks for sharing. Go Stan!

[SpassMitFakten]

Hey, that is a rly helpful tool to create tables. But I am getting most of the time an error: max-education-time. Do you know why this happens? Regards!

[JackSparks-yrvi]

love the videos! is there a way I can get this to work by reviewing a list (say, keywords in column A) and then returning a table? For context, I'd like it to return a table with campaign/ad group/keywords based on a list of (50+) keywords

[SD-rgmj]

hello can i do the same thing with other artificial intelligence?
for example minigpt?
do I have to use their API and do the exact same thing to get the text generated by this AI to go directly into a cell in my Google Docs?

and thank you so much for your videos

[nimavakil]

Hi Stan, great job!
Do you guys do projects for companies? We have a project that clearly needs AI. If yes, how can we contact you guys?
Thanks, Nima

[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