What does the "Keyword ideas from your seed topics" workflow do?

Expands the topics you already rank for into related search terms with their monthly volumes, appended to a Google Sheet. It connects Google Sheets and Anthropic. It runs every month on the 1st at 08:00.

Which apps do I need to run "Keyword ideas from your seed topics"?

This template uses Google Sheets and Anthropic. Authenticate each one once from your workspace and the workflow is ready to run. There is no glue code to write or maintain.

Can I customize "Keyword ideas from your seed topics"?

Yes. Once the template is in your workspace it is an ordinary workflow: open it in the builder and change any step, schedule, or condition, or add steps of your own.

All workflows

Keyword ideas from your seed topics

Marketing & Growth

Expands the topics you already rank for into related search terms with their monthly volumes, appended to a Google Sheet.

Add to Workspace

Browse all templates

Every month on the 1st at 08:002 apps4 steps

Apps it connects

Authenticate each one once and the workflow is ready to run.

Google Sheets

Anthropic

What it does

Each integration step this workflow runs, in order, what it is for, and the conditions and loops that decide when it runs.

1Google SheetsCreate tabCreates the 'Keyword ideas' tab on the first run, or adds this month's ideas to the existing one.
If tabIsNew
1. 2Google SheetsAppend rowAppends the header row on a new tab, then one row per idea with the date, seed topic, keyword and monthly searches.
For each topic
1. If ideaCount is more than 0
  For each idea
  If entryOk and term is not empty
  3Google SheetsAppend row
4AnthropicGenerate model responseAsks the AI which five of the saved terms are worth writing about next, with one reason each, shown on the run.

How it works

What happens on each run, in plain English.

At 08:00 on the first of each month, the topics you already rank for are sent to your own keyword data endpoint, and every related term it returns is appended to a Google Sheet with its monthly search volume. It finds the terms you have not written about yet rather than measuring the pages you have.

You end up with a 'Keyword ideas' tab with one row per idea: date collected, seed topic, keyword and monthly searches. Nothing is overwritten, so the sheet also shows how each term's volume moves month to month. An idea missing a keyword or a numeric volume is skipped rather than written as a blank row, a topic the endpoint cannot answer for is reported and passed over, and a cap per topic stops an endpoint flooding the sheet. Once the ideas are saved, AI picks the five worth writing about next and shows the shortlist on the run.

You need your seed topics, a keyword endpoint that returns related terms with search volumes and its key, and a Google Sheet for the history.

seokeyword researchcontent planninggoogle sheetsmonthlyhttp

You may also be interested in

Drip helpful articles to your leadsEvery day, emails the next few leads in your sheet a random article with a short AI note, and comes back to each after a set gap.

Personalised marketing emails from customer dataReads each customer's purchases and feedback, lets AI decide who earns a coupon, and sends a tailored email from Gmail.

Get LinkedIn post ideas from the news in your sheetEvery morning, turns the news logged in your sheet into LinkedIn post ideas for your area of interest, emails them, and clears the sheet.

Nurture leads with a personalised articleEach day, picks an article for every lead due one, by their interests and stage, writes a personal note around it and emails it.

Start from a workflow that already works.

Add "Keyword ideas from your seed topics" to your workspace, connect its apps, and make it yours.

Start Free See Pricing

Free plan, no credit card