Enrich contact emails and phone numbers with Tomba and Google Sheets

Description

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
Runs on a scheduled trigger.
Reads rows from a Google Sheets worksheet where the Status column equals “Pending”.
Processes the contacts in batches and sends each contact’s name, company, and domain to Tomba to find an email address.
If Tomba indicates phone data is available, looks up the phone number in Tomba using the found email address.
Normalizes the output (email, phone, score, and enrichment status) and updates the matching row in Google Sheets with the results and Status set to “Done”.

Setup
Connect your Google Sheets OAuth credentials and set the target spreadsheet and worksheet that contains your contacts.
Add a Tomba API credential.
Ensure your Google Sheet includes the expected columns (First Name, Last Name, Company, Domain, Status) and output columns (Email, Phone, Score), with Status set to “Pending” for rows you want to enrich.