See llms.txt for all machine-readable content.

Back to Templates

Score and cluster Google keywords with Apify, Groq, Google Sheets and Slack

Created by

Created by: Steadyfetch || steadyfetch
Steadyfetch

Last update

Last update 13 hours ago

Categories

Share

Quick overview

Paste a keyword list into a built-in n8n form and get it back triaged: Google Ads Keyword Planner volume, competition and CPC, an AI intent label, a topic cluster and the page type, ranked by opportunity score in a Google Sheet, with the ten best posted to Slack.

How it works

  1. Submit the built-in n8n form with your keywords, country and language, or run it manually with the demo list.
  2. One HTTP Request runs the Keyword Search Volume Scraper on Apify for the licensed metrics. Keywords Google has no data for are uncharged.
  3. An Information Extractor labels each keyword with its intent, a short topic cluster and the page type worth building.
  4. A Code node scores it: volume x (1 - competition/100) / CPC, favouring high volume, low competition and cheap clicks, then sorts by that score.
  5. Remove Duplicates drops keywords already scored for that country, Sheets appends the rest, and the ten best go to Slack.

Setup

  1. Create an HTTP Header Auth credential (name Authorization, value Bearer YOUR_APIFY_TOKEN) and select it on the HTTP Request node.
  2. Add a Groq credential on the chat model node - a drop-in swap for OpenAI or Anthropic.
  3. Connect Google Sheets and Slack, then open the form URL and paste a list.

Requirements

  • An Apify account, a chat model account, Google Sheets and Slack.
  • Keywords are charged only when Google returns metrics.

Customization

  • Reweight the scoring formula in the Code node.
  • Set mode to ideas in Config to expand every seed into new ideas.

Additional info

SEO and SEM specialists who need Keyword Planner figures without a Google Ads account and want the list triaged before they read it.