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!
Негізгі бет How Everyone Upgrades Google Sheets with ChatGPT
Пікірлер: 89