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: https://bit.ly/3B81JeD
🚩Get OpenAI API Key Here: https://platform.openai.com/
🚩Canva: https://www.canva.com/
🚩OpenAI Pricing: https://openai.com/pricing
🎙️ Podcast: https://bit.ly/3LSrPIN @HTTTA
💌 Newsletter: https://bit.ly/44ttqw0
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.”)
AI Resources I use and recommend (some might be affiliate links):
🔥Text Blaze for quick prompt recall: https://textblaze.me/godago
🔥 SnackPrompt for the prompt organization: https://bit.ly/3UVv3hF
🔥 PromptPerfect for prompt optimization: https://promptperfect.jina.ai/
🔥Learn Prompting https://bit.ly/3YvFids
For editing videos, I use Descript (here is my affiliate link if you don’t mind and would like to support my channel): https://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!
