📅 Want to automatically create your entire social media content plan and generate visuals for each post?
Here’s the perfect n8n workflow for you 👇
This workflow combines AI + Google Search + Google Sheets + Image Generation to automatically build a full monthly content plan (Carousel, Reel, Post, Story, Telegram) — complete with AI-generated visuals.
You can run it for any brand within minutes — no coding required.
Google Custom Search API → Collects trending content and topics from the past 1–2 months.
AI Agent (Google Gemini or OpenAI) → Creates a detailed monthly social media plan.
n8n JSON Processing → Structures the plan into a clean data format.
Google Sheets → Automatically logs each post idea, format, and date.
Second AI Agent → Writes captions and slide texts for each post.
Reads post data from Google Sheets.
Generates AI images (using OpenAI, Gemini, or other image models) for each planned post.
Uploads visuals to Google Drive.
Appends image links back into the same Google Sheet.
Result?
👉 With one click, you get a complete 15-post monthly plan — including AI-generated visuals, captions, and formats for all major platforms (Carousel, Reel, Story, Post, Telegram).
(Formats, post count, language, and sector can be customized easily.)
🧠 OpenAI (GPT-4.1 mini) or Google Gemini
🔗 Google Custom Search API
📊 Google Sheets
☁️ Google Drive
⚙️ n8n.io (self-hosted or cloud version)
***
n8n: Free (self-hosted) or ~$20–30/month
Google Search API: Free for up to 100 queries – 2 USD monthly for basic needs
OpenAI (GPT-4.1-mini): ~$0.01–0.03 per run – 1 USD monthly for basic needs
Google Sheets & Drive: Free
💰 Total:
Just a few cents per month if offline and very basic needs⚡
Just a 40-100 usd yearly if online and basic-mid needs⚡
Just a 100-300 usd yearly if online and more needs⚡
***
You can view the full workflow diagram below 👇
All keys, brand-specific values, and private information have been removed — simply add your own API credentials to start.
***
Prompts are generic and suitable for any brand or industry.
Each carousel’s first slide includes a “hook” for better engagement.
Remaining slides are structured for data, insights, and CTAs.

We drive business productivity and innovation through comprehensive IT Consulting, Database Management, Software Development, Data Integration and Managed IT Services. Our tailored IT solutions & services empower businesses to streamline operations, optimize data, and achieve sustainable growth in the ever-evolving digital landscape in Europe.