{"product_id":"n8n-google-serp-intent-finder-dataforseo-openrouter","title":"n8n Google SERP Intent Finder: DataForSEO + OpenRouter","description":"\u003ch3\u003eFind the real search intent behind your keywords—automatically\u003c\/h3\u003e\n\u003cp\u003e\u003cstrong\u003en8n Google SERP Intent Finder: DataForSEO + OpenRouter\u003c\/strong\u003e reads pending keywords from your Google Sheets, pulls Google’s top 10 using \u003cstrong\u003eDataForSEO\u003c\/strong\u003e, and then groups the results into \u003cstrong\u003esearch intents\u003c\/strong\u003e with an \u003cstrong\u003eOpenRouter\u003c\/strong\u003e model—writing a clear intent summary, per-intent stats, and detailed result data back to your sheet.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eLoads your settings\u003c\/strong\u003e from the Config sheet (sheet URL, OpenRouter model + prompt, and optional data switches).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads the Keywords tab\u003c\/strong\u003e and keeps only rows where \u003cem\u003estatus is empty\u003c\/em\u003e, up to \u003cem\u003emax_keywords\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eFor each keyword, uses \u003cstrong\u003eDataForSEO\u003c\/strong\u003e to fetch \u003cstrong\u003eGoogle’s top 10\u003c\/strong\u003e, including \u003cstrong\u003ePeople Also Ask\u003c\/strong\u003e, \u003cstrong\u003erelated searches\u003c\/strong\u003e, and the \u003cstrong\u003eAI Overview\u003c\/strong\u003e when present.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional page coverage digest\u003c\/strong\u003e: if enabled, DataForSEO reads each ranking page as markdown; a Code node measures word count and counts \u003cstrong\u003etables, lists, images, and videos\u003c\/strong\u003e, then builds a short digest.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOptional search metrics\u003c\/strong\u003e: if enabled, DataForSEO Labs adds \u003cstrong\u003esearch volume with monthly history\u003c\/strong\u003e (seasonality computed) and \u003cstrong\u003eestimated traffic per URL\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eIntent labeling with OpenRouter\u003c\/strong\u003e: the Labeler (Basic LLM Chain + OpenRouter Chat Model) groups results into intents using \u003cstrong\u003etitles, snippets, and digests only\u003c\/strong\u003e (no numbers).\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eWrites back to Google Sheets\u003c\/strong\u003e: Summary, Intents, Results rows are appended; the keyword is marked \u003cstrong\u003edone\u003c\/strong\u003e or \u003cstrong\u003eerror\u003c\/strong\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003eMap keyword lists to \u003cstrong\u003eSEO content intent clusters\u003c\/strong\u003e for faster briefs.\u003c\/li\u003e\n  \u003cli\u003eAudit SERP patterns for SaaS landing pages by collecting top results + PAA\/AI Overview.\u003c\/li\u003e\n  \u003cli\u003eTrack intent-level coverage and estimated traffic to prioritize content updates.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n nodes\/blocks\u003c\/strong\u003e: if, set, code, no op, sticky note, Google Sheets.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExternal integration\u003c\/strong\u003e: verified \u003cstrong\u003eDataForSEO\u003c\/strong\u003e node and \u003cstrong\u003eOpenRouter\u003c\/strong\u003e Chat Model for intent grouping.\u003c\/li\u003e\n  \u003cli\u003eOutputs: Coverage counts, share\/traffic share per intent, dominant intent, reference length, warnings, plus per-result data.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":46146446426291,"sku":"N8N-20213","price":73.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/X4LvfAfzsViyklbtWMC09_QiTLOABq.png?v=1790846966","url":"https:\/\/buyflowscripts.com\/products\/n8n-google-serp-intent-finder-dataforseo-openrouter","provider":"N8N Commerce","version":"1.0","type":"link"}