The AI Keyword Sheet

Your keyword list is not how people talk to AI

The AI Keyword Sheet is a free Google Sheet that converts an SEO keyword export into AI search prompts in bulk. Paste your keywords from Search Console, Ahrefs, or Semrush, and it rewrites each one as the exact question a real person would type into ChatGPT or Gemini, then identifies the persona, goal, and intent behind it.

Here is why that matters. Nobody types "seo agency melbourne" into ChatGPT. They type "Can you recommend a professional SEO agency in Melbourne?" Those are the queries AI assistants actually answer, and if you have only ever looked at your keywords as keywords, you have never seen what your market sounds like when it asks an AI for help.

We built this sheet at StudioHawk because every AI visibility project starts the same way: take the keyword set that already drives the business, and work out what those keywords look like as conversations. Doing that one keyword at a time is painful. The sheet does hundreds of rows at once.

How the sheet works

The sheet runs on the =AI() formula, Google Sheets' built-in Gemini function. Each row sends your keyword through two prompts: one rewrites it as the question a real person would ask an AI assistant, the other identifies who is asking and why. No add-ons, no scripts, no API key.

1. 1

   Make a copyClick the button above. The sheet lands in your own Google Drive with the formulas intact and two example rows showing the output format.

2. 2

   Paste your keyword exportExport your queries from Google Search Console, Ahrefs, or Semrush and paste them into column A from row 4 onward, replacing the examples. Start with your top 100 by impressions.

3. 3

   Drag the formulas downCopy the AI Term and Audience Context cells down to cover your rows, give Sheets a moment to generate, and you have an AI-query version of your entire keyword set.

The two prompts behind it

Nothing is hidden. These are the exact prompts wired into the sheet's formulas, so you can adjust them, tighten them for your niche, or lift them into any other tool.

Rewrite this SEO keyword as the exact question or request a real person would type into an AI assistant like ChatGPT or Gemini. ONE line, maximum 12 words. Keep the same intent and any brand, product, or location from the keyword. Do not answer the question. No quotes, no preamble, no explanation. Example so you know the format only: Keyword: best running shoes -> Output: What are the best running shoes for everyday training? Derive every word from the actual keyword below; never reuse the example wording. Keyword: [your keyword]

Identify the target audience for this SEO keyword. Output format: persona; goal; intent. Maximum 10 words total. Sentence fragments separated by semicolons, never full sentences, never first person. Intent must be exactly one of: informational, commercial, transactional, local. Example so you know the format only: Keyword: best running shoes -> Output: Runner; comparing running shoe brands; commercial. Derive every word from the actual keyword below; never reuse wording from the example or these instructions. If the keyword is a brand name or unclear, describe whoever would plausibly search it. Never refuse, never explain. Output plain text only. Keyword: [your keyword]

What to do with the output

The converted list is the raw material for your AI search strategy. Three moves, in order:

• Test your visibility. Take your top 20 AI questions and run them through our AI Citation Monitor skill. It checks whether ChatGPT, Claude, Perplexity, and Gemini actually cite your brand when people ask those questions.
• Check your pages answer the question. A page optimised for "seo agency melbourne" might never answer "can you recommend an SEO agency in Melbourne?" in plain language. The AI question column tells you the exact phrasing your page should address head-on.
• Sort by intent before you act. The third column classifies every keyword as informational, commercial, transactional, or local. Commercial and local questions are where AI assistants make recommendations, so they get priority.

If you want ready-made prompts for the rest of your SEO workflow, the AI SEO prompts library covers audits, content briefs, and technical checks. And if you are new to installable skills, start with what Claude SEO skills are and how they work.