Automate blog content creation from topics to WordPress with AI, Google Drive & Sheets

Blog Post Content Creation (Multi-Topic with Brand Research, Google Drive, and WordPress)

Description

This workflow automates the full lifecycle of generating and publishing SEO-optimized blog posts from a list of topics. It reads topics (and optionally brands) from Google Sheets, performs brand research, generates a structured HTML article via AI, converts it into an HTML file for Google Drive, publishes a draft post on WordPress, and repeats this for every row in the sheet.

When the final topic has been processed, a single Slack message is sent to confirm completion and share links.

How It Works

1. Input from Google Sheets

A Google Sheets node reads rows containing at least:

- Brand (optional, can be defaulted) - Blog Title or Topic