Enrich contact emails and phone numbers with Tomba and Google Sheets
UnknownUnknown. This template uses community nodes we can't verify statically. Uses community nodes that can't be verified statically (unverified community packages are off by default in 3.0). Static check, last run 2026-10-19.
What this workflow does
This workflow has 8 nodes and runs on a schedule (every day). Along the way it connects Google Sheets and Tomba (community).
How it runs
Trigger: On a schedule (every day).
- Read Contacts from Sheets (Google Sheets): uses Google Sheets
- Loop Over Contact Batches (Loop Over Items (Split in Batches)): loops over the items in batches
- Search Email with Tomba (Tomba): work with email
- Check Phone Availability (If): checks a condition and branches into true / false
- Search Phone with Tomba (Tomba): work with phone
- Format Contacts with Code (Code): runs custom JavaScript code
- Update Sheets with Contacts (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 Search Email with Tomba, Search Phone with Tomba).
Nodes used (6)
- Schedule Trigger
n8n-nodes-base.scheduleTrigger - Google Sheets
n8n-nodes-base.googleSheets - Loop Over Items (Split in Batches)
n8n-nodes-base.splitInBatches - Tomba
n8n-nodes-tomba.tomba - If
n8n-nodes-base.if - Code
n8n-nodes-base.code
From the author
Quick overview This workflow runs on a schedule to read “Pending” contacts from Google Sheets, uses Tomba to find email addresses and (when available) phone numbers, then writes the enriched results back to the same spreadsheet. How it works 1. Runs on a…