How Everyone Upgrades Google Sheets with ChatGPT

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.

AI Resources I use and recommend (some might be affiliate links):

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

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!

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

[biglaugh]

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

[hcgveganchic]

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

[andreaguerri.educational]

Brava, greatings from Italy (north Italy from Dolomities)

[psychxx]

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.

[dietfitnessweightlosstips]

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

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

[Anki]

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

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

[jawadkhan]

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

[damo]

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

[MalinWale]

Thank you so much for this awesome video!

[traiteursmarseillais]

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

[cgc]

hello it does not work with chatgpt 4?

[АивлдЧовт]

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

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

[MannyBernabe]

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!

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

[ThatsMyKeeper]

you are awesome, thank you for all the knowledge you just came across your videos and im blown had NO IDEA what chatGPT was REALLY capable
some of it is rather scary
please continue to keep us informed!
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!