<aside> 🚨 Want more notes like this? Subscribe to weekly strategy emails: seonotebook.com
</aside>
Join the free SEO Notebook WhatsApp Channel:
Before we begin, a massive shoutout to Wil Reynolds and JC Chouinard for inspiring this post. Without their smarts, it wouldn’t have been possible.
Me and the team at Notebook have taken Wil’s original idea and made it more user-friendly, faster and cheaper since it doesn’t require a GPT for Sheets subscription (that part is thanks the the yeoman-like effort of fellow 🇨🇦 JC Chouinard).
Let me first explain what this note is all about:
Wil created a template where you can paste in questions/queries and the sheet will automatically pull in answers from the Open AI API.
Cool, but where’s the magic, Steve?
Well, there’s also a tab in the sheet where you paste in your brand variations and the sheet will automagically detect brand mentions in the LLM answers to those queries! On top of that, it’ll spit out an overall visibility score based on how often your brand appears in these answers!!
Great, but why aren’t we just using Wil’s original template, Steve?
Glad you asked Notebooker! Wil’s version requires a GPT for Sheets subscription, ours doesn't (thanks to JC Chouinard🙏)!
We also took out an extra step so that the brand mention are detected directly from the GPT output without having to paste into the next cell. Score!
There are instructions on the START HERE TAB of the template, but you can also follow along here: