Latenode
Google sheets
Apify
Gmail

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.

Updated Apr 6, 2026Est. run: 25sEst. cost: $0
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

  • Extracts relevant company information from online platforms and databases
  • Normalizes and cleanses the extracted data
  • Syncs the gathered data into a centralized CRM or lead management system
  • Generates personalized cold outreach emails to the extracted contacts
  • Provides a centralized view of potential sales leads

How it works

1
Trigger

Capture Lead Information

A form is submitted to collect key details about a potential lead, such as their industry and location.

2
Action

Scrape Business Data

Based on the lead information provided, web scraping tools are used to extract relevant company details, including name, website, phone, address, and category, from various online platforms and databases.

3
Action

Extract Email Address

The automation then uses JavaScript to analyze the scraped website data and identify the best email address associated with the lead.

4
Logic

Check for Email Address

The automation checks if a valid email address was found for the lead.

5
Action

Sync Lead Data

The gathered lead data, including the extracted email address, is then appended to a centralized CRM or lead management system.

6
Action

Send Personalized Email

If an email address was found, the automation sends a personalized cold email to the lead using a pre-defined email template.

7
Action

Update Lead Status

The automation updates the lead's row in the centralized system with the email send status and timestamp.

Setup guide

1

Connect Apify

1. In the Latenode Credentials panel, add a new credential for 'Apify' and enter your Apify API key. 2. In the Latenode builder, add an Apify node. Configure the node with the following: - Apify API endpoint: 'https://api.apify.com/v2/acts/...' - Number of leads to scrape: input from the form - Geolocation (country, state/region, city): input from the form

2

Connect Google Sheets

1. In the Latenode Credentials panel, add a new credential for 'Google Sheets' and authenticate using your Google account. 2. In the Latenode builder, add a Google Sheets node. Configure the node with the following: - Google Sheets document ID - Google Sheets sheet name - Map the extracted data fields (company name, website, phone, address, email, etc.) to the corresponding Google Sheets columns.

3

Connect Gmail

1. In the Latenode Credentials panel, add a new credential for 'Gmail' and authenticate using your Google account. 2. In the Latenode builder, add a Gmail node. Configure the node with the following: - Email subject and body templates using Latenode's template syntax to dynamically insert the extracted lead information.

4

Configure OpenAI GPT Assistant

1. In the Latenode Credentials panel, add a new credential for 'OpenAI' and enter your OpenAI API key. 2. In the Latenode builder, add an OpenAI GPT Assistant node. Configure the node to generate personalized email content based on the extracted lead information.

5

Configure Google Gemini Assistant

1. In the Latenode Credentials panel, add a new credential for 'Google Gemini' and authenticate using your Google account. 2. In the Latenode builder, add a Google Gemini node. Configure the node to generate personalized email content based on the extracted lead information.

Requirements

Apify account with access to the Apify API, including the ability to create and run web scraping tasks
Google Sheets integration to sync extracted lead data to a spreadsheet
Gmail integration to send personalized outreach emails to the extracted contacts
OpenAI GPT assistant integration to generate personalized email content

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

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
CRM & sales

Automatically sync HubSpot contacts to targeted lemlist campaigns

This automation template is designed for CRM and sales professionals who use HubSpot and lemlist. It automatically adds new HubSpot contacts as leads to specific lemlist campaigns. This saves time and ensures that new contacts are quickly added to relevant marketing and outreach flows. The automation integrates HubSpot and lemlist, triggering each time a new contact is created in HubSpot and then syncing that contact data to lemlist to be added as a lead in the appropriate campaign.

26s$0.0703