Enrich Google company data with OpenAI agent and scraper
Workflow Description
An advanced automation that uses an OpenAI AI agent to enrich company data stored in Google Sheets, integrating web scraping capabilities and structured data parsing to create comprehensive company profiles from multiple sources.
How it works
- 1.Initialize the AI agent with company data from Google Sheets
- 2.Execute web scraping and data collection tools through the agent's decision-making process
- 3.Parse and structure enriched results, then write back to Google Sheets
Use cases
- Automatically enrich CRM databases with company intelligence, market data, and social media profiles
- Gather competitive intelligence by extracting structured data about target companies from multiple web sources
Requirements
- OpenAI API credentials and a configured Google Sheets with company data
- Access to web scraping tools and proper permissions for data collection
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