How to Use ChatGPT in Google Sheets (Full Tutorial)

Рет қаралды 61,652

Күн бұрын

🔻 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

Пікірлер: 42

@Bardeenai 9 ай бұрын

🔻 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

@orelhassid Жыл бұрын

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

@Bardeenai Жыл бұрын

Thank you!

@onlytanofficial 2 күн бұрын

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

@Beanskiiii 3 ай бұрын

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

@ivanurbina2422 10 ай бұрын

AWESOME!!!

@misterjuls 8 ай бұрын

Super useful thanks 👍👍

@abdulhameedaltaweel1055 Жыл бұрын

Great 👍👍👍

@cgc2300 6 күн бұрын

thank you

@hassenzouari2479 5 ай бұрын

Thank you so much

@neroetal 3 ай бұрын

omg, leaning this 8 months later lol

@Beanskiiii 3 ай бұрын

At least you learned it as sooner than later

@ProviderKnowledge 6 ай бұрын

thanks

@andriusworkeris1800 3 ай бұрын

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?

@ryanbrown8387 11 ай бұрын

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?

@KreatorVee 9 ай бұрын

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!

@Bardeenai 9 ай бұрын

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.

@KreatorVee 9 ай бұрын

@@Bardeenai awesome! thank you!

@business-data 9 ай бұрын

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 ???

@Bardeenai 9 ай бұрын

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!

@Bardeenai 9 ай бұрын

How would an ideal workflow for this use case look like for you? We've love to make it more intuitive.

@AdamLundquist 26 күн бұрын

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

@cgc2300 6 күн бұрын

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

@nexai_official 4 ай бұрын

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

@SD-rg5mj 10 ай бұрын

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

@Bardeenai 10 ай бұрын

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.

@SD-rg5mj 10 ай бұрын

@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?

@mrvictorbassey 5 ай бұрын

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"

@cgc2300 7 ай бұрын

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

@Bardeenai 7 ай бұрын

Yes, you can. Click on the "advanced" tab and select the model :)

@cgc2300 7 ай бұрын

@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