How Everyone Upgrades Google Sheets with ChatGPT
HTML-код
- Опубликовано: 1 июн 2024
- 4 Simple (no-coding) Steps to Upgrade Google Sheets with ChatGPT API Key. Plus, full workflow to turn boring data tables into 100s of beautiful designs with Canva.
🚩Sjoerd’s Blog Post on How to Upgrade Google Sheets with ChatGPT: bit.ly/3B81JeD
🚩Get OpenAI API Key Here: platform.openai.com/
🚩Canva: www.canva.com/
🚩OpenAI Pricing: openai.com/pricing
🎙️ Listen to Wes and I jazz around all things AI on @HTTTA Podcast: bit.ly/3LSrPIN
💌 Subscribe to the Newsletter: bit.ly/44ttqw0
AI Resources I use and recommend (some might be affiliate links):
🔥 PromptPerfect for prompt optimization: FOR 15% OFF; use this link and the code 'godago' at the checkout! ✅ bit.ly/42Grj64
🔥Text Blaze for quick prompt recall: textblaze.me/godago
🔥 SnackPrompt for the prompt organization: bit.ly/3UVv3hF
🔥Learn Prompting bit.ly/3YvFids
Time stamps:
00:00 Let's Talk about Practical AI for a second
01:15 STEP 1: How to Get and Use OpenAI API Key
03:11 STEP 2: Integrating ChatGPT into Google Sheets
05:36 STEP 3: Warning about Personal Data
06:31 STEP 4: How to create 100s of Designs in One Click
Some Google Sheets prompts I used:
Event invite:
=gpt("Act as a creative and charismatic copywriter. Write a short personalized invitation to attend the" & $F2 & " conference. The invitation is addressed to " & $A2 & " " & $B2 & " who is working at " & $D2 & " as a " & $E2 & ". Incorporate a personal joke but don't say that you are making a joke. Make the invitation friendly, interesting, and funny. Don'’ address a person with Dear. Just use their name inside the invitation to make it feel more personal. The short invitation should be one paragraph long. 5 sentences maximum. ")
Generating a campaign idea:
=gpt("Act as a experienced marketing and advertisement professional. Come up with a unique Linkedin advertising campaign idea. Come up with a random product, audience target, and industry. Make me a one-paragraph short summary")
SWOT analysis:
=gpt("Act as brilliant business consultant. We are doing a SWOT analysis. I want you to make a short paragraph for " & B$1 & " about " & $A2 & ". Maximum 5 sentences. Make it a list, and in your list, don't specify which part of SWOT analysis you are covering.")
For editing videos, I use Descript (here is my affiliate link if you don't mind and would like to support my channel): www.descript.com/?lmref=U_q-Kw
Thank you so much for watching and joining me on this journey! Let me know in the comments what you would like to see more of in the future.
Bye!
This is absolutely amazing. I had that extension up and found the 999+ permission asks a bit excessive. Can't wait to plug this in.
That said, did I miss something about how you compiled that database? Have you made that available somewhere or is that your internal work for clients?
So cool to hear you relate to this! Thank you for your comment. And yes, it is for now internal thing. I am still going through it as needed, cleaning it up and polishing it. If enough of people ask, probably it makes sense to share it. (of course, for free :))
@@godago Would be amazinig!
I mean I just saw someone offering 50 prompts for $150 and no guarantee they actually work, and I've already paid $10 for a prompting ebook that didn't have one bit of usable information in it. What I mean is if you release your thing as a pay-what-you-want then I'd rather pay you for stuff I know you worked hard on and is good quality, than pay someone else for nothing of value.
hello could I use the GT4 API in Google sheet and thus have image descriptions in SEO, and that could create my catalog which I will only have to import into my site
Excellent. I really like you showing the demo at the beginning. So many tutorials start with the boring stuff. Also, this example is SUPER practical. Thanks!
Thank you, I appreciate how well edited your videos are, no time wasting!
This video is a fantastic resource for upgrading Google Sheets with the ChatGPT API key and leveraging Canva to transform data tables into visually appealing designs. The step-by-step guide provided by Sjoerd in the blog post is extremely helpful for those who want to enhance their Google Sheets experience with AI capabilities. Thanks for putting this together!
You're a magician. I need to watch and watch again.
I have been using ChatGPT for a while now, but I still found some new information in your video. Great job!
Brava, greatings from Italy (north Italy from Dolomities)
Goda Go, i just found you right now and just I can say I love you. Thank you for sharing your knowledge. :)
Thank you so much for this awesome video!
I got it to work! Thank you🎉
Impressive and insightful explanation 🙏, become quick fan of you 😎
Thanks for your videos, they are very informative! 🙂
you are awesome, thank you for all the knowledge you share!.....i just came across your videos and im blown away.....i had NO IDEA what chatGPT was REALLY capable of......
some of it is rather scary ......
please continue to keep us informed!
Thanks
As always very useful video ma'am. I had some doubts about OpenAI paid account. All are cleared through this video ma'am. Thanks :)
Super, thank you !
Have you already tried microsoft copylot ?
It doesn't work for me for some reason...
Thank you GG❤️ for this
All links and some Spreadsheet prompt examples are in the Description Box. Make sure to check out 🚩Sjoerd’s Blog Post on How to Upgrade Google Sheets with ChatGPT: bit.ly/3B81JeD
Hi Godago! :) Big fan from india first, you are the angel/saviour. I have a request that can you please share that google sheet with chatgpt use cases in all the industries ?🙂🙏
Really great info and easy to do the Sheets integration. thank you! QUESTION: In this script, do you know what the variable "val" is and where it comes from? it's concatenated into the prompt, but where is it defined? I'm experimenting with ways to use dynamic data from cells in the sheet to create prompts and API calls and it looks like rather than concatenating long prompts in the cell, I will need to write them programmatically into the scripts. Thanks for sharing this - love the bonus part about finalizing output in Canva (one of my favorite apps!)
What did you use for you control? What base line are you comparing the result against?
Thank you 🙏🏻
hello what is the difference with the gpt for sheets module?
I have difficulty understanding on my own since I speak poor English
anyway thank you for your videos
great content as usual, keep up u are awesome
Thank you so much for your kind comment!
+1000. Thank you. 😃
I think it's important to consider that, while the ability to customize your own scripts is fantastic when tackling complex tasks, for most people and in most use cases, mastering the Zapier plugin (plugins now being accessible to + users) might be a more user-friendly approach, enabling them to accomplish more. Both methods are worth considering and can be adapted to suit your workflow, style, and needs.
hello do you think I could make image to text with GT4 and Google sheet
Hello, do you think I could do image description in a Google sheet using one of these modules?
So, if you can operate with the table content, that would add like a memory layer? Assuming you can format the info in each cell in a way it's suitable and create the right prompts, could this compare to using agents in some way?
Exactly!
@@godago Been playing with it for a couple hours. It's quite tricky to get usable data, but there's a huge potential!😅
Get it girl 🎉🎉❤
Is there anyway we can connect ChatGPT with MS office documents??
Hi Goda Go. I was wondering, where did you get the dataset with the 660 use cases by industry? I’ve tried googling it but can’t see any reference for it? Thanks
I created it for my personal use. Probably would make sense to release it..
@@godago It would! Please let us know if you do end up releasing the GoogleSheet. :D
Hi fellow prompt engineers I am building a full novel with GPT4 at the moment. I have been working on it for the past four months and I have made significant progress with it. I have the full writing style, the world-building, the plot summary, the character list, and the visual imagery for each scene. Obviously, I am massively exceeding the token limit and had to build it in sections. I am struggling to get the bot to produce any useful writing, but I can't think of any more information to teach it to produce good work. I'd love to hear your ideas!
When I copy down or drag the function to the next field it creates identical copies of the first item generated. Its not giving me new generations every line... can you tell me what I missed
Maybe you converted the field into text only? Can you check if it is still a formula? And also, what is the prompt if you don't mind sharing?
Same shit here
hello I would like to do image description, could I use models other than 3.5?
Yes! In the code you need to tell different link for different model. Basically the link is the same. But ending is whichever model you want to use. :)
@@godago oui je vois qu'il n'y a que deux modèles : gpt3.5 turbo et texte Da Vinci, n'est-ce pas ? mais je ne peux pas utiliser gpt4?
cool!
You have the nicest voice
wow youare awesome
You're among the 3 influencers I'm following on a regulary base since a while. Hi, how are you? Thank you for your work. Get in touch anytime you need my help. Have a good day.
This technology can be a game changer for the marketing business.
Yes! Spot on! Just think about the ideation process for advertisement creatives. Or I also did technical papers and product sheets. I also thought that real estate listings could be automated from spreadsheet to one-pager design in probably 10min.
This is can of sad for me since we cannot pay to use the playground here in Colombia, so there is no GPT Key here, but at least we can pay for ChatGPT Plus. I wish I could find a way around.
Where is the g sheets with use cases?
That would be interesting an useful for many
hello it does not work with chatgpt 4?
That has left me a little disappointed, where is the link for 660 use cases? Have I missed something?
How do we fix this error: "Exception: Cannot call SpreadsheetApp.getUi() from this context."
Did you use Sjords code or chatgpt gave you one?
we are waiting for you new video :(
we missed you... 🙏🏼
The video is coming out at the latest tomorrow! I miss you too!
Google I/O was definitely heavy on AI to the point where I think they're worried about losing money and SEO's are like "oooph"
It is a hooded AGI.
how much money did it take to make all the 660
$50 :(
06:35 what command formula did you put in here?
The videos are good, but I find the audio quality of your voice a bit off and hard to understand sometimes. Consider checking your compression and limiter. 😉
My Sheet with GPT integration worked but there is no GPT button next to 'help'. 🤔
Try to refresh the page. It should appear. If not. The walk around it is to select what you need to be in text values, copy, paste special, paste values only :)
@@godago Thank you! I will try that tomorrow😁
Worked!
I feel happy i am soon out of the work force.
It all looks to overwhelming and impossible to catch up.
Goodnluck with all this shit and jumping to 100 hoops and apps while you get overloaded my your manager since you now have AI to help you...😁😁
I finally realized the symbolism of Goda Go. 🤣 Personally I do think we should be very worried about what has been unleashed upon the world. It’s a fun toy and has many uses, but most people don’t need it. Instead it will be used to control us.
hello could this work with images, I mean image to text
ah. AI for left brains. "Uniting the right-brain dreamers with the left-brain doers." ;-)
I am lost lol
About halfway through your video, my head started hurting because I couldn't understand anything, so I decided to give up. Maybe it's easy stuff for a zoomer like you, but for a dinosaur like me, it's definitely like the Klingon language.
Oh, I am sorry to hear it! Don't give up, I do recognise this could seem a bit harder but choose your battles. There are so many great tools that require no effort. Just all depends what help you need and what is your current workflow. :)
@@godago do you have a website /blog?
Perhaps it wouldn't be a far-fetched idea for you to post an article on your blog for each video, explaining in more detail and in a more didactic manner what you discussed in the video. I know, due to the short attention spans and impatience of today's youth, you have to literally run and cut any space between words. Unfortunately, this is no longer a world for boomers; we prefer measured and well-explained speech. In fact, I invite you to compare the speaking speed of late millennials and centennials with that of boomers and pre-millennials. There's a big difference.
In this regard, for example, I like Lex Fridman. His slow and reflective way of speaking is refreshing. Of course, there are exceptions. Stephen Wolfram, for instance, is a speaking machine gun; his brain is much faster than what his vocal interface allows him to transmit.
But don't worry, the world is changing. Maybe in 50 years, we won't even use our mouths and ears to transmit and receive spoken information, and everything will be through brain interfaces. Or perhaps, due to all these developments in artificial intelligence, we will have become so lazy that most people won't even bother studying anymore, because why would they?
Or maybe we'll all be dead, exterminated by artificial intelligence.
More than anything, this video demonstrates the potential for these LLMs to generate unlimited bullshit at almost zero cost.
And you know what's fun application of this? Exposing how many different outputs to one prompt GPT can provide. I got even, that it can't generate me random names next to other output generating those names.