How to Use ChatGPT in Google Sheets (Full Tutorial)
🔻 Download Bardeen: s.bardeen.ai/Download
📄 GPT for Sheets: workspace.google.com/marketpl...
🤖 Get emails sent to a recipient in Google Sheets: s.bardeen.ai/46z7akE
🤖 Save Amazon Product Reviews to Google Sheets: s.bardeen.ai/3tlXPOu
🧮 OpenAI API Pricing Calculator: gptforwork.com/tools/openai-c...
🎓 Scraper Tutorial: s.bardeen.ai/46Rcb8n
🔍️ Explore Playbooks
www.bardeen.ai/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.
🐦 / bardeenai
🕴 / bardeen
ℹ️ Need help? Join our Slack community
bardeen.ai/community
😻 Popular Automations
Meetings: www.bardeen.ai/posts/best-mee...
Scraper: www.bardeen.ai/lessons/bardee...
#ChatGPT #googlesheets
🔻 Download Bardeen: s.bardeen.ai/Download 📄 GPT for Sheets: workspace.google.com/marketplace/app/gpt_for_sheets_and_docs/677318054654 🤖 Get emails sent to a recipient in Google Sheets: s.bardeen.ai/46z7akE 🤖 Save Amazon Product Reviews to Google Sheets: s.bardeen.ai/3tlXPOu 🧮 OpenAI API Pricing Calculator: gptforwork.com/tools/openai-chatgpt-api-pricing-calculator 🎓 Scraper Tutorial: s.bardeen.ai/46Rcb8n
This content is FIRE! 🔥 I actually get bored with Linkedin scraping videos, this kind of video I really like!
Thank you!
AWESOME!!!
That classify function just blew my mind🤯 Technology is so cool
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!
Great question. If you share a Bardeen playbook, anyone can use it with your set up. Google Add Ons that you used in a specific Google Sheet should also show up for other users.
@@Bardeenai awesome! thank you!
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 ???
Fantastic question, Chris. You can find email address using either 1. Apollo Integration 🆕 2. Snov There is a way to split the first name using the "Split string" action. Hope this helps!
How would an ideal workflow for this use case look like for you? We've love to make it more intuitive.
Super useful thanks 👍👍
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?
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
Using AI inside sheets is a great way to write catchy product descriptions and taglines. But it's important to note that they will be as good as the data you provide. Bardeen is great for sourcing that data using its data scraper. Do feel free to share your use cases for e-com and we will suggest automations.
@Bardeenai in case of use, do you want me to tell you what my intention is? why do i want to use i farted in sheet? to make me a catalog of e-commerce products Can I send you a PM to tell you more precisely what I want to do? and above all, could you give me use cases for using Bardeen for my e-commerce?
Thank you so much
omg, leaning this 8 months later lol
At least you learned it as sooner than later
Hello, does it work with images?
What do you mean exactly?
Great 👍👍👍
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?
thanks
hello I would like to do image description in my Google sheet, can I use other language models than for 3.5?
Yes, you can. Click on the "advanced" tab and select the model :)
@Bardeenai can you show me where? I saw the Google sheet doc about using GPT api clearance and it marked that I can choose either gpt 3.5 or Da Vinci text
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"
how can i use this on a preexisting set of spreadsheets rather than starting a new sheet?
Yes, absolutely you can.
this is insane man... can't tell how many hours could human save just by hitting =gpt_
When i open google sheets theres nowhere "set your api key"...pls help
I got it solved. U have to insall it from google sheets and not seperate. Thats what i did before. If someone had this problem.
Any way to do this without a Chat GPT API Key?
Yes, you can add an OpenAI action in Bardeen after your scraper action. Video about this is coming out later this week.
Can't wait to see that video!@@Bardeenai
😘
this mf got a harp in the back