Enrich CRM contacts in Google Sheets with Tomba firmographic data
UnknownWhat this workflow does
This workflow has 7 nodes and runs on Google Sheets events (row added). Along the way it connects Google Sheets and Tomba (community).
How it runs
Trigger: On Google Sheets events (row added).
- Loop Over Contacts Batch (Loop Over Items (Split in Batches)): loops over the items in batches
- Retrieve Email via Tomba (Tomba): work with email
- Enrich Data via Tomba (Tomba): work with company
- Retrieve Phone via Tomba (Tomba): work with phone
- Compile Enriched Contact (Code): runs custom JavaScript code
- Update Enriched Contact in Sheets (Google Sheets): update
Services it uses
Before you upgrade to n8n 3.0
We can't fully verify this one: it relies on 1 community package, and n8n 3.0 turns unverified community packages off by default (N8N_UNVERIFIED_PACKAGES_ENABLED=false).
- Check that n8n-nodes-tomba is verified or supports 3.0 (used in Retrieve Email via Tomba, Enrich Data via Tomba, Retrieve Phone via Tomba).
Nodes used (5)
- Google Sheets Trigger
n8n-nodes-base.googleSheetsTrigger - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Tomba
n8n-nodes-tomba.tomba - Code
n8n-nodes-base.code - Google Sheets
n8n-nodes-base.googleSheets
From the author
Quick overview This workflow watches a Google Sheets contacts list for new rows and enriches each contact using Tomba to find a likely email address, company firmographics, and a phone number, then writes the enriched fields back to the same spreadsheet. How…