No video
💥 AI GPT Sheets: I Built an SEO Meta Tag Machine in 9 Mins!😱
Рет қаралды 14,133
Күн бұрынJoin our EXCLUSIVE SEO & Agency community 👉 whop.com/goldi... 🤖📊 Master AI GPT Sheets for SEO in 9 Minutes! 📊🤖
Welcome to the game-changer in content optimization: AI GPT Sheets for SEO! 🚀 In this tutorial, I’ll unveil the secrets of harnessing the power of AI to amp up your SEO game using the GPT Sheets extension on Google Sheets.⚡
📝 What’s in store? 📝
In a crisp 9 minutes, you’ll learn:
✅ How to build an AI-powered SEO meta tag generator with GPT Sheets
✅ The art of effortlessly generating eye-catching article titles
✅ Crafting compelling meta descriptions
✅ Discovering LSI keywords that make your content stand out
✅ Creating structured article outlines with ease
✅ Deciphering keyword search intent to align with your audience
All of this magic happens by just pasting your keyword into a Google Sheet! 🎩💫 No more endless hours spent on research and brainstorming - AI GPT Sheets for SEO is here to take the wheel! 🚗
👩💻 Who is this for? 👨💻
Whether you’re a seasoned blogger, an aspiring content creator, or an SEO wizard, mastering AI GPT Sheets for SEO will revolutionize your approach and set you leagues ahead in the content race. 🏆
👍 Show Some Love! ❤️
If this video turbocharges your SEO game, don’t forget to hit the like button! 👍 Stay on the cutting edge by subscribing for more invaluable AI and SEO tips! 📬
#AIGPTSheetsForSEO #GPTSheets #SEO #MetaTags #ContentOptimization #GoogleSheets #AI #SearchEngineOptimization 🆓FREE ChatGPT Prompts & Scripts Here: 👉 go.juliangoldi...
🔥Get my 89k p/m SEO training program 👉juliangoldie.c...
🚀Want more leads, traffic & sales from SEO? 👉go.juliangoldi...
🔗Order backlinks & save 10% with the code 10OFF👉juliangoldie.s... 🆓FREE ChatGPT Prompts & Scripts Here: 👉 go.juliangoldi...
🔥Get my 89k p/m SEO training program 👉juliangoldie.c...
🚀Want more leads, traffic & sales from SEO? 👉go.juliangoldi...
🔗Order backlinks & save 10% with the code 10OFF👉juliangoldie.s... My favourite SEO Tools👉juliangoldie.c... 💡 Disclaimer: This video is meant for fun and experimental purposes on test websites. Always conduct your own research. Using any experimental SEO comes with its own set of risks.
@JulianGoldieSEO Жыл бұрын
🔗 ChatGPT Prompts & Scripts Here: 👉 go.juliangoldie.com/chat-gpt-prompts 🚀Want more leads, traffic & sales from SEO? 👉go.juliangoldie.com/strategy-session 🔥SEO Coaching Mastermind 👉go.juliangoldie.com/buy-mastermind
@JulianGoldieSEO Жыл бұрын
🔗 Free ChatGPT SEO Course Here: 👉 go.juliangoldie.com/chat-gpt-prompts 🚀SEO Mastermind Program 🔥go.juliangoldie.com/buy-mastermind
@mirzahyder4089 Жыл бұрын
I found a niche with plenty of easy keywords to rank for but the problem is 99% of keywords have zero cpc, will i still make money with AdSense? Btw thanks for all the valuable content
@JulianGoldieSEO Жыл бұрын
You should still get paid for the ads, it's just the RPM might be lower. But it also depends on many other factors too.
@dragqueencommunity Жыл бұрын
thank you for this video and the other full seo sheet. opens up more research ideas beyond blog and keywords.👍
@JulianGoldieSEO Жыл бұрын
Thank you! New template in my latest video.
@rockstar663 Жыл бұрын
Hi Julian. Thank you for the consistently high level of content. I can't keep up I have about 4 tabs open on a given day with your videos. Can you make a video on whether your 888 Descubre Aves blog posts have stayed indexed on Google?
@JulianGoldieSEO Жыл бұрын
Thanks! I might do one soon, honestly not everything on the site is still indexed because it requires more time/trust with Google. Working on solutions!
@GermanRodriguezqndq Жыл бұрын
great video, you just got a new follower, thank you
@JulianGoldieSEO Жыл бұрын
Thanks, and welcome!
@jonathandennis7130 Жыл бұрын
Hi Julian, great article, you mentioned a template you were going to link but I can't see it in the description or comments?
@JulianGoldieSEO Жыл бұрын
🔗 Free ChatGPT SEO Course Here: 👉 go.juliangoldie.com/chat-gpt-prompts
@reshugupta5090 Жыл бұрын
Amezing video!! But i have a question if meta description should not be greater than 200 charector through chatgpt so what function should use?
@JulianGoldieSEO Жыл бұрын
Just limit the character count in the prompt/output :)
@Adrian.Danila Жыл бұрын
Very useful. Thanks Julian!
@JulianGoldieSEO Жыл бұрын
Thank you!
@CherylHenderson007 Жыл бұрын
Great videos! I really enjoy your innovations. They inspire me to experiment mire. Thank you for sharing.
@JulianGoldieSEO Жыл бұрын
Thank you!
@essa-khan Жыл бұрын
Hey julian great work 👍 How many articles we can index with search console per day ..?
@JulianGoldieSEO Жыл бұрын
Thank you! If you hit any indexing limits just use other ways e.g. indexers, social media etc - that way there's no limits.
@vasilipopov4313 Жыл бұрын
Thank you for the video Julian! Have a question. In addition to SEO meta content, I'd be happy to have AI GPT Sheets writing product titles and descriptions as well in the spreadsheet. Would it be enough to slightly modify your prompts, for instance, "Write an SEO-optimized product description: No longer than 200 words. Short. Create curiosity to click on the result. Include the main keyword"?
@JulianGoldieSEO Жыл бұрын
Thanks! Definitely worth testing!
@SuccessTakesPerseverance649 Жыл бұрын
can someone explain what this means please :The model `Give me the SEO search intent for the keyword, explaining what people are searching for` does not exist
@JulianGoldieSEO Жыл бұрын
Where are you seeing that? Do you have a screenshot?
@LesWaller Жыл бұрын
i see the same thing... I changed how I input the formula in the cell, here's my workaround [=GPT("Write an SEO optimized meta title: Keep it short, include the date 2023 + create curiosity: " &A2)]
@JulianGoldieSEO Жыл бұрын
@@LesWaller do you have a screenshot?
@A_Little_O_Everything Жыл бұрын
I just put =gpt(B1 & A2)
@A_Little_O_Everything Жыл бұрын
oh yeah make sure you add the dollar sign in front of the B and the 1
@usamamahmood4822 Жыл бұрын
Wonderful Video...
@JulianGoldieSEO Жыл бұрын
Thank you!
@samjoejar Жыл бұрын
Great info! You gained another follower just because of this. Thanks.
@JulianGoldieSEO Жыл бұрын
Awesome, welcome! Thanks for watching.
@AndreReed-xb2ie Жыл бұрын
Great stuff
@JulianGoldieSEO Жыл бұрын
Thank you!
@punktkommastrich007 Жыл бұрын
🤯💪🏻👍🏻 sooo easy, but soooo great! 🥳🥳🥳
@JulianGoldieSEO Жыл бұрын
Love it!
@geoffmeakin8669 Жыл бұрын
Do you know if its possible to use GPT for sheets to follow a conversation (e.g follow up questions)?
@JulianGoldieSEO Жыл бұрын
Probably, it seems to be endless!
@mikejonson5531 Жыл бұрын
Hi. How can I get a sample table?
@JulianGoldieSEO Жыл бұрын
The template? It's in the free course. 🔗 Free ChatGPT SEO Course Here: 👉 go.juliangoldie.com/chat-gpt-prompts
@reshugupta5090 Жыл бұрын
Dear Julian, I was applying this method but gpt extention needs an API key. so how can I generate with lowest price?
@JulianGoldieSEO Жыл бұрын
Check out my video on PALM 2 yesterday: kzfaq.info/get/bejne/a7Odd5erscymXYk.html - it uses free API tokens
@jakedemichele9083 Жыл бұрын
Hey Julian, awesome videos and great information. Can you make a video on how to hire a team or do you have videos already that you can direct me to? I just stumbled across your videos recently so I was just wondering.
@JulianGoldieSEO Жыл бұрын
Hey Jake, great question thank you! Happy to help on that, any particular SEO hire you're looking to make or questions you'd like me to cover in the video?
@jakedemichele9083 Жыл бұрын
@@JulianGoldieSEO honestly if you can do a breakdown of a team & what there jobs would be & also the best places to find them. Also budget / price range for each team member. I know you can’t give the exact amount but an estimate would be great.
@elliel3869 Жыл бұрын
@@JulianGoldieSEO I would absolutely love this as well! I have no technical skills but I'd love to know where I can go to get VAs to set up a few websites with some articles (I'll be providing) so that I have the templates all set up to go. I feel that this would be invaluable in cutting down the time I take to get started. I feel like my worst enemy and this is my biggest hurdle.
@JulianGoldieSEO Жыл бұрын
Thanks for both your questions! New video on this now - kzfaq.info/get/bejne/o9iooNqUnry8f5s.html
@elliel3869 Жыл бұрын
@@JulianGoldieSEO Many thanks!! Exactly what I needed.
@yousportshd6058 Жыл бұрын
Hi there! Can I use GPT 4, set penalty, temperature, etc with this method? Thanks!
@JulianGoldieSEO Жыл бұрын
You choose the API in GPT Sheets extension, it's up to you. It's an API not playground though so you don't set the temperature, only the type of API model.
@yousportshd6058 Жыл бұрын
@@JulianGoldieSEO Okay mate. Thanks 🙂
@Mike-fx7lq Жыл бұрын
Do you use char GPT 4 for this experiment? Can we use the free version instead? It cannot calculate the 155 max characters when I ask
@JulianGoldieSEO Жыл бұрын
Check out my latest video on PALM 2 here - kzfaq.info/get/bejne/l8hjd7uippqZm3k.html
@ProteoEuthismos 9 ай бұрын
Hey Julian. Massibe thanks fot he Videos. One question. I have ChatGPT Plus. Do i have acces to that API part?
@JulianGoldieSEO 9 ай бұрын
Thanks! The AI is on OpenAI directly in the playground
@dylandevrieze1532 Ай бұрын
Hi Julian, do you have a updated method for this?
@JulianGoldieSEO Ай бұрын
The same method still applies and works
@omonty2 Жыл бұрын
How do we clear the cells without deleting the formulas in the template?
@JulianGoldieSEO Жыл бұрын
Maybe you could ask ChatGPT for an augmentation of the formula
@ortolekuortopedia 7 ай бұрын
Hello Julian. I currently am paying GPT plus, but this seems like doesn't allow me to access the API. DO i need to pay extra?
@JulianGoldieSEO 7 ай бұрын
You'd just use OpenAI Playground
@alexbimo8681 8 ай бұрын
Several weeks ago i see your sheet about topical keyword using google sheet 1 keyword can make 10 title How to do that?
@JulianGoldieSEO 8 ай бұрын
Here you go - kzfaq.info/get/bejne/rqplgMqqq77FeYE.html
@RenddyPhucNguyen Жыл бұрын
So nice
@JulianGoldieSEO Жыл бұрын
Thank you!
@Glenuwaila Жыл бұрын
Why do you get abuse for using yoast? lol
@JulianGoldieSEO Жыл бұрын
I think it's just so basic/simple some people are against it 🤣 But for me simple is better.
@user-bn8jr2df6k Жыл бұрын
Your Titles are so clickbaiting I can't even find the previous video you mentioned in this video. Wow
@JulianGoldieSEO Жыл бұрын
🔗 It's all in my FREE ChatGPT Course with Prompts & Scripts Here: 👉 go.juliangoldie.com/chat-gpt-prompts
@agoogleuser6937 8 ай бұрын
This can be done for free with a GAS
@JulianGoldieSEO 8 ай бұрын
What is that?
@InspireseBrasil Жыл бұрын
=GPT(A2,B2) fiz essa programação conforme o vídeo, porém não excuta, minha língua e português, usei sua tabela do curso de base para edição também não funcionou, o complemento na planilha esta devidamente ativa com API conectado. O que pode esta acontecendo em dar esse erro ?
@JulianGoldieSEO Жыл бұрын
Sorry I don't understand
@InspireseBrasil Жыл бұрын
=GPT(A2,B2) I made this schedule according to the video, but it does not work, my language is Portuguese, I used your base course table for editing, it also did not work, the complement in the spreadsheet is properly active with the API connected. What could be happening with this error?
@JulianGoldieSEO Жыл бұрын
What's the error message you're getting?
@InspireseBrasil Жыл бұрын
@@JulianGoldieSEO I managed to identify the error
@JulianGoldieSEO Жыл бұрын
Nice!
Julian Goldie SEO
Рет қаралды 12 М.
TechLead
Рет қаралды 1,3 МЛН
Евгений Костин
Рет қаралды 13 М.