Latenode
Apify
OpenAI GPT Assistants
Gmail
Google sheets

Automate lead generation: scrape data, find emails, send personalized outreach

This lead generation agent automation identifies potential business leads by monitoring online platforms or databases, extracting their contact information and details, and automatically syncing the data into a centralized CRM or lead management system. The workflow starts with a 'Lead Machine' form where users can specify the business type, location, and desired lead volume.

It then scrapes business data using the Apify API, finds the best email addresses with the Google Gemini AI, and generates personalized cold emails with OpenAI's language model. The cold emails are sent via Gmail, and the lead details and email status are stored in a Google Sheet. This automation is designed for digital marketing agencies and sales teams looking to streamline their lead generation and outreach processes.

Updated Apr 2, 2026Est. run: 33sEst. cost: $0.0021
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

  • Identifies potential business leads by monitoring online platforms or databases
  • Extracts contact information and business details of leads
  • Syncs lead data into a centralized CRM or lead management system
  • Generates personalized cold emails using AI-powered language models
  • Sends cold emails via Gmail and tracks email status in a Google Sheet

How it works

1
Trigger

Specify Lead Criteria

The user fills out a 'Lead Machine' form to specify the type of business, location, and desired lead volume. This triggers the lead generation automation.

2
Logic

Scrape Business Data

The automation uses the Apify API to scrape business data, such as company name, website, and contact information, based on the user's specified criteria.

3
Logic

Extract Email Addresses

The Google Gemini AI is used to find the best email address for each business from the scraped data.

4
Logic

Filter Valid Websites

The automation filters the leads to only include businesses with a valid website, ensuring the contact information is up-to-date.

5
AI

Generate Cold Email

For each valid lead, the automation uses OpenAI's language model to generate a personalized cold email message.

6
Action

Send Cold Email

The cold email is then sent to the lead's email address via the user's Gmail account.

7
Action

Update Lead Status

The lead details, including the email send status, are stored in a Google Sheet for the user to review and manage.

Setup guide

1

Add Apify credentials

Add your Apify API credentials in the Latenode Credentials panel. This allows the workflow to access the Apify API to scrape business data.

2

Configure Google Gemini AI integration

Add your Google Gemini AI API credentials in the Latenode Credentials panel. This enables the workflow to use the Gemini AI to extract email addresses from the scraped business websites.

3

Set up OpenAI for cold email generation

Add your OpenAI API credentials in the Latenode Credentials panel. This allows the workflow to use OpenAI's language model to generate personalized cold email content.

4

Connect Google Sheets

Configure the Google Sheets connection in the Latenode builder. This will allow the workflow to store the scraped business leads and email send status in a Google Sheet.

5

Set up Gmail integration

Add your Gmail account credentials in the Latenode Credentials panel. This enables the workflow to send the personalized cold emails via Gmail.

Requirements

Obtain API keys and access credentials for the Apify API to scrape business data
Obtain API keys and access credentials for the Google Gemini AI to find best email addresses
Obtain API keys and access credentials for OpenAI's language model to generate personalized cold emails
Set up a Gmail account with the necessary permissions to send emails
Create a Google Sheet to store the lead details and email status
Ensure the Latenode workspace has the necessary nodes (Apify, OpenAI, Gmail, Google Sheets) and can access the required secrets and variables

FAQ

Common questions about this template

This automation monitors online business directories and databases to identify potential leads. It extracts key details like company name, contact information, location, and industry. This data is then automatically synced to a centralized CRM or lead management system.
Contact support →

More templates

You might also like

Browse all templates →
CRM & sales

Automatically Sync Google Sheets and HighLevel Contacts

This Latenode automation template allows users to automatically synchronize contact information between Google Sheets and the HighLevel CRM platform. Whenever a new row is added or an existing row is modified in a specified Google Sheets spreadsheet, the integration will create a new contact or update an existing one in HighLevel. This streamlines the process of managing lead data across both platforms, ensuring consistent and up-to-date contact records.

8s$0.0005
CRM & sales

Sync HubSpot deals with new Instantly events to drive sales

This automation template helps sales teams streamline lead management by automatically creating and updating HubSpot deals whenever a new event occurs in the Instantly workspace. The workflow is triggered by a 'New Event' in Instantly, such as an email being sent or a lead unsubscribing, and then creates a new deal in the HubSpot CRM. This ensures that the sales team is kept informed of potential leads and opportunities, improving the process of tracking and converting leads.

7s$0.0004
CRM & sales

Automatically sync new HubSpot leads to specific lemlist campaigns

This Latenode automation simplifies lead management by automatically adding new contacts from HubSpot to specified lemlist campaigns. Whenever a new contact is added to a HubSpot list, this workflow will detect the addition and instantly enroll that lead in the corresponding lemlist campaign. This streamlines the lead nurturing process, allowing users to more efficiently engage with and convert new prospects. The automation integrates the popular CRM and email marketing platforms, HubSpot and lemlist, to provide a seamless end-to-end experience for managing incoming leads.

8s$0.0005