Latenode

Scrape & Sync Website Emails to Google Sheets or Database

This automation enables users to scan the HTML source of a website and extract all email addresses found, saving the collected list into a structured format like a Google Sheet or database. The workflow is triggered by a webhook, where the user provides the target website URL as a query parameter.

The automation then fetches the website content, extracts the email addresses using a regular expression, removes any duplicates, and responds to the webhook with the list of unique email addresses. This can be useful for growing email marketing lists or sourcing contact information at scale, particularly for businesses that rely on email outreach as a core part of their marketing strategy.

Updated Apr 2, 2026Est. run: 11sEst. cost: $0.0007
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 email addresses from website HTML
  • Removes duplicate email addresses
  • Stores extracted emails in a Google Sheet
  • Triggers the workflow via webhook with website URL
  • Responds to webhook with a list of unique email addresses

How it works

1
Trigger

Receive Website URL

The automation is triggered by a webhook that receives the URL of the website you want to scrape for email addresses.

2
Action

Fetch Website HTML

The automation makes an HTTP request to the provided website URL and retrieves the HTML content of the page.

3
Logic

Extract Email Addresses

The automation uses a regular expression to search the website HTML and extract all email addresses found on the page. It then removes any duplicate email addresses from the list.

4
Action

Save Email List

The automation stores the list of unique email addresses in a structured format, such as a Google Sheet or a database, so that the user can easily access and use the collected data.

Setup guide

1

Add Webhook Trigger

In the Latenode visual builder, add a Webhook trigger node. Configure the node to accept incoming requests with the website URL provided as a query parameter (e.g. ?Website=https://example.com).

2

Add HTTP Request Node

Add an HTTP Request node to the workflow. Configure it to fetch the website content using the URL received from the Webhook trigger node.

3

Extract Email Addresses

Add a JavaScript node to the workflow. In the node settings, write a JavaScript function that uses a regular expression to extract all email addresses from the website HTML content fetched in the previous step.

4

Remove Duplicate Emails

Add a Remove Duplicates node to the workflow. Configure it to remove any duplicate email addresses from the list obtained in the previous step.

5

Respond to Webhook

Finally, add an HTTP Response node to the workflow. Configure it to return the list of unique email addresses extracted from the website, or a message if no emails were found.

Requirements

A Latenode account with the necessary workspace permissions to create and configure the required nodes (webhook, HTTP request, Google Sheets, and custom code)
Ability to create a webhook trigger to accept the target website URL as a query parameter
Latenode HTTP request node configured to fetch the HTML content of the target website using the provided URL
Latenode JavaScript node with the ability to extract all email addresses from the fetched website HTML using a regular expression
Latenode Google Sheets node configured with the necessary access to write the extracted email addresses to a Google Sheet
Monitoring and error handling to ensure the workflow is functioning correctly and notify of any issues

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

Scrape and export Google Maps business data to Google Sheets

This automation 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 for lead generation and market analysis. The workflow triggers manually or on a scheduled basis, fetching search results from Google Maps using the SerpAPI service, deduplicating the data, and writing it to a Google Sheet. This streamlines the process of gathering valuable business intelligence from Google Maps, empowering users to leverage this data for strategic decision-making and sales prospecting.

11s$0.0007
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

Automate Instagram profile data export to Google Sheets

This automation template allows users to scrape comprehensive Instagram profile data using the Apify platform, and automatically export the results into a Google Sheets spreadsheet for analysis. It is designed to run on a schedule, processing a list of usernames by calling the Apify API, appending the scraped data to a Google Sheet, and marking the usernames as processed. The automation integrates with Google Sheets and the Apify actor, providing a streamlined way to gather and organize Instagram profile information without manual intervention.

15s$0.0009