This template runs on a schedule, calls the Facebook Marketing API Insights endpoint from JavaScript, and writes campaign metrics to Google Sheets.
Use it for a daily spend report without exporting ads data by hand. Connect Google Sheets. Put the Marketing API token in that JavaScript node. Map ad account id, date range, and the sheet columns you want.
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 on the cadence you set, such as every morning.
JavaScript calls the Facebook Marketing API for spend, impressions, clicks, and status. Put the Marketing API token in that JavaScript node.
Google Sheets appends a row per campaign with the metrics you map.
Add a Google Sheets connection. Use a worksheet with columns for date, campaign name, spend, impressions, and clicks.
Add a JavaScript node that calls the Insights endpoint. Put the Marketing API token and ad account id in that JavaScript node.
Add a daily schedule. Append Sheets rows from the JavaScript output. Run once and confirm spend matches Ads Manager for the same date range.
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.
