<aside> 🚨 Want more notes like this? Subscribe to weekly strategy emails: seonotebook.com

</aside>

Today’s note was inspired by an article by my friend and skilled SEO Israel Gaudette. You can read his blog and try his method using the ChatGPT interface.

I decided to take Israel’s idea of generating anchor text with ChatGPT and bring it into Google Sheets using GPT For Sheets and Docs.

You’ll be able to generate hundreds of anchor texts for dozen of blog titles in seconds:

Before you try this, you’ll need to install GPT for Sheets and Docs. Then you will also need an OpenAI API key. I’m not going to document all those steps, but you can find out more info on that here.

If you already have an OpenAI account, click here to create a new API key.

With that out of the way, here’s the template you’ll need to generate anchor text for any blog title you wish!

👇

https://docs.google.com/spreadsheets/d/1buUD1Sl1F93IWq7bHSOhMaGnWzV97UnP-VyNlyPynSQ/edit?usp=sharing

Here’s the prompt / formula that makes the magic happen: