Latenode
Webhook
Data Enrichment
JavaScript
Google Sheets
Slack
HubSpot

Automatically capture leads from website, sync to CRM or Sheets, notify team in Slack

This workflow helps agencies, freelancers, SaaS founders, and small sales teams automatically capture website leads, sync the data to a CRM (HubSpot) or a Google Sheet, and instantly notify the team via Slack.

It demonstrates how to process a webhook trigger, validate the lead data, optionally enrich it, and reliably store the information in either HubSpot or Google Sheets while handling any write failures. The workflow is designed to ensure every lead is recorded and followed up on quickly, providing a streamlined solution for managing sales leads from a website.

Updated May 8, 2026Est. run: 24sEst. cost: $0.0015
How Latenode estimates time and cost

Latenode bills workflow runtime in CPU seconds. The first 10,000 CPU seconds are free each month, then usage follows pay-as-you-go CPU-second pricing. 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 CPU seconds work →
CRM & sales

Workflow preview

What this template does

  • Captures website leads and syncs the data to HubSpot and Google Sheets
  • Triggers a Slack notification to alert the team of new leads
  • Handles write failures to ensure every lead is recorded
  • Optionally enriches lead data using external data sources
  • Provides a centralized repository for managing website leads

How it works

1
Trigger

Receive Website Lead Data

The workflow starts by listening for a webhook trigger. When a user submits a lead form on the website, the lead data is sent to the workflow as a POST request.

2
Logic

Normalize Lead Data

The webhook payload is parsed, and the lead data is checked for any additional enrichment that can be fetched, such as company details or social profiles.

3
Logic

Validate Lead Data

The workflow verifies that the lead data includes the required fields, such as email, name, and message. Any incomplete or invalid lead data is filtered out.

4
Logic

Enrich Lead Data

If the lead data is missing any key information, the workflow makes an additional HTTP request to fetch the missing details, such as company name, job title, or website.

5
Logic

Merge Enrichment

The lead data and any enrichment details are combined into a complete lead record.

6
Action

Store Lead in Google Sheets

The workflow appends or updates the lead data in a Google Sheet. If the write to Google Sheets fails, the team is notified via Slack.

7
Action

Store Lead in HubSpot

Alternatively, the lead data is created or updated as a contact in HubSpot. If the write to HubSpot fails, the team is notified via Slack.

8
Action

Respond to Webhook

The workflow sends a success or error response back to the original webhook trigger, indicating whether the lead was processed successfully.

Setup guide

1

Add Webhook Trigger

In the Latenode visual builder, add a Webhook trigger node. Configure the webhook URL and secret key in the node settings.

2

Add HubSpot Integration

In the Latenode Credentials panel, add your HubSpot API credentials. Then, in the visual builder, add a HubSpot node and configure it to create or update contacts.

3

Add Google Sheets Integration

In the Latenode Credentials panel, authorize access to your Google account. Then, in the visual builder, add a Google Sheets node and configure it to append or update rows in your spreadsheet.

4

Add Slack Integration

In the Latenode Credentials panel, add your Slack webhook URL. Then, in the visual builder, add a Slack node and configure it to send notifications to a specific channel.

5

Configure Data Enrichment

If you want to enrich the lead data, in the Latenode Credentials panel, add the API credentials for your enrichment provider. Then, in the visual builder, add an HTTP Request node to make the enrichment API call.

Requirements

A Webhook integration to capture lead data from the website
A HubSpot account with write access to create new contacts
A Google Sheets account with write access to create new rows in a spreadsheet
A Slack workspace with permission to send messages to a specific channel

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.
Contact support →

More templates

You might also like

Browse all templates →
CRM & sales

Create a Pipeline deal from a new Discord channel message

Sales teams often miss leads buried in Discord conversations. This scenario captures every new message in a chosen Discord channel and creates a corresponding deal in Pipeline, using the message text as the deal description and the author's username as part of the deal name. Sales managers and business development reps can log inbound signals from team discussions directly into Pipeline CRM without manual data entry. The connection turns Discord into a lead source, so no opportunity slips through the cracks.

8s~$0.002
CRM & sales

Create a Pipeline deal when a new HubSpot deal is added

Manually copying deal data from HubSpot to Pipeline wastes time and risks errors. This automation triggers on the New Deal event in HubSpot and then runs the Create Deal action in Pipeline, mapping the deal name, amount, and associated contact email and name. Sales operations teams and CRM administrators who use both HubSpot and Pipeline can eliminate duplicate data entry. HubSpot captures the initial deal, and Pipeline receives a matching record immediately, so both systems stay aligned without manual work.

8s~$0.002
CRM & sales

Send a Gmail welcome email when ClickFunnels identifies a new contact

Manually sending welcome emails to new leads is slow and risks missed follow-ups. This scenario triggers on the New Contact Identified event in ClickFunnels and immediately sends a Send Email action in Gmail, using the contact's name and email address to personalize the message. Sales and marketing professionals who use ClickFunnels to capture leads can automate their first touchpoint. Gmail sends a custom welcome email with the contact's name in the body, so every new lead gets a timely, personal reply without manual work.

8s~$0.002