Expands the topics you already rank for into related search terms with their monthly volumes, appended to a Google Sheet.
Uses
Claude
Google Sheets
Keyword ideas from your seed topics
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 emptyYes
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 tabErrorTry
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 yesYes
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 emptyYes
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 fetchErrorTry
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 noYes
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 shapeErrorTry
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 0Yes
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 maxIdeasPerTopicYes
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 entryErrorTry
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 emptyYes
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 0Yes
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 shortlistErrorTry
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: 600Show 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.