Enrich company records in Google Sheets with Gemini Flash and SerpAPI
Needs changesNeeds changes. This template uses 1 thing(s) that n8n 3.0 removes: SerpApi (Google Search). 1 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 11 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets, SerpApi (Google Search) and Google Gemini Chat Model.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Read Source Sheet (Google Sheets): uses Google Sheets
- Extract Relevant Fields (Edit Fields (Set)): sets 3 fields: Company Name, Website, Enriched
- Skip Already Enriched (If): checks a condition and branches into true / false
- AI Enrichment Agent (AI Agent): runs an AI agent, with model: Gemini Flash; 1 tool (Web Search (SerpAPI)); output parser: Structured Output Parser
- Normalize Output Data (Code): runs custom JavaScript code
- Append Enriched Row (Google Sheets): append
- Mark as Enriched (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
1 thing in this workflow is removed in n8n 3.0. Fix it before you upgrade:
- SerpApi (Google Search) in Web Search (SerpAPI): no direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node.
Rather not rewrite it? Many of these flows can be rebuilt in Make (free plan).
| Removed in 3.0 | Replace with |
|---|---|
| SerpApi (Google Search) Web Search (SerpAPI) | No direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node |
Nodes used (9)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Edit Fields (Set)
n8n-nodes-base.set - If
n8n-nodes-base.if - AI Agent
@n8n/n8n-nodes-langchain.agent - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - SerpApi (Google Search)
@n8n/n8n-nodes-langchain.toolSerpApi - Google Gemini Chat Model
@n8n/n8n-nodes-langchain.lmChatGoogleGemini - Code
n8n-nodes-base.code
From the author
Quick Overview This workflow manually runs a company enrichment pipeline that reads companies from Google Sheets, uses SerpAPI web search plus Google Gemini to generate structured company details, writes the enriched data to a second Google Sheet, and marks…