This template runs on a schedule, lists ads from your Facebook ad account, shapes the payload in JavaScript, asks ChatGPT for a short analysis, and writes the rows to Google Sheets.
Connect Facebook Ads and Google Sheets. Put the ads token on the Facebook Ads connection. ChatGPT is a Latenode AI step, so you do not paste an OpenAI key. If you need Insights or creative fields the list step does not return, call the Marketing API from JavaScript and put the Marketing API token in that JavaScript node.
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.
Facebook Ads lists ads from the ad account you connect. JavaScript shapes id, name, status, and creative fields for the next step.
ChatGPT returns a short summary and suggested copy notes. ChatGPT is Latenode AI, so you do not paste an OpenAI key.
Google Sheets appends a row per ad with the fields and analysis you map.
Add a Facebook Ads connection with access to the ad account you want to list. Put the ads token on that connection.
Add a Google Sheets connection. Use a worksheet with columns for ad id, name, status, analysis, and any metrics you map.
List ads, shape the payload in JavaScript, send it to ChatGPT, and append Sheets rows from that output. ChatGPT is a Latenode AI step. If you need Insights or extra creative fields, call the Marketing API from JavaScript and put the Marketing API token in that JavaScript node. Set the schedule, run once, and confirm the rows.
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.
