Automated Enrichment of Marketing Leads from Google Sheets

This n8n workflow automates the process of enriching marketing leads stored in a Google Sheet by integrating with the Surfe API and syncing data with HubSpot. It begins by monitoring a specific Google Drive folder for new or updated spreadsheet files. When a new file is detected, the workflow reads lead data from Google Sheets, filters entries to those with both phone and email, and processes these through the Surfe enrichment API.

The workflow sends batches of lead data to Surfe for enrichment, then periodically checks the enrichment status. Once the process is complete, it extracts enriched data—such as contact information and LinkedIn URLs—using custom JavaScript code. Enriched contacts are then created or updated in HubSpot, and a notification email is sent to confirm completion.

This setup is ideal for marketing teams that need to automate lead enrichment workflows, ensuring their database stays current with minimal manual effort. It streamlines data collection, processing, and updating, saving time and improving lead quality.