Latenode

Automatically sync website email contacts to Google Sheets or a database

This automation template allows users to extract email addresses in bulk from website HTML content.

It is triggered by a webhook request with the target website URL, fetches the HTML, identifies all email addresses using a regex, removes duplicates, and returns the clean list of emails in the webhook response. This capability is valuable for marketing, sales, and outreach efforts that require access to large contact databases. The workflow is built using the n8n automation platform and integrates with the target website as the primary external data source.

Updated Apr 23, 2026Est. run: 26sEst. cost: $0.0703
How Latenode estimates time and cost

Latenode bills workflow runs in credits: 1 credit = 30 seconds of processing. Minimum charge per run depends on your plan. Plug-and-Play (PnP) AI nodes are billed separately—each PnP token is $1 USD, charged pay-as-you-go at vendor cost plus a small processing fee, with no API keys required.

Full pricing — how credits work →
Scraping & data collection

Workflow preview

What this template does

  • Extracts all email addresses from a website's HTML content
  • Deduplicates the collected email addresses
  • Saves the cleaned email list to a Google Sheet or database
  • Triggers the extraction process via a webhook request with the target website URL
  • Provides a structured dataset of verified website contacts for marketing and outreach

How it works

1
Trigger

Receive Webhook Request

The automation workflow is triggered by a webhook request that includes the target website URL as a parameter.

2
Action

Fetch Website HTML

The workflow fetches the HTML content of the target website using the provided URL.

3
Logic

Extract Email Addresses

A regular expression is used to identify and extract all email addresses present in the website HTML content.

4
Action

Filter Out Empty Emails

Any extracted email addresses that are empty or invalid are removed from the list.

5
Action

Remove Duplicate Emails

The filtered list of email addresses is further processed to remove any duplicate entries, ensuring a clean, unique set of contacts.

6
Action

Respond with Email List

The final, de-duplicated list of email addresses is returned as the response to the initial webhook request.

Setup guide

1

Add Website Integration Credential

In the Latenode Credentials panel, add a new credential for the website you want to scrape emails from. Provide the necessary API key, access token, or other authentication details required by the website.

2

Configure Webhook Trigger Node

In the Latenode visual builder, add a Webhook node as the trigger for the workflow. Set the Webhook URL and method to receive the initial request with the target website URL.

3

Configure HTTP Request Node

Add an HTTP Request node after the Webhook node. In the node settings, map the website URL from the webhook input to the URL field. This will fetch the HTML content from the provided website.

4

Extract Emails Using Regex

Add a Set node after the HTTP Request node. In the node settings, use a regular expression to extract all email addresses from the website HTML content.

5

Respond with Unique Email List

Finally, add a Respond to Webhook node. This will return the de-duplicated list of email addresses extracted from the website as the webhook response.

Requirements

Obtain a Webhook URL to trigger the workflow when a new website URL is available
Set up a Google Sheets account and create a spreadsheet to store the extracted email addresses
Obtain API access credentials (e.g., API key, OAuth credentials) for the Google Sheets integration
Ensure the Google Sheets integration has write permissions to the designated spreadsheet

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work.

More templates

You might also like

Browse all templates →
Scraping & data collection

Automatically Sync Google Maps Business Data to a Spreadsheet

This automation workflow allows users to efficiently scrape business data from Google Maps, including names, contact details, and reviews, and export the structured information into a spreadsheet or database. The workflow uses the SerpAPI service to retrieve Google Maps search results, which are then transformed and appended to a Google Sheet. This enables users to generate leads, conduct market analysis, and gain valuable insights from the collected data in a cost-effective and scalable manner.

26s$0.0703
Scraping & data collection

Scrape Zillow property data and sync to Google Sheets automatically

This Latenode automation extracts real estate listing details from Zillow and automatically populates a Google Sheets spreadsheet with the property data. It leverages the Scrape.do web scraping API to bypass anti-bot protections and fetch the full HTML of Zillow listings, then parses key information like price, address, days on Zillow, and Zestimate, and saves the structured results into a Google Sheet. This solution is designed for real estate professionals, investors, and market analysts who need to collect property data at scale without manual effort, enabling better market research, portfolio tracking, and lead generation.

9s$0.0006
Scraping & data collection

Automatically scrape and store Booking.com hotel data

This workflow automates the search and extraction of hotel data from Booking.com, triggered by a chat message. It uses a combination of web scraping with Bright Data's Web Scraper and AI-powered data processing with OpenRouter to deliver a concise, human-friendly list of hotels, including the title, address, original price, and final price. The final output is a clean and formatted report, making it a valuable tool for travelers, event planners, and business professionals who need to quickly find accommodation.

26s$0.0703