Enrich Google company data with AI agent research and scraping
Workflow Description
Automation that deploys an OpenAI intelligent agent to automatically search for and collect company information from multiple sources including social media, then validates and inserts enriched data directly into Google Sheets with structured output parsing.
How it works
- 1.Trigger automation workflow to initiate company data enrichment
- 2.Split company list into parallel batches for efficient processing
- 3.Direct OpenAI agent to research company details and verify official social accounts
- 4.Parse and structure extracted information into standardized format
- 5.Update Google Sheets with newly enriched company records
Use cases
- Build comprehensive prospect profiles before sales outreach campaigns
- Automatically collect social proof and contact channels for B2B companies
Requirements
- Valid OpenAI API key with agent access
- Google Sheets file with edit permissions
- Configured research tools and web scraping capabilities for the AI agent
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 (13)
Structured Output Parser
Output Parser Structured
OpenAI Chat Model
OpenAI
Get rows from Google Sheet
Google Sheets
Call n8n workflow : Scrape companies homepage content
Tool Workflow
Update Company's Row on Google Sheet
Google Sheets
ScrapingBee : Scrape company's homepage data
HTTP Request
Tool called from Agent
Execute Workflow Trigger
Loop Over Items
Split In Batches
Sticky Note
Sticky Note
AI Agent
Agent
Set company url
Set
HTML to Markdown
Markdown
Webhook
Webhook