Score and cluster Google keywords with Apify, Groq, Google Sheets and Slack
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 17 nodes and runs when someone submits an n8n form (“Keyword opportunity check”) (plus 1 other trigger). Along the way it connects Groq Chat Model, Google Sheets and Slack.
How it runs
Trigger: When someone submits an n8n form (“Keyword opportunity check”) (plus 1 other trigger).
- Config (Edit Fields (Set)): sets 5 fields: keywordsText, country, language…
- Look up volume and CPC (HTTP Request): calls an HTTP API (POST)
- Keyword rows only (skip the run summary) (If): checks a condition and branches into true / false
- Read the search intent (Information Extractor): extracts structured fields from text with AI, with model: Groq Chat Model
- Score the opportunity (Code): runs custom JavaScript code
- Best opportunities first (Sort): sorts the items
- Only keywords we have not scored before (Remove Duplicates): removes duplicate items
- Any new keywords? (If): checks a condition and branches into true / false
- Column order (Edit Fields (Set)): sets 16 fields: rank, keyword, country…
- Append the new rows to Google Sheets (Google Sheets): append
…plus 3 more steps. See the full node list below.
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
- Still check Always Output Data on multi-output nodes (If/Switch) now adds an empty item only when every output is empty (Keyword rows only (skip the run summary)).
Nodes used (14)
- n8n Form Trigger
n8n-nodes-base.formTrigger - Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - HTTP Request
n8n-nodes-base.httpRequest - If
n8n-nodes-base.if - Information Extractor
@n8n/n8n-nodes-langchain.informationExtractor - Groq Chat Model
@n8n/n8n-nodes-langchain.lmChatGroq - Code
n8n-nodes-base.code - Sort
n8n-nodes-base.sort - Remove Duplicates
n8n-nodes-base.removeDuplicates - No Operation, do nothing
n8n-nodes-base.noOp - Google Sheets
n8n-nodes-base.googleSheets - Aggregate
n8n-nodes-base.aggregate - Slack
n8n-nodes-base.slack
From the author
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…