Latenode
Data Enrichment
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 Apr 6, 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 →
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

Automate lead generation, sync data to your CRM seamlessly

This automation is designed for digital marketing agencies and sales teams who want to automatically identify and gather contact details for potential business leads across various online platforms and databases. It starts with a form submission that collects key details like industry and location, then uses web scraping tools to extract relevant company information, including name, website, phone, address, and category. The gathered data is then synced to a centralized CRM or lead management system, and personalized cold emails can be sent to the extracted contacts, all from a single workflow. This automation streamlines the lead generation and outreach process, helping users efficiently identify and engage with new sales prospects.

25s$0
CRM & sales

Automatically sync Google Sheets contacts to HighLevel CRM

This automation template allows users to seamlessly synchronize contact information between Google Sheets and HighLevel, a popular CRM and sales platform. Whenever a new row is added or an existing row is modified in the Google Sheet, this integration will automatically create or update the corresponding contact record in HighLevel. This streamlines data management for sales teams, ensuring their CRM stays up-to-date without manual data entry. The integration connects the spreadsheet and CRM, providing a centralized view of customer information to improve sales and marketing efforts.

26s$0.0703
CRM & sales

Sync HubSpot deals with new Instantly events for lead management

This automation template allows users to automatically create and update deals in HubSpot, a leading CRM platform, whenever a new event is triggered in Instantly, an event-driven automation tool. This integration streamlines the lead management process by syncing new leads and related data between the two systems. Users can quickly capture leads from Instantly and convert them into deals within HubSpot, ensuring a smooth transition from lead generation to sales pipeline management. This solution is designed for sales and marketing teams who need to efficiently manage their customer relationships and sales opportunities.

25s$0