Enrich LinkedIn profiles into full contacts with Tomba and Google Sheets

Quick overview

This workflow runs on a schedule to read “Pending” LinkedIn profile URLs from Google Sheets, uses Tomba to find and enrich contact details (email and phone), and writes the results back to the same sheet with updated status and scoring.

How it works

1. Runs on a schedule trigger.
2. Reads rows from a Google Sheets worksheet where the Status column is set to “Pending”.
3. Processes each LinkedIn URL in batches and calls Tomba’s LinkedIn Finder to retrieve the person’s email and phone details.
4. Normalizes the returned contact data (including combining multiple phone numbers) and sets an enrichment status based on whether an email is found.
5. Updates the corresponding row in Google Sheets with the enriched fields (Email, Phone, Score) and marks the Status as “Done”.

Setup

1. Connect your Google Sheets OAuth2 credentials and set the target spreadsheet and worksheet that contains LinkedIn URL, Status, and output columns.
2. Add your Tomba API credentials and ensure the LinkedIn URL column contains valid LinkedIn profile links.
3. Make sure your sheet includes a row_number field (used for matching updates) and uses “Pending” as the Status value for rows you want to process.