Automated company research & lead enrichment with GPT-4o and Google Sheets
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 to replace before upgrading
| 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
What it does
Supercharge your sales and marketing with this AI-powered workflow! 🚀 Stop wasting hours on manual company research. This template deploys an autonomous AI agent that takes a list of company names from a Google Sheet, scours the web to find critical information, and automatically updates your sheet with the enriched data. What it does: - Reads a list of companies to research from a Google Sheet. - Uses an AI agent equipped with Google Search and web scraping tools. - Extracts key data points like LinkedIn URLs, pricing details, integrations, market focus (B2B/B2C), and more. - Structures the output into a clean JSON object. - Updates the original Google Sheet with the new information. Key Features & Customization: This workflow is built to be easily customized. You can modify the AI's prompt in the "AI company researcher" node and adjust the "Structured Output Parser" to gather any public data point you need, such as recent news, key executives, or their technology stack. Required Credentials: - OpenAI - Google Sheets - SerpApi or ScrapingBee for search capabilities