Bulk generate AI meta descriptions in Google Sheets
Let's face it, writing meta descrptions are boring and time-consuming. Writing large numbers of them can feel like a long and thankless task. Wouldn't it be great if you could speed up the process? Maybe even get artificial intelligence to do the bulk of the work for us? Yeah, that would be awesome! I created a handy Google sheet that does it all for you.
Want to know more about AI content (don't worry its not needed for this tool)? Try a free trial with jasper.ai.
Make a copy of this sheet to have a go yourself.
- Language support - enter your language in the settings tab to, hopefully, generate a meta description in your preferred language. This has not been tested yet, so any feedback is welcome.
- Brand inclusion - enter your brand name to have this included within the meta description.
- Emotional goal - add an emotional goal to persuade searchers to click on your site.
- Increased examples - adding extra examples in the settings tab improves the overall quality of the meta descriptions and can make them more diverse. Put examples of meta descriptions that you like in here to improve your results.
How we did it
Special thanks goes to Danny Richman for this one as he did most of the leg work. I merely modify what he created for my own needs. Check out his website now for videos on how to create your own GPT-3 Google sheets.
GPT-3 is the latest in AI content with a wide range of uses, from answering questions to writing computer code. You can even use it to answer questions in the style of John Mueller. We used it to create meta descriptions, then imported the API into a Google Sheet formula so you can do it too.
Here's a step by step guide on how to get started:
Step 1 - Get sheet
Make a copy of this Google sheet. Make sure you include the app script.
Step 2 - Get API key
Head over to https://beta.openai.com/account/api-keys and sign up. Initially, your free trial will give you access to $18 for free, which is plenty for most projects.
Copy your API key and paste it into the Settings tab of your sheet where prompted.
Step 3 - Prime the API
Your AI generator works best when you give it some examples that you like. I've put some examples in the settings tab, so you don't have to change anything, but adding some that perform well in your industry can help improve your results.
Step 4 - Add your keywords
In the "Meta Descriptions" tab, add your list of primary keywords for your landing pages. You can also add some unique selling points of the service you offer to make the results more appealing to your potential customers.
Step 5 - Get meta descriptions
Once you have your keywords set up, use the formula in the top cell to generate your results. This formula will look as follows:
Once entered, you will get a warning message asking you to confirm. Just accept and your meta descriptions will be ready in seconds.
Have a go at tell us what you think!