{"product_id":"google-serp-searchapi-openai-intent-analyzer-for-n8n-data-table","title":"Google SERP SearchAPI + OpenAI Intent Analyzer for n8n Data Table","description":"\u003ch3\u003eInstantly map keyword intent using live Google SERPs—then save results to an n8n Data Table\u003c\/h3\u003e\n\u003cp\u003eThis n8n workflow takes a comma-separated list of keywords, pulls the first-page Google SERP for each one via \u003cstrong\u003eSearchApi\u003c\/strong\u003e, and uses \u003cstrong\u003eOpenAI\u003c\/strong\u003e to classify the dominant search intent. The final output—intent, confidence, rationale, content format, and content ideas—is automatically appended as rows in your \u003cstrong\u003e“Search Intent Analysis”\u003c\/strong\u003e n8n Data Table.\u003c\/p\u003e\n\n\u003ch3\u003eWhat this workflow does\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eRuns manually\u003c\/strong\u003e when you click \u003cem\u003eExecute\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eReads inputs\u003c\/strong\u003e from the workflow Settings step: a comma-separated keyword list, plus your target \u003cstrong\u003elocation\u003c\/strong\u003e and \u003cstrong\u003elanguage\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eQueries Google with SearchApi\u003c\/strong\u003e for each keyword to fetch the first-page SERP.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eExtracts SERP intent signals\u003c\/strong\u003e from visible features such as ads, shopping results, featured snippets, People Also Ask, local intent, video signals, and the top organic results.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eFeeds SERP evidence to OpenAI\u003c\/strong\u003e to produce a \u003cstrong\u003eJSON\u003c\/strong\u003e analysis including intent, confidence, rationale, content format, and content ideas.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eParses the OpenAI response\u003c\/strong\u003e and appends one row per keyword to the \u003cstrong\u003e“Search Intent Analysis”\u003c\/strong\u003e Data Table, including \u003cem\u003eanalyzed_at\u003c\/em\u003e.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eUse cases\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSEO content planning\u003c\/strong\u003e: identify whether keywords are informational, commercial, navigational, or local—and plan accordingly.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eCompetitive content strategy\u003c\/strong\u003e: compare SERP patterns (snippets, PAA, video, shopping) to shape your content format.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSaaS marketing ops\u003c\/strong\u003e: batch analyze keyword sets and keep a searchable record of intent signals over time.\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003eTechnical details\u003c\/h3\u003e\n\u003cul\u003e\n  \u003cli\u003e\n\u003cstrong\u003eSearchApi Google Search\u003c\/strong\u003e step: add your SearchApi credential and set \u003cstrong\u003elocation\u003c\/strong\u003e and \u003cstrong\u003elanguage\u003c\/strong\u003e.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003eOpenAI intent analysis\u003c\/strong\u003e step: add your OpenAI credential and choose the model.\u003c\/li\u003e\n  \u003cli\u003e\n\u003cstrong\u003en8n Data Table\u003c\/strong\u003e: create\/select “Search Intent Analysis” with columns for \u003cem\u003ekeyword, intent, confidence, rationale, content_format, content_ideas, serp_signals, analyzed_at\u003c\/em\u003e.\u003c\/li\u003e\n  \u003cli\u003eIncludes workflow nodes such as \u003cstrong\u003eManual Trigger\u003c\/strong\u003e, \u003cstrong\u003eSet\u003c\/strong\u003e, \u003cstrong\u003eCode\u003c\/strong\u003e, \u003cstrong\u003eData Table\u003c\/strong\u003e, and a \u003cstrong\u003eLangChain OpenAI\u003c\/strong\u003e integration component.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"N8N Commerce","offers":[{"title":"Default Title","offer_id":45767898300595,"sku":"N8N-17876","price":46.99,"currency_code":"GBP","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0749\/6279\/6723\/files\/Uc6ZafGOSKOpHr4ssSbPU_SjEq0lDb.png?v=1786093636","url":"https:\/\/buyflowscripts.com\/products\/google-serp-searchapi-openai-intent-analyzer-for-n8n-data-table","provider":"N8N Commerce","version":"1.0","type":"link"}