Latenode
Google drive
Supabase
OpenAI GPT Assistants
Apify
Google sheets
WhatsApp Business Cloud

Automate your sales outreach with Apify, GPT-4o, and WhatsApp

This automated workflow streamlines the sales cold calling process by integrating web scraping, natural language processing, and WhatsApp messaging.

It leverages Apify to extract lead data from social media and web sources, generates personalized sales scripts using GPT-4o, and sends automated outreach messages via WhatsApp to connect with potential customers. The workflow is designed for sales teams looking to optimize their cold calling pipeline and increase productivity by automating repetitive tasks.

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 →
Social media

Workflow preview

What this template does

  • Extracts lead data from social media and websites using Apify
  • Generates personalized sales scripts with GPT-4o based on lead information
  • Sends automated outreach messages to potential customers via WhatsApp Business Cloud
  • Stores lead data and sales scripts in a Supabase database
  • Exports sales activity data to Google Sheets for reporting and analysis

How it works

1
Trigger

Monitor Google Drive

The workflow starts by monitoring a specified Google Drive folder for new files. This acts as the trigger, initiating the automated process when a new file is detected.

2
Logic

Check File Type

The system filters the files to only process supported file types, ensuring the workflow can handle the incoming data.

3
Action

Download File Content

The content of the selected file is then retrieved from Google Drive and made available for further processing.

4
Action

Store File in Supabase

The file content is saved in the Supabase vector store for future reference and analysis.

5
AI

Generate Text Embeddings

Using OpenAI's language models, the file content is converted into vector representations, enabling AI-powered analysis and comparison.

6
Logic

Split Text into Chunks

The file content is divided into smaller, more manageable pieces to optimize the subsequent scraping and processing steps.

7
Logic

Process Each Chunk

The workflow iterates over the text chunks, performing the following actions on each one:

8
Action

Scrape Lead Data

Apify is used to extract relevant lead data from the web, targeting information that can be used to connect with potential customers.

9
Action

Clean and Format Data

The scraped lead data is normalized and cleaned to ensure it is in a consistent format for further processing.

10
Action

Update Google Sheet

The new leads are appended to a specified Google Sheet, providing a centralized repository for the sales team to access the data.

11
Action

Store Leads in Supabase

The cleaned and formatted lead data is also saved in the Supabase vector store for easy retrieval and analysis.

12
Logic

Check for Existing Data

The workflow verifies if the new lead data already exists in the Supabase vector store, ensuring duplicate records are not stored.

13
Action

Retrieve Relevant Data

The system queries the Supabase vector store to retrieve any related information that can be used to enrich the lead data and provide more context for the sales team.

14
AI

Process Data with AI

The retrieved information is analyzed using GPT-4o, generating personalized sales scripts and insights to aid the sales team in their outreach efforts.

15
Action

Send Automated Outreach

The final step involves connecting with potential customers via automated WhatsApp messages, leveraging the personalized sales scripts and lead data to initiate conversations and build relationships.

Setup guide

1

Add Apify Credential

Add an Apify credential in the Latenode Credentials panel. Enter your Apify API key and Apify actor URL.

2

Configure Apify Node

Add an Apify node to your workflow and configure it with the following settings: - Select the Apify credential you added earlier - Set the actor to the appropriate Apify actor for scraping web data - Provide the URLs or input data you want to scrape

3

Add OpenAI Credential

Add an OpenAI credential in the Latenode Credentials panel. Enter your OpenAI API key.

4

Configure OpenAI GPT-4o Node

Add an OpenAI GPT-4o node to your workflow and configure it with the following settings: - Select the OpenAI credential you added earlier - Specify the prompts or input data you want to process using GPT-4o

5

Add WhatsApp Business Cloud Credential

Add a WhatsApp Business Cloud credential in the Latenode Credentials panel. Enter your WhatsApp Business Cloud API key and webhook URL.

Requirements

Apify account and API key to access web scraping capabilities
OpenAI API key to generate personalized sales scripts using GPT-4
WhatsApp Business Cloud API access and credentials to enable automated outreach messaging
Destination database or API (e.g., Supabase, Google Sheets) to store and manage lead data

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 →
Social media

Automatically like fresh Instagram posts with AI-powered targeting

This Latenode automation template helps social media managers and brands maintain an active and engaged presence on Instagram by automatically liking fresh posts on selected hashtags. The workflow uses a rotating set of Instagram session cookies, AI-powered hashtag generation, and Phantombuster web scraping to streamline the process, reducing the need for manual intervention. The scheduled trigger runs every 2 hours, selecting a random cookie and generating relevant hashtags to target new posts, then automatically liking them. The solution integrates with Instagram, Phantombuster, Microsoft SharePoint, and OpenAI to provide a comprehensive automation experience.

26s$0.0703
Social media

Automatically sync LinkedIn lead gen form data to Google Sheets

This automation solution is designed to help marketers and sales teams efficiently capture and track new lead generation form responses from LinkedIn Ads. The automation will automatically transfer the lead details, such as name, email, and other relevant information, into a centralized Google Sheets spreadsheet. This provides a unified view of all incoming leads, allowing for better organization, analysis, and follow-up. By streamlining the lead capture process, users can focus on nurturing and converting these potential customers, rather than manually managing multiple data sources.

25s$0
Social media

Automatically sync TikTok lead data to a Google Sheets spreadsheet

This automation template helps social media marketers and advertisers automatically capture new lead data generated through TikTok's Lead Generation feature and append it as a new row or worksheet within a designated Google Sheets spreadsheet. The automation triggers when a new lead is submitted on TikTok, extracts the lead data, and then adds it to the specified Google Sheets file, streamlining the process of managing and organizing leads from this social media platform.

25s$0