ChatGPT

JavaScript

OpenAI Image Generation

WordPress.com

Automate creation & publication of SEO-optimized WordPress posts from Google Sheets

This template turns a planner row into a WordPress.com draft. A new Google Sheets row supplies topic, keywords, and audience. ChatGPT writes title, excerpt, slug, and HTML.

JavaScript assembles the post. Image generation creates a featured image. WordPress.com creates the draft, uploads the image, and attaches it. Google Sheets writes the post URL back on the same row. Connect Google Sheets and WordPress.com, then add a topic row to run it.

Updated Sep 16, 2026Est. run: 1m 4sEst. cost: $0.004

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

What this template does

Starts when you add a topic row in Google Sheets
Drafts title, excerpt, slug, and HTML with ChatGPT
Creates a featured image and attaches it on WordPress.com
Saves the post as a draft and logs the URL on the planner row

How it works

Trigger

New planner row

The scenario starts when you add a topic, keywords, and audience to the Google Sheet.

Write the SEO draft

ChatGPT returns title, excerpt, slug, and HTML. JavaScript assembles those fields for WordPress.

Generate a featured image

Image generation creates artwork from the topic and title.

Action

Save the draft and log the URL

WordPress.com creates a draft, uploads the image, and sets it as the featured image. Google Sheets writes the post URL on the planner row.

Setup guide

Connect Google Sheets

Add a Google Sheets connection. Use a sheet with columns for topic, keywords, audience, and post URL.

Connect WordPress.com

Add a WordPress.com connection for the site that should receive drafts.

Add ChatGPT and image generation

Add ChatGPT and map the sheet topic, keywords, and audience into the prompt. Add image generation and pass the title so the artwork matches the post.

Publish the draft and update the sheet

Add JavaScript to assemble title, HTML, excerpt, and slug. Create the WordPress.com draft, upload the image, attach it as the featured image, and write the post URL back to the same Sheets row. Add a test topic and confirm the draft appears.

Requirements

A Google Sheet with topic, keywords, and audience columns Latenode can watch

A WordPress.com site Latenode can create drafts on

FAQ

Common questions about this template

Each run uses credits on your Latenode plan. We charge for processing time (1 credit = 30 seconds). Your actual cost depends on your plan and how long the run takes. See pricing plans for plans and how credits work. Plug-and-Play AI nodes are billed separately.

Contact support →

More templates

Browse all templates →

Comprehensive SEO Audit and Optimization Automation

This template starts when you post a website URL to a Latenode webhook. An HTTP request downloads the HTML. JavaScript extracts title, meta, headings, and image alts. OpenAI GPT Assistants reviews that on-page copy. A second HTTP request calls Google PageSpeed Insights with the PageSpeed API key on that request. JavaScript merges the findings into an HTML report, and MailerSend emails it. Connect OpenAI GPT Assistants and MailerSend.

32s$0.0020

Automatically receive SMS alerts for new YouTube videos

This template watches a YouTube channel for new uploads, builds a short text with the video title and link in JavaScript, and sends that SMS with Twilio. Connect YouTube and Twilio. Point the trigger at the channel you want to watch. Put the Twilio Account SID and Auth Token on the Twilio connection.

5s$0.0003

Automatically sync Big Cartel orders to Google Analytics 4

This template receives each Big Cartel order on a webhook, maps order id, total, and items in JavaScript, and sends a purchase event to Google Analytics 4. Point Big Cartel at the Latenode webhook URL. Connect Google Analytics and put access on that connection. Use a JavaScript node to shape the event name and parameters GA4 expects.

10s$0.0006