Scrape.do + n8n: Extract Emails from Websites to Google Sheets

Extract emails from websites into Google Sheets using Scrape.do + n8n

This n8n workflow automatically pulls website URLs from your Google Sheet, scrapes each site with the Scrape.do API, finds the most relevant email addresses in the page content, and writes the best match back into the Emails column.

What this workflow does

• Manual start in n8n: you trigger the workflow by manually executing it in n8n.
• Reads URLs from Google Sheets: the workflow looks for a “Websites” column containing full URLs to process.
• Scrapes each page via Scrape.do: for every URL (processed in batches), it sends a request to the Scrape.do API to fetch the page content.
• Extracts and filters emails: it parses the returned content to find email addresses, removes duplicates and common junk/platform domains, and prefers emails that match the scraped site’s domain.
• Writes results back to the same row: it appends or updates the row by matching on “Websites”, then saves the selected email into the “Emails” column.

Use cases

• Build or enrich lead lists by extracting contact emails from a list of company websites stored in Google Sheets.
• Quickly generate outreach targets for SaaS operators and marketers who need website-to-email mapping.
• Validate or supplement existing datasets by scraping and selecting the best matching email found on each page.

Technical details

• n8n nodes/steps: if, code, wait, sticky note, HTTP Request, Google Sheets.
• Google Sheets integration: uses OAuth2 connection; expects headers including “Websites” and “Emails”.
• Scrape.do API: add your Scrape.do API token as the HTTP request query parameter named token.
• Configurable filtering: the workflow includes logic to manage blocked email domains and filtering rules (including optional allowances for common providers like Gmail/Outlook) in the JavaScript code.