Enrich company data in Google Sheets with CompanyEnrich
Ready for 3.0What this workflow does
This workflow has 7 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets. It also calls api.companyenrich.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get row(s) in sheet (Google Sheets): uses Google Sheets
- Filter: keeps only the items that match a condition
- Loop Over Items (Loop Over Items (Split in Batches)): loops over the items in batches
- Update row in sheet (Google Sheets): update
- Fetch Company Data (HTTP Request): calls api.companyenrich.com
- Data Cleaning (JS) (Code): runs custom JavaScript code
Services it uses
HTTP calls to: api.companyenrich.com
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (6)
- Manual Trigger
n8n-nodes-base.manualTrigger - Google Sheets
n8n-nodes-base.googleSheets - Filter
n8n-nodes-base.filter - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - HTTP Request
n8n-nodes-base.httpRequest
From the author
This workflow automates enriching company profiles by taking a domain name from a Google Sheet, fetching firmographic data via the CompanyEnrich API, and updating the sheet with the results. Who is this for? Sales Teams: To enrich lead lists with better data…