n8n Workflow: Extract Lead Emails from Websites to Google Sheets

Extract lead email addresses from websites and automatically update your Google Sheets

This n8n workflow visits each lead’s website, extracts the first plausible email address from the page HTML, and writes the Email and Status back into the same Google Sheets row—run daily or on demand.

What this workflow does

• Runs on schedule or manually: set to run daily at 10:00 or start it yourself.
• Reads leads from Google Sheets: pulls rows from your specified spreadsheet (including the correct tab gid=0).
• Filters eligible leads: only processes leads that have a Website value and an empty Email field.
• Processes in batches with throttling: handles leads with a pause of 2 seconds between sites to reduce load.
• Fetches homepage HTML: uses an HTTP request to retrieve each website’s HTML.
• Extracts an email + sets status: applies pattern matching to find the first plausible email address and assigns Status based on whether an email was found.
• Updates the sheet by PlaceId: writes Email and Status back to the matching lead row using PlaceId as the unique identifier.

Use cases

• SaaS lead enrichment: keep your CRM-like Google Sheet current by extracting contact emails from lead websites.
• Sales ops automation: fill missing emails for prospect lists without manual browsing.
• Daily data hygiene: run the workflow every day to capture newly available emails while skipping rows that already have an Email.

Technical details (n8n nodes & integration)

• Google Sheets OAuth credential for reading and updating rows.
• Nodes used: code, no op, wait (2 seconds), filter, sticky note, HTTP request.
• Setup requirements: ensure your sheet includes Website, Email, Status, and PlaceId (or update the matching column in the update step).
• Customization: adjust the bad-pattern filter list in the “Extract Email” code node to exclude domains specific to your niche.