Automated web research and lead database building
Workflow Description
An intelligent AI agent searches the web for prospect information using OpenAI and SerpApi, analyzes results, organizes them in batches, and automatically logs findings to Google Sheets to support your sales pipeline.
How it works
- 1.Trigger research manually or on a scheduled basis
- 2.Send search queries to OpenAI agent powered by SerpApi
- 3.Parse and structure results using output parser
- 4.Batch and organize data before upload
- 5.Store compiled information in Google Sheets for team review
Use cases
- Build and maintain a database of qualified leads with automated research
- Track competitor intelligence and industry trends continuously
- Extract contact details and company profiles at scale without manual effort
Requirements
- Valid OpenAI API key with appropriate permissions
- Google Sheets with editor access and correct folder structure
- SerpApi key for web search integration
Service Value
Ideal as a smart automation service combining integrations and AI to produce ready-to-use results.
Apps Used
Details
How to Use
- 1.Click "Download Template"
- 2.Open your n8n dashboard
- 3.Go to Workflows > Import from File
- 4.Select downloaded file and configure credentials
Nodes Used (22)
When clicking "Test workflow"
Manual Trigger
Input
Set
OpenAI Chat Model
OpenAI
Get website content
Tool Workflow
SerpAPI - Search Google
Tool Serp Api
Structured Output Parser
Output Parser Structured
Loop Over Items
Split In Batches
AI Researcher Output Data
Set
Google Sheets - Update Row with data
Google Sheets
Merge data
Merge
Sticky Note
Sticky Note
Get rows to enrich
Google Sheets
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Sticky Note3
Sticky Note
Sticky Note4
Sticky Note
Schedule Trigger
Schedule Trigger
Sticky Note5
Sticky Note
AI company researcher
Agent
Search Google with ScrapingBee
Tool Workflow
Sticky Note6
Sticky Note
Sticky Note7
Sticky Note