LinkedIn Content Machine: Email-Approved Posts with Gemini AI

Turn a simple email workflow into a LinkedIn content machine. Generate post ideas, draft full posts, and auto-publish to LinkedIn all controlled by replying to emails.

📌 Purpose
Automate your LinkedIn posting pipeline using AI + Email approvals.
Generate 10 scroll-stopping post ideas tailored to your niche & audience.
Approve your favorite by replying to the email with a number.
Receive 3 AI-written drafts for the chosen idea.
Pick your favorite draft via email reply.
The selected post gets auto-published to LinkedIn ✅.
All steps are logged in Google Sheets.

🔗 Apps Used
Google Gemini** → generates ideas & drafts
Gmail** → email-based approval workflow
Google Sheets** → tracks ideas, drafts, and published posts
LinkedIn API** → posts directly to your company or personal account

✨ Highlights
📬 Email-based approval → no dashboards, just reply with a number
📝 10 AI-generated content ideas + 3 full drafts per topic
🔄 End-to-end tracking in Google Sheets (ideas → drafts → published)
⚡ Auto-posting directly to LinkedIn
✅ Final confirmation email with preview

👤 Best For
Startup founders
Agencies managing multiple clients’ LinkedIn
Solopreneurs & creators who want consistent posting

🛠️ Workflow Overview

flowchart TB A["Manual Trigger"] --> B["AI Agent - Generate 10 Ideas"] B --> C["Code - Parse JSON + Correlation ID"] C --> D["Google Sheets - Append Ideas"] D --> E["Gmail - Send Ideas Email"] E --> F["Gmail Trigger - Await Reply"] F --> G["Code1 - Extract Reply Number"] G --> H["Google Sheets - Fetch Row"] H --> I{"Switch Stage"} I -- Ideas --> J["AI Agent - Generate 3 Drafts"] J --> K["Code3 - Parse Drafts"] K --> L["Google Sheets - Update Drafts"] L --> M["Gmail - Send Drafts Email"] I -- Drafts --> N["Code4 - Select Final Draft"] N --> O["LinkedIn - Publish Post"] O --> P["Google Sheets - Update Posted"] P --> Q["Gmail - Send Confirmation"] `