Google SERP SearchAPI + OpenAI Intent Analyzer for n8n Data Table

Instantly map keyword intent using live Google SERPs—then save results to an n8n Data Table

This n8n workflow takes a comma-separated list of keywords, pulls the first-page Google SERP for each one via SearchApi, and uses OpenAI to classify the dominant search intent. The final output—intent, confidence, rationale, content format, and content ideas—is automatically appended as rows in your “Search Intent Analysis” n8n Data Table.

What this workflow does

• Runs manually when you click Execute.
• Reads inputs from the workflow Settings step: a comma-separated keyword list, plus your target location and language.
• Queries Google with SearchApi for each keyword to fetch the first-page SERP.
• Extracts SERP intent signals from visible features such as ads, shopping results, featured snippets, People Also Ask, local intent, video signals, and the top organic results.
• Feeds SERP evidence to OpenAI to produce a JSON analysis including intent, confidence, rationale, content format, and content ideas.
• Parses the OpenAI response and appends one row per keyword to the “Search Intent Analysis” Data Table, including analyzed_at.

Use cases

• SEO content planning: identify whether keywords are informational, commercial, navigational, or local—and plan accordingly.
• Competitive content strategy: compare SERP patterns (snippets, PAA, video, shopping) to shape your content format.
• SaaS marketing ops: batch analyze keyword sets and keep a searchable record of intent signals over time.

Technical details

• SearchApi Google Search step: add your SearchApi credential and set location and language.
• OpenAI intent analysis step: add your OpenAI credential and choose the model.
• n8n Data Table: create/select “Search Intent Analysis” with columns for keyword, intent, confidence, rationale, content_format, content_ideas, serp_signals, analyzed_at.
• Includes workflow nodes such as Manual Trigger, Set, Code, Data Table, and a LangChain OpenAI integration component.