n8n Google SERP Intent Finder: DataForSEO + OpenRouter

Find the real search intent behind your keywords—automatically

n8n Google SERP Intent Finder: DataForSEO + OpenRouter reads pending keywords from your Google Sheets, pulls Google’s top 10 using DataForSEO, and then groups the results into search intents with an OpenRouter model—writing a clear intent summary, per-intent stats, and detailed result data back to your sheet.

What this workflow does

• Loads your settings from the Config sheet (sheet URL, OpenRouter model + prompt, and optional data switches).
• Reads the Keywords tab and keeps only rows where status is empty, up to max_keywords.
• For each keyword, uses DataForSEO to fetch Google’s top 10, including People Also Ask, related searches, and the AI Overview when present.
• Optional page coverage digest: if enabled, DataForSEO reads each ranking page as markdown; a Code node measures word count and counts tables, lists, images, and videos, then builds a short digest.
• Optional search metrics: if enabled, DataForSEO Labs adds search volume with monthly history (seasonality computed) and estimated traffic per URL.
• Intent labeling with OpenRouter: the Labeler (Basic LLM Chain + OpenRouter Chat Model) groups results into intents using titles, snippets, and digests only (no numbers).
• Writes back to Google Sheets: Summary, Intents, Results rows are appended; the keyword is marked done or error.

Use cases

• Map keyword lists to SEO content intent clusters for faster briefs.
• Audit SERP patterns for SaaS landing pages by collecting top results + PAA/AI Overview.
• Track intent-level coverage and estimated traffic to prioritize content updates.

Technical details

• n8n nodes/blocks: if, set, code, no op, sticky note, Google Sheets.
• External integration: verified DataForSEO node and OpenRouter Chat Model for intent grouping.
• Outputs: Coverage counts, share/traffic share per intent, dominant intent, reference length, warnings, plus per-result data.