This template starts when someone submits a Facebook Lead Ad form, maps name, email, and phone in JavaScript, and appends a Google Sheets row.
Fetch full lead details from Facebook if the trigger payload is incomplete. Connect Facebook Lead Ads and Google Sheets, then pick the Page and form you want to watch.
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 Facebook Lead Ads submits a new lead on the form you watch.
JavaScript turns Facebook field names into email, name, and phone. Fetch lead details first if the trigger payload is missing answers.
Google Sheets appends the lead so you have a spreadsheet trail.
Add a Facebook Lead Ads connection and sign in with access to the Page that owns the lead form.
Add a new-lead trigger and select that Page and form. Fetch lead details first if the trigger payload is missing answers.
Add a Google Sheets connection. Use a sheet with columns for name, email, phone, form, and received time.
Map email, name, and phone from the lead, then add a single row. Submit a test lead and confirm the row.
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 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.
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.
