--:-- --
110%
↖ Projects
Content Creation

AI Blog & Social Media Publisher

Generate, approve, and publish SEO blog posts across every platform automatically.

Workflow screenshot 1
Workflow screenshot 2
Workflow screenshot 3

What It Does

When you check a box in a Google Sheet, this automation researches your keyword in real time using Perplexity, drafts a full blog post with AI, rewrites it with an engaging tone, optimizes it for SEO, generates four matching images, and publishes the styled HTML post directly to WordPress. A second checkbox triggers AI-written captions for every social media platform and publishes them automatically with the blog image attached.

The Problem It Solves

Creating consistent SEO content manually — research, writing, formatting, image sourcing, and social promotion — takes hours per post and rarely gets done at the frequency needed to rank. This system compresses that entire process into a single checkbox while keeping you in control of what goes live.

Before & After

Before

  • Hours spent researching, writing, and formatting each post
  • Blog images sourced and inserted manually
  • Social media captions written separately for each platform
  • Content published inconsistently or not at all

After

  • Full blog post researched, written, and styled automatically
  • Four matching images generated and embedded per post
  • Captions written for every platform in one step
  • You only approve — the system handles everything else

Tools Used

n8nn8n Google SheetsGoogle Sheets Google Apps ScriptGoogle Apps Script OpenAIOpenAI PerplexityPerplexity WordPressWordPress BlotatoBlotato

WORK WITH ME

Want this built for your business?

Book a free strategy call — I'll map out exactly how this would work for your workflow. No pitch, no pressure.

📞 Book a Free Strategy Call ↗