How to Use ChatGPT in Google Sheets (Full Tutorial)

🔍️ Explore Playbooks

📖 Video Chapters:
0:00 Intro
0:14 Generate Tables GPT_TABLE
1:00 Enable GPT for Sheets
1:58 “Dirt Cheap” Pricing Explained
3:10 Functions Overview
4:15 Two Ways To Get Your Data Into The Sheet
4:25 Import Data From Your Web Apps
5:35 Classification GPT_CLASSIFY
7:05 Generate Summaries GPT_SUMMARIZE
7:43 Importing Data With Web Scraper
9:03 Open Prompting GPT
10:11 Build AI Automations For Google Sheets And Beyond
11:40 AI Replicates Your Pattern GPT_FILL
14:15 End Notes

🤖 About Bardeen
Bardeen is a productivity app that automates your manual tasks with shortcuts. Follow our channel to learn about the latest tips about automating your day-to-day workflows and staying productive as a knowledge worker.

ℹ️ Need help? Join our Slack community

😻 Popular Automations

#ChatGPT #googlesheets

[orelhassid]

This content is FIRE! 🔥
I actually get bored with Linkedin scraping videos, this kind of video I really like!

[andriusworkeris]

Hello. Question - how to sort an exel table if one of the data is GPS coordinates ? I constantly need to sort in groups of 8 nearest coordinates. How can I do it faster?

[cgc]

Hello
I made a product catalog on Google Sheet then I imported this catalog into WordPress

I was wondering if it would be possible thanks to the combination of Google Sheet APIs, WordPress and the use of n8n software

that all the keywords present in the description column of each product are automatically replaced by the correct keywords?
and the same for images?

THANKS

[mrvictorbassey]

Somehow, in my case while trying to do this ( 4:25 :Import Data From Your Web Apps), bardeen does not return any results. This is what it says no matter how much I try. "Your last command returned no results"

[onlytanofficial]

This tutorial is SUPER awesome!! Loved it!! Thanks for sharing.

[KreatorVee]

This is awesome! I create Google sheet templates as a digital product. Would you know if I use this add on to creat my sheets, will other users be able to use the sheet if they don’t have the add on I used? Please let me know thanks!

[ryanbrown]

Bardeen seems like an awesome tool. I definitely wouldnt mind paying for it but I uninstalled after realizing there was a 14 day free trial. I need more than 14 days to get myself comfortable with the app and really feel confident in paying for it. After the free trial is up, is there a free version of it I can use or am I required to pay to use any of the features?

[nexai_official]

this is insane man... can't tell how many hours could human save just by hitting =gpt_

[LightAge]

When i open google sheets theres nowhere "set your api key"...pls help

[cgc]

hello I would like to do image description in my Google sheet, can I use other language models than for 3.5?

[TheHoneyzap]

Amazing video, learnt a tonne. Only problem is am going to get poor if I try to use so many AI tools. There are paywalls everywhere. No am not talking about just OPEN AI monthly subscription, I have that! Am talking about the token based pricing for every extension. This GPT extension one also will stop working after a while, when you run out of free tokens and then they will ask for more money. Understandable, it is a business!

[SD-rgmj]

hello I would like to have your opinion on several points,

first of all I thought about using artificial intelligence to fill my catalogs for my future e-commerce business,
I thought about using chatgpt in Google sheet, what do you think?
I mean I wonder if this is the best way to do it?
maybe it would be more interesting to request GPT4 with plugins?

and regarding Bardeen could you give me some use cases for ecommerce?

And could bardeen or another AI allow me to show my ads on marketplaces like amazon, ebay...

and also to do automations instead of make or zapier?

anyway thank you very much for your videos

[mmmmmray]

Any way to do this without a Chat GPT API Key?

[chrisder]

Hello, does it also work with other LLMs?
do you also use other APIs?

[Beanskiiii]

That classify function just blew my mind🤯 Technology is so cool

[AdamLundquist]

Do I have to do this by cell or can I do this on a big set for classification?

[GlobeGreenLLC]

how can i use this on a preexisting set of spreadsheets rather than starting a new sheet?

[business-data]

Great thanks. Question: at about 14:15 you have a scraped list from LinkedIn, you say you have all the first names ready for your email campaign, yet it was not able to pull any email addresses off ???