Search LinkedIn companies, enrich with AI and sync to Google Sheets CRM
Workflow Description
An automation that searches for companies on LinkedIn, uses artificial intelligence to analyze and structure the data, then automatically adds them to a Google Sheets database. It processes results in batches to ensure reliable data entry and prevents API rate limit issues.
How it works
- 1.Trigger company search on LinkedIn through manual execution or schedule
- 2.Process search results in batches using batch splitting to handle volume efficiently
- 3.Analyze and structure company information using OpenAI, extracting key business details
- 4.Add processed companies directly to Google Sheets with all formatted information
Use cases
- Build and maintain an automated prospect database in Google Sheets from LinkedIn searches
- Enrich company data with AI-generated insights before storing in your CRM
Requirements
- Active LinkedIn account with company search capabilities
- OpenAI API key for data enrichment and analysis
- Google Sheets with edit permissions to store company records
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 (18)
Process Each Company
Split In Batches
Get Company Info
HTTP Request
Filter Valid Companies
If
Is New Company?
If
Set Variables
Set
Search Companies
HTTP Request
Extract Company Data
Split Out
Check If Company Exists
Google Sheets
AI Company Scoring
OpenAI
Sticky Note
Sticky Note
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Wait 2s
Wait
Add Company to CRM
Google Sheets
Sticky Note4
Sticky Note
Sticky Note5
Sticky Note
Sticky Note6
Sticky Note
Start
Manual Trigger