How Everyone Upgrades Google Sheets with ChatGPT

Рет қаралды 51,153

Күн бұрын

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!

Пікірлер: 89

@followthemoonrabbit Жыл бұрын

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?

@godago Жыл бұрын

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 :))

@ZukunftBilden Жыл бұрын

@@godago Would be amazinig!

@followthemoonrabbit Жыл бұрын

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.

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

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

@420damo Жыл бұрын

Thank you, I appreciate how well edited your videos are, no time wasting!

@MannyBernabe 11 ай бұрын

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!

@pathmonkofficial Жыл бұрын

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!

@godago Жыл бұрын

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

@vishaldelhi123 Жыл бұрын

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

@creatorsmafia Жыл бұрын

I have been using ChatGPT for a while now, but I still found some new information in your video. Great job!

@Rachidasister Жыл бұрын

You're a magician. I need to watch and watch again.

@MalinWale 11 ай бұрын

Thank you so much for this awesome video!

@thesampleuniverse 11 ай бұрын

I got it to work! Thank you🎉

@renehernandez3741 Жыл бұрын

Goda Go, i just found you right now and just I can say I love you. Thank you for sharing your knowledge. :)

@andreaguerri.educational 3 ай бұрын

Brava, greatings from Italy (north Italy from Dolomities)

@withchefmonica Жыл бұрын

Thank you GG❤️ for this

@djjupa Жыл бұрын

Thanks for your videos, they are very informative! 🙂

@ThatsMyKeeper Жыл бұрын

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

@gpb1976 Жыл бұрын

Impressive and insightful explanation 🙏, become quick fan of you 😎

@calumscott.1442 3 ай бұрын

Thank you 🙏🏻

@Anki077 Жыл бұрын

As always very useful video ma'am. I had some doubts about OpenAI paid account. All are cleared through this video ma'am. Thanks :)

@MFJLabs Жыл бұрын

+1000. Thank you. 😃

@agnesslovehealz Жыл бұрын

Get it girl 🎉🎉❤

@sharifalahmed7288 Жыл бұрын

great content as usual, keep up u are awesome

@godago Жыл бұрын

Thank you so much for your kind comment!

@davidjackson7675 10 ай бұрын

What did you use for you control? What base line are you comparing the result against?

@loverofliberties Жыл бұрын

You have the nicest voice

@psychxx7146 Жыл бұрын

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.

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

hello do you think I could make image to text with GT4 and Google sheet

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

Hello, do you think I could do image description in a Google sheet using one of these modules?

@AI-antics Жыл бұрын

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!

@PaulFletter Жыл бұрын

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!)

@user-iq1zn9lo7q Жыл бұрын

Super, thank you ! Have you already tried microsoft copylot ? It doesn't work for me for some reason...

@My-Life_ Жыл бұрын

cool!

@johncmoore416 Жыл бұрын

This technology can be a game changer for the marketing business.

@godago Жыл бұрын

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.

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

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

@Orrouk Жыл бұрын

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.

@siddharthsingh5169 Жыл бұрын

wow youare awesome

@gpb1976 Жыл бұрын

Is there anyway we can connect ChatGPT with MS office documents??

@hcgveganchic8619 Жыл бұрын

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

@godago Жыл бұрын

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?

@HredFuzz Жыл бұрын

Same shit here

@pamirarcosa Жыл бұрын

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?

@godago Жыл бұрын

Exactly!

@pamirarcosa Жыл бұрын

@@godago Been playing with it for a couple hours. It's quite tricky to get usable data, but there's a huge potential!😅

@MarkLLynch Жыл бұрын

It is a hooded AGI.

@traiteursmarseillais9426 6 күн бұрын

Hi ! Is there any update or new version of this? I tried in every ways but can’t h’get it working. The function got is not even recognised ! Anyone can help please

@landonlandon2251 9 ай бұрын

Where is the g sheets with use cases?

@frida507 7 ай бұрын

That would be interesting an useful for many

@cgc2300 7 ай бұрын

hello it does not work with chatgpt 4?

@cgc2300 7 ай бұрын

hello I would like to do image description, could I use models other than 3.5?

@godago 7 ай бұрын

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. :)

@cgc2300 7 ай бұрын

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

@DetPrep Жыл бұрын

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.

@user-ek4zw7np3h Жыл бұрын

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

@godago Жыл бұрын

I created it for my personal use. Probably would make sense to release it..

@user-ek4zw7np3h Жыл бұрын

@@godago It would! Please let us know if you do end up releasing the GoogleSheet. :D

@jawadkhan9688 11 күн бұрын

isn't Gemini is already built in Google sheet..?

@ahmetdastan9719 Жыл бұрын

we are waiting for you new video :( we missed you... 🙏🏼

@godago Жыл бұрын

The video is coming out at the latest tomorrow! I miss you too!

@kgal1298 Жыл бұрын

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"

@biglaugh62 Жыл бұрын

How do we fix this error: "Exception: Cannot call SpreadsheetApp.getUi() from this context."

@godago Жыл бұрын

Did you use Sjords code or chatgpt gave you one?

@dietfitnessweightlosstips2830 Ай бұрын

That has left me a little disappointed, where is the link for 660 use cases? Have I missed something?

@ahmed-eslam Жыл бұрын

how much money did it take to make all the 660

@godago Жыл бұрын

$50 :(

@flufflessMC Жыл бұрын

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. 😉

@TheClassyHacker Жыл бұрын

My Sheet with GPT integration worked but there is no GPT button next to 'help'. 🤔

@godago Жыл бұрын

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 :)

@TheClassyHacker Жыл бұрын

@@godago Thank you! I will try that tomorrow😁

@TheClassyHacker Жыл бұрын

Worked!

@smetljesm2276 Жыл бұрын

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...😁😁

@blueskiesandgreenpasturesp3848 Жыл бұрын

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.

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

hello could this work with images, I mean image to text

@oryxchannel Жыл бұрын

ah. AI for left brains. "Uniting the right-brain dreamers with the left-brain doers." ;-)

@avamaria8447 Жыл бұрын

I am lost lol

@illogicmath Жыл бұрын

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.

@godago Жыл бұрын

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. :)

@illogicmath Жыл бұрын

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

@jeffreystringer Жыл бұрын

More than anything, this video demonstrates the potential for these LLMs to generate unlimited bullshit at almost zero cost.

@godago Жыл бұрын

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.