Automate company data enrichment with HubSpot, Sona & Google Sheets
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This workflow has 13 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Google Sheets and HubSpot. It also calls api.hubapi.com and api2.sonalabs.com over HTTP.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Company List from Sheet (Google Sheets): uses Google Sheets
- Aggregate: combines items into one
- Create Custom HubSpot Fields (HTTP Request): calls api.hubapi.com (POST)
- Prepare Data for Loop (Edit Fields (Set)): sets 1 field: domains
- Split Companies and AI Output into Items (Split Out): splits a list into separate items
- Loop Through Companies (Loop Over Items (Split in Batches)): loops over the items in batches
- Sona Enrich (HTTP Request): calls api2.sonalabs.com
- Create HubSpot Company (HubSpot): work with company
- Format Custom Properties (Code): runs custom JavaScript code
- Update Company with AI Data (HTTP Request): calls an HTTP API (PATCH)
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.hubapi.com, api2.sonalabs.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 (11)
- HTTP Request
n8n-nodes-base.httpRequest - Google Sheets
n8n-nodes-base.googleSheets - Manual Trigger
n8n-nodes-base.manualTrigger - HubSpot
n8n-nodes-base.hubspot - Edit Fields (Set)
n8n-nodes-base.set - Split Out
n8n-nodes-base.splitOut - No Operation, do nothing
n8n-nodes-base.noOp - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Code
n8n-nodes-base.code - Aggregate
n8n-nodes-base.aggregate - Wait
n8n-nodes-base.wait
From the author
Automatically enrich company records with comprehensive firmographic data by pulling domains from Google Sheets, setting up custom HubSpot fields, enriching through Sona API, and syncing complete profiles to HubSpot CRM with custom property mapping. Import…