Find the posts Google already wants you to write
Google's already showing you what people search for. AI turns that list into a ranked plan of posts to write.
A sketch of what you'll get back.
Your prompt
Fill in your details. Skip any you like.
ChatGPT and Claude open with your prompt already typed in. Gemini can't be filled in from a link, so its button copies your prompt: paste it into the new chat.
The prompt that gets copied
I've uploaded two files from my Google Search Console: Queries.csv (the searches I show up for) and Pages.csv (my pages). My business is [YOUR OFFER, e.g. career coaching] for [YOUR IDEAL CLIENT, e.g. nurses leaving bedside care]. Find the search queries where I'm getting impressions but don't have a page that really answers that question. For each gap, tell me: 1. The query, its impressions, and my current position. 2. Which of my pages shows up for it now, if any. 3. Whether it's a buyer question (someone close to hiring) or a curious question. 4. A working title for a new post or page that answers it directly. Group similar queries together so I don't write the same post twice. Rank the list so the buyer questions with the most impressions are at the top. Give me the top 10, then a short list of quick wins where I should improve an existing page instead.
Export a year of your Google Search Console data and AI finds the searches you already show up for but don't have a real page about.
Step by step
- In Google Search Console, open Performance and set the date range to 12 months.
- Click Export and download the files. Keep Queries.csv and Pages.csv.
- Upload both files to your AI and paste the prompt.
- Write the top 3 posts first, then check your results again in a month.
What you'll get
A ranked top 10 list of posts to write, grouped by topic, with titles and buyer intent, plus quick wins for pages you already have.
- Made for
- Coaches, Consultants, Creators, Small business owners
- Works in
- ChatGPT, Claude, Gemini
