Keyword ideas from your seed topics

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.

Run every month on day 1 at 08:00.Run every month on day 1 at 08:00.

Set seedTopics to blank.Set seedTopics to blank.

Set keywordApiUrl to blank.Set keywordApiUrl to blank.

Set keywordApiKey to blank.Set keywordApiKey to blank.

Set spreadsheetUrl to blank.Set spreadsheetUrl to blank.

Set sheetTab to Keyword ideas.Set sheetTab to Keyword ideas.

Set maxIdeasPerTopic to 25.Set maxIdeasPerTopic to 25.

Set country to us.Set country to us.

Trim keywordApiUrl and save it as keywordApiUrl.Trim keywordApiUrl and save it as keywordApiUrl.

If keywordApiUrl is emptyIf keywordApiUrl is empty

Yes

Stop and report a problem: Fill in the 'keywordApiUrl' step with the address of your keyword data endpoint, then run it again.Stop and report a problem: Fill in the 'keywordApiUrl' step with the address of your keyword data endpoint, then run it again.

No

No steps

Get today's date and save it as collectedOn.Get today's date and save it as collectedOn.

Set tabIsNew to false.Set tabIsNew to false.

If a step below fails, save the error as tabErrorIf a step below fails, save the error as tabError

Try

Google SheetsCreate the tab sheetTab in spreadsheetUrl.Create the tab sheetTab in spreadsheetUrl.

Change tabIsNew to true.Change tabIsNew to true.

On error

Show in the output: Adding this month's keyword ideas to the existing '@sheetTab' tab.Show in the output: Adding this month's keyword ideas to the existing '@sheetTab' tab.

If tabIsNew is yesIf tabIsNew is yes

Yes

Google SheetsAdd a row to sheetTab in spreadsheetUrl.Add a row to sheetTab in spreadsheetUrl.

No

No steps

Split seedTopics by , and save it as topics.Split seedTopics by , and save it as topics.

Set ideasRecorded to 0.Set ideasRecorded to 0.

Set ideaLines to an empty list.Set ideaLines to an empty list.

For each topic in topics:For each topic in topics:

Trim topic and save it as seed.Trim topic and save it as seed.

If seed is emptyIf seed is empty

Yes

Skip to the next item.Skip to the next item.

No

No steps

Set reply to an empty record.Set reply to an empty record.

Set fetchOk to false.Set fetchOk to false.

If a step below fails, save the error as fetchErrorIf a step below fails, save the error as fetchError

Try

Send data to keywordApiUrl and save it as reply.Send data to keywordApiUrl and save it as reply.

Change fetchOk to true.Change fetchOk to true.

On error

Show in the output: Could not fetch keyword ideas for '@seed': fetchError.message with keywordApiUrl replaced by the endpoint address.Show in the output: Could not fetch keyword ideas for '@seed': fetchError.message with keywordApiUrl replaced by the endpoint address.

If fetchOk is noIf fetchOk is no

Yes

Skip to the next item.Skip to the next item.

No

No steps

Set ideaList to reply.body.keywords.Set ideaList to reply.body.keywords.

Set ideaCount to 0.Set ideaCount to 0.

If a step below fails, save the error as shapeErrorIf a step below fails, save the error as shapeError

Try

Count the items in ideaList and save it as ideaCount.Count the items in ideaList and save it as ideaCount.

On error

Show in the output: No 'keywords' list came back for '@seed', so nothing was recorded for it.Show in the output: No 'keywords' list came back for '@seed', so nothing was recorded for it.

If ideaCount is greater than 0If ideaCount is greater than 0

Yes

Set recordedForTopic to 0.Set recordedForTopic to 0.

For each idea in ideaList:For each idea in ideaList:

If recordedForTopic is greater than or equal to maxIdeasPerTopic If recordedForTopic is greater than or equal to maxIdeasPerTopic

Yes

Stop repeating.Stop repeating.

No

No steps

Set term to blank. Set term to blank.

Set volume to 0. Set volume to 0.

Set entryOk to false. Set entryOk to false.

If a step below fails, save the error as entryError If a step below fails, save the error as entryError

Try

Trim idea.keyword and save it as term.Trim idea.keyword and save it as term.

Round idea.search_volume to the nearest integer and save it as volume.Round idea.search_volume to the nearest integer and save it as volume.

Change entryOk to true.Change entryOk to true.

On error

Show in the output: Skipped an idea for '@seed' that did not carry both a keyword and a numeric monthly search volume.Show in the output: Skipped an idea for '@seed' that did not carry both a keyword and a numeric monthly search volume.

If entryOk is yes and term isn't empty If entryOk is yes and term isn't empty

Yes

Google SheetsAdd a row to sheetTab in spreadsheetUrl.Add a row to sheetTab in spreadsheetUrl.

Add 1 to recordedForTopic.Add 1 to recordedForTopic.

Add 1 to ideasRecorded.Add 1 to ideasRecorded.

Add term - volume searches a month to the end of ideaLines and save it as ideaLines.Add term - volume searches a month to the end of ideaLines and save it as ideaLines.

No

No steps

No

No steps

If ideasRecorded is 0If ideasRecorded is 0

Yes

Finish the run: No keyword ideas came back for seedTopics this month, so nothing was recorded. Check the 'keywordApiUrl' and 'keywordApiKey' steps if this repeats.Finish the run: No keyword ideas came back for seedTopics this month, so nothing was recorded. Check the 'keywordApiUrl' and 'keywordApiKey' steps if this repeats.

No

No steps

If a step below fails, save the error as shortlistErrorIf a step below fails, save the error as shortlistError

Try

ClaudeAsk Claude: 'You are helping a marketer decide what to write next. Below are keyword ideas collected this month for these topics: seedTopics.Ask Claude: 'You are helping a marketer decide what to write next. Below are keyword ideas collected this month for these topics: seedTopics. Each line is a search term and how many times it is searched a month. ideaLines joined by a new line truncated to 6000 characters Pick the five worth writing about next and give one short reason for each, based only on the lines above. Reply as a plain list with no preamble.'. Save it as suggestion. Maximum response length: 600

Show in the output: Worth writing next:Show in the output: Worth writing next: suggestion.response_text.

On error

Show in the output: Saved ideasRecorded keyword ideas to the '@sheetTab' tab. No shortlist was produced this run - connect Claude on the 'suggestion' step to get one.Show in the output: Saved ideasRecorded keyword ideas to the '@sheetTab' tab. No shortlist was produced this run - connect Claude on the 'suggestion' step to get one.