How Everyone Upgrades Google Sheets with ChatGPT
🚨 https://aiproductivityhub.ai/ Get the most powerful no-code AI automation engine (JarvisJr)
& Unlock $ 1/year lifetime plan of AI Productivity Hub. ✨ Crazy 𝗡𝗲𝘄 𝗬𝗲𝗮𝗿 𝗢𝗳𝗳𝗲𝗿 𝗲𝗻𝗱𝘀 𝗗𝗲𝗰 𝟮𝟴 @ 𝟮 𝗽𝗺 𝗣𝗦𝗧
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
🎙️ Listen to Wes and I jazz around all things AI on @HTTTA Podcast: https://bit.ly/3LSrPIN
💌 Subscribe to the Newsletter: https://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! ✅ https://bit.ly/42Grj64
🔥Text Blaze for quick prompt recall: https://textblaze.me/godago
🔥 SnackPrompt for the prompt organization: https://bit.ly/3UVv3hF
🔥Learn Prompting https://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): 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!
