This template runs on the schedule you set, reads the next unpublished topic from Google Sheets, asks ChatGPT for post copy, generates a still image, and publishes to Google Business Profile. It then marks that row published. Connect Google Sheets and Google Business Profile. ChatGPT and image generation are Latenode AI steps, so you do not paste an OpenAI key.
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 at the time you set, such as once a day.
Google Sheets holds topics and a published flag. JavaScript selects the first unpublished row.
ChatGPT writes the post from that topic. Image generation creates a matching still.
Google Business Profile creates the post. Google Sheets marks that topic as published.
Add a Google Sheets connection. Use a sheet with columns for topic, published, and any notes you want ChatGPT to use.
Add a Google Business Profile connection and select the location that should receive posts.
Choose how often to post. Send the topic to ChatGPT with your brand tone. Generate the image from the same topic. ChatGPT and image generation are Latenode AI steps.
Create the Google Business post from the copy and image. Update the row so the next run skips it.
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.
