Enrich Leads in Google Sheets with n8n + GPT-4o-mini

Enrich your Google Sheets leads automatically with n8n + GPT-4o-mini

This n8n workflow checks your Google Sheets leads every 30 minutes, finds missing emails by scraping each company’s website, and writes the discovered contact email back into your sheet—using HTML mailto links first and GPT-4o-mini as a fallback.

What this workflow does

• Runs on a schedule: executes every 30 minutes.
• Targets only incomplete leads: reads all rows from your Google Sheets spreadsheet and filters for leads with an empty email that are not already marked as solo_linkedin.
• Processes in manageable batches: limits processing to 20 leads per run and normalizes required fields (including building a full website URL).
• Scrapes the homepage: downloads the company homepage HTML and extracts an email from a mailto: link when available.
• Uses OpenAI when mailto isn’t found: if no mailto email exists on the homepage, it sends the homepage text to OpenAI to extract a literally published contact email and updates Google Sheets when returned.
• Checks contact/about pages: when the homepage doesn’t yield an email (or if no contact email is found), the workflow detects a contact/about page link, downloads that page, and uses OpenAI again to extract an email.
• Prevents reprocessing: if no email is found after checking the contact page (or no contact page exists), it updates the lead with estado = solo_linkedin so it won’t be retried.

Use cases

• Sales and SaaS teams enriching prospect lists in Google Sheets without manual searching.
• Automation engineers maintaining lead hygiene by filling missing contact emails at scale.
• Operators who want higher deliverability by collecting publicly available contact addresses.

Technical details

• Integrations: Google Sheets OAuth2 for reading/writing rows.
• AI: OpenAI API using GPT-4o-mini.
• n8n logic: uses nodes such as if, set, limit, filter, OpenAI, and sticky note.
• Required columns: at least place_id, email, estado, nombre, web, and proyecto.

Setup tip: confirm your sheet tab name (example: leads_maestro_consolidado) and set the correct YOUR_GOOGLE_SHEET_ID.