This template starts when you add a prospect URL to Google Sheets. Apify scrapes public contact details. JavaScript cleans name, company, and phone. ChatGPT writes a short outreach script.
WhatsApp Business Cloud sends an approved template to that number, then Google Sheets logs the send. Connect Google Sheets, Apify, and WhatsApp Business Cloud. Put the Apify API key on the Apify connection. ChatGPT is a Latenode AI step.
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 →Workflow preview
The scenario starts when a new row with a source URL appears in the Google Sheet you choose.
Apify runs the actor you pick and returns name, company, and phone from that public page.
JavaScript cleans the fields, then ChatGPT returns a short WhatsApp script for that prospect.
WhatsApp Business Cloud sends an approved template to the phone. Google Sheets records the result.
Add a Google Sheets connection. Use one worksheet for prospect URLs and another for outreach results.
Add an Apify connection and paste your Apify API key there. Choose the actor that scrapes the public pages you target.
Add a WhatsApp Business Cloud connection. Approve an outreach template in Meta Business Manager before you send.
Map the new-row URL into Apify, clean name, company, and phone in JavaScript, send those fields to ChatGPT for the script, then send the WhatsApp template and append a results row. Test with one URL that includes a reachable phone.
FAQ
More templates
This template keeps a light Instagram engagement loop. A schedule asks ChatGPT for hashtags. PhantomBuster fetches recent posts for those tags. JavaScript skips URLs already stored in SharePoint, then PhantomBuster likes one remaining post. SharePoint saves that URL so the next run does not repeat it. Connect SharePoint and PhantomBuster. Put the PhantomBuster API key on the PhantomBuster connection.
This template receives TikTok Lead Generation form submits on a Latenode webhook, maps name, email, phone, and custom answers in JavaScript, and appends a row in Google Sheets. If the webhook only includes a lead id, the same JavaScript node loads the full lead from the TikTok Marketing API with your token stored in that node. Connect Google Sheets, then point the TikTok form webhook at the Latenode URL. Add a new worksheet when you want each campaign on its own tab.
This template watches an Instagram Business account for new posts and builds RSS in JavaScript. The trigger supplies caption, permalink, media URL, and timestamp. JavaScript maps those fields into RSS item XML or a full feed document. Google Drive saves the XML in the folder you choose. Connect Instagram for Business and Google Drive, then point the trigger at the account you want to publish.
