Automated Blog & Social Media Content Creator with Google Sheets and n8n

In this project, I demonstrate how to build an end-to-end content automation workflow in n8n. It automatically pulls a topic from a Google Sheets file, generates an SEO-friendly blog article with matching AI-generated images, and publishes the content to a website and social media platforms.

Project Objective

The goal is to fully automate your content pipeline: plan topics in Google Sheets, let AI generate high-quality blog posts with optimized images, and publish them everywhere—hands free.

Workflow Overview

• Read new topics from Google Sheets
• Use OpenAI to generate a complete SEO-friendly article
• Create an AI-generated cover image to match the topic
• Upload the article to your website CMS (WordPress, Webflow, etc.)
• Share the same article and image to social media channels
• Mark the topic as published in Google Sheets to avoid duplication

Key Features

• Topic planning in Google Sheets
• SEO-optimized text generation with OpenAI
• Automatic AI image generation
• Auto-publishing to website and social platforms
• Fully automated, no-code flow using n8n

Use Cases

• Small businesses that need regular blog content
• Social media managers who want to automate posting
• Personal bloggers and digital marketers

Results

With this setup, you can keep your website and social channels fresh with new, SEO-friendly articles and images—generated and posted automatically—saving hours every week.