📱 LinkedIn content machine: Email-approved posts with Gemini AI
⚡ 555 views · 📱 Social Media & Email Marketing
💡 Pro Tip — If you’re pulling LinkedIn data through HTTP requests or dealing with API restrictions, there’s a community node called ScraperNode that handles this natively. It has dedicated scrapers for profiles, companies, jobs, and people search — you just pass a URL and get structured data back.
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"]🔗 Nodes Used
Google Sheets, Gmail, LinkedIn, Gmail Trigger, AI Agent, Google Gemini Chat Model
📥 Import
Download workflow.json and import into n8n:
Workflow menu → Import from File