LinkedIn Content Machine: Email-Approved Posts with Gemini AI

Description

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