Quick Overview
This workflow manually pulls contacts from Google Sheets, enriches each person using the Lusha /v2/person API (via LinkedIn URL or name/company lookup), and writes email, phone, and job details back to the same sheet while marking each row as processed.
How it works
- Runs when executed manually and reads all contact rows from a specified Google Sheets worksheet.
- Filters the rows to keep only contacts that are not marked as Done and have a first name.
- Processes contacts one by one and decides whether to query Lusha using the contact’s LinkedIn URL or using first name, last name, and company name.
- Calls the Lusha API to retrieve enriched contact details such as email addresses, phone numbers, location, and job information.
- Validates that Lusha returned usable contact data (including at least one email address) before continuing.
- Writes the enriched fields back to the matching Google Sheets row and then updates the Done status for that row before continuing to the next contact.
Setup
- Add a Google Sheets OAuth2 connection and set the correct spreadsheet and sheet in the read and update steps.
- Add your Lusha API key as an HTTP Header Auth credential for both Lusha HTTP requests.
- Ensure your Google Sheet includes a unique row_number column for matching updates and a Done column used to skip already-processed contacts.
- Confirm your sheet column names match the workflow mappings (for example, First name, Last name, Company, Linkedin URL, Mail adress, Phone number 1/2, Title, Departments, Country, Seniority).