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"]