AI web researcher for sales
Needs changesNeeds changes. This template uses 2 thing(s) that n8n 3.0 removes: SerpApi (Google Search), AI Agent v1 (old agent modes). 2 breaking item(s) found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 14 nodes and runs manually, when you click “Execute workflow” (plus 1 other trigger). Along the way it connects OpenAI Chat Model, SerpApi (Google Search) and Google Sheets.
How it runs
Trigger: Manually, when you click “Execute workflow” (plus 1 other trigger).
- Get rows to enrich (Google Sheets): uses Google Sheets
- Input (Edit Fields (Set)): sets 2 fields: company_input, row_number
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- AI company researcher (AI Agent): runs an AI agent, with model: OpenAI Chat Model; 2 tools (Get website content, SerpAPI - Search Google); output parser: Structured Output Parser
- Merge: merges the data from its input branches
- AI Researcher Output Data (Edit Fields (Set)): sets 9 fields: domain, linkedinUrl, market…
- Google Sheets: update
- Search Google with ScrapingBee (Call n8n Workflow Tool): uses Call n8n Workflow Tool
Services it uses
Before you upgrade to n8n 3.0
2 things in this workflow are removed in n8n 3.0. Fix them before you upgrade:
- SerpApi (Google Search) in SerpAPI - Search Google: no direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node.
- AI Agent v1 (old agent modes) in AI company researcher (v1.6): replace with Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent.
| Removed in 3.0 | Replace with |
|---|---|
| SerpApi (Google Search) SerpAPI - Search Google | No direct replacement: call the SerpApi REST API with an HTTP Request tool, or use a verified community node |
| AI Agent v1 (old agent modes) AI company researcher (v1.6) | Latest AI Agent node (Tools Agent). For SQL Agent, use a Postgres or MySQL tool with a recent AI Agent. |
Nodes used (11)
- Manual Trigger
n8n-nodes-base.manualTrigger - Edit Fields (Set)
n8n-nodes-base.set - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - Call n8n Workflow Tool
@n8n/n8n-nodes-langchain.toolWorkflow - SerpApi (Google Search)
@n8n/n8n-nodes-langchain.toolSerpApi - Structured Output Parser
@n8n/n8n-nodes-langchain.outputParserStructured - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Google Sheets
n8n-nodes-base.googleSheets - Merge
n8n-nodes-base.merge - Schedule Trigger
n8n-nodes-base.scheduleTrigger - AI Agent
@n8n/n8n-nodes-langchain.agent
From the author
Who is this for? This workflow is for all sales reps and lead generation manager who need to prepare their prospecting activities, and find relevant information to personalize their outreach. Use Case This workflow allows you to do account research with the…