Data & Databases
Extract company data from Clearbit and save to Google Sheets
15 nodes
130
86
Scheduled trigger
Workflow Description
Scheduled automation that retrieves company and executive information from Clearbit, filters the data for quality, and automatically records it in Google Sheets, building a continuously updated prospect database without manual intervention.
How it works
- 1.Automation triggers on a predefined schedule
- 2.Fetch company and executive records from Clearbit API
- 3.Validate and filter extracted data for accuracy
- 4.Reformat and distribute data across required columns
- 5.Append processed records to Google Sheets
Use cases
- Build an automatically updated prospect database with company intelligence
- Consolidate contact and corporate information from a trusted data source
Requirements
- Active Clearbit account with valid API credentials
- Prepared Google Sheets with appropriate columns for n8n access
Service Value
Ready-made workflow template for automation delivery and service execution.
Apps Used
Clearbit
Google Sheets
Details
Trigger
Scheduled trigger
Nodes
15
Apps
2
Views
130
Downloads
86
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 (15)
/
Get Leads
HTTP Request
Filter Leads by company criteria
Filter
Enrich company
Clearbit
Setup
Set
Get all Leedfeeder accounts
HTTP Request
Only for wanted accounts
Filter
Split out accounts
Split Out
Split Out Leads
Split Out
Sticky Note
Sticky Note
Schedule Trigger
Schedule Trigger
Sticky Note1
Sticky Note
Sticky Note2
Sticky Note
Filter leads by engagement
Filter
Sticky Note3
Sticky Note
Save leads to Google Sheets
Google Sheets