This template turns a planner row into a WordPress.com post. A new Google Sheets row supplies the topic and writing prompt. ChatGPT writes title, excerpt, and HTML.
JavaScript assembles the post. WordPress.com creates it, then Google Sheets writes the post URL back on the same row. Connect Google Sheets and WordPress.com. ChatGPT is a Latenode AI step, 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 when you add a topic and prompt to the Google Sheet.
ChatGPT returns title, excerpt, and HTML. ChatGPT is Latenode AI, so you do not paste an OpenAI key.
JavaScript turns that draft into title, HTML, excerpt, and slug for WordPress.com.
WordPress.com creates the post. Google Sheets writes the post URL on the planner row.
Add a Google Sheets connection. Use a sheet with columns for topic, prompt, and post URL.
Add a WordPress.com connection for the site that should receive posts.
Send the sheet topic and prompt to ChatGPT. Assemble title, HTML, excerpt, and slug in JavaScript, create the WordPress.com post, and write the URL back to the same row. ChatGPT is a Latenode AI step. Add a test topic and confirm the post appears.
FAQ
More templates
This template starts when WordPress.com publishes a post, creates a Mailchimp campaign from the title and content, and sends it to the audience you choose. Use it so subscribers get the new article without pasting the campaign by hand. Connect WordPress.com and Mailchimp. Put the Mailchimp API key on the Mailchimp connection.
This template watches a WordPress.com site for new posts, sends the permalink to T.LY from a JavaScript node, and stores the short URL next to the post id. Connect WordPress.com. Put the T.LY API key in that JavaScript node. Use the Latenode database table you pick as the lookup.
This template watches a Feedly feed for new articles, shapes title and body in JavaScript, and creates a WordPress.com post. Connect Feedly and WordPress.com. Point the trigger at the feed you follow. Map title, content, and excerpt from the article into the post.
