Automate contact enrichment with Surfe, Google Sheets & HubSpot
Ready for 3.0What this workflow does
This workflow has 12 nodes and runs on Google Drive events (file created). Along the way it connects Google Sheets, Google Drive, Gmail and HubSpot. It also calls api.surfe.com over HTTP.
How it runs
Trigger: On Google Drive events (file created).
- Google Sheets: uses Google Sheets
- Split Batch - (Loop Over Items (Split in Batches)): loops over the items in batches
- Gmail: uses Gmail
- Prepare JSON Payload Enrichment Request (Code): runs custom JavaScript code
- Surfe Bulk Enrichments API (HTTP Request): calls api.surfe.com (POST)
- Surfe check enrichement status (HTTP Request): calls an HTTP API
- Is enrichment complete ? (If): checks a condition and branches into true / false
- Extract list of peoples from Surfe API response (Code): runs custom JavaScript code
- Wait: waits 30 seconds
- Filter: keeps only the items that match a condition
…plus 1 more step. See the full node list below.
Services it uses
HTTP calls to: api.surfe.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 (10)
- Google Sheets
n8n-nodes-base.googleSheets - Google Drive Trigger
n8n-nodes-base.googleDriveTrigger - Filter
n8n-nodes-base.filter - Code
n8n-nodes-base.code - If
n8n-nodes-base.if - HTTP Request
n8n-nodes-base.httpRequest - Gmail
n8n-nodes-base.gmail - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - HubSpot
n8n-nodes-base.hubspot - Wait
n8n-nodes-base.wait
From the author
This template enables fully automated lead enrichment using Surfe’s bulk API. Simply drop a Google Spreadsheet into your Google Drive, and n8n will handle everything — from reading the leads, enriching them in batches, filtering valid data, and pushing…