Keyword Clustering Template
Cluster keywords by topic and search intent in Google Sheets with =GPT_CLASSIFY() and =GPT_TAG(). Free AI template for content planning.
Group a raw keyword export into topics and intents — the step between “here’s 2,000 keywords from Ahrefs” and an actual content plan.
Layout
| Column | Content | Formula |
|---|---|---|
| A | Keyword | — |
| B | Search intent | =GPT_CLASSIFY(A2, "informational, commercial, transactional, navigational") |
| C | Topic cluster | =GPT("Assign a 2-3 word topic cluster for this keyword. Return only the cluster name.", A2) |
| D | Suggested page type | =GPT_CLASSIFY(A2, "blog post, product page, comparison, template, docs") |
Then pivot by column C to see cluster sizes and pick pages to build.
Consistent clusters across runs
List allowed clusters in one cell ($F$1) and classify against it:
=GPT_CLASSIFY(A2, $F$1)
Get started
- Install GPT for Sheets from the Google Workspace Marketplace (free tier included, no API keys needed).
- Copy the template or paste the formulas into your own sheet.
- Drag the formula down your rows, then use Replace all GPT formulas with results in the sidebar.
Related: check indexing in Google Sheets, meta tags template.
FAQ
How many keywords can I cluster?
Thousands — drag the formula down the export. At 10,000 results per hour a 2,000-keyword sheet clusters in minutes.
Will clusters be consistent?
Use a fixed cluster list in a cell and =GPT_CLASSIFY() against it — the model then always picks from your taxonomy instead of inventing names.
Can it use my Ahrefs/Semrush export directly?
Yes — paste the export as-is; the formulas only need the keyword column.