📣 Social Media Content Automation Blueprint (AI + Google Sheets + n8n)

Auto-generate and publish optimized social media posts across LinkedIn, Facebook, Medium, X (Twitter), and more — using AI + Google Sheets + n8n.
Ideal for solopreneurs, marketers, agencies, and creators who want to post content consistently without manual effort.

✅ What This Automation Does:

1. Trigger from Google Sheets:
   As soon as you add a new media link in your sheet, the workflow is triggered.
2. Summarize Articles via AI:
   Uses Perplexity (LLaMA 3.1) to pull and summarize the latest article content.
3. Generate Social Media Posts:
   Sends the AI summary to GPT-4o to create:
   • A professional post for LinkedIn
   • An engaging caption for Instagram
   • A short tweet for X (Twitter)
   • A conversational post for Facebook
   • A blog-style snippet for Medium
4. Publish Across Platforms:
   Posts content automatically to:
   • ✅ LinkedIn
   • ✅ Medium
   • ✅ (Optional) Facebook, Slack, X (Twitter), Gmail

🧩 Tools Used:

• n8n – Workflow automation
• Google Sheets – Triggers content updates
• Perplexity API – Content understanding/summarization
• OpenAI (GPT-4o) – Social media content creation
• LinkedIn, Medium, X, Facebook APIs – Auto-publishing

💡 Use Cases:

• Personal brands posting consistently
• AI agencies offering managed content
• Newsletter → Social Media conversion
• Content repurposing from blog → posts
• Teams managing multiple clients

🔐 What You Need:

• Google Sheet with article/media URLs
• Perplexity API Key
• OpenAI API Key
• Connected social media accounts (LinkedIn, Medium, optional: Facebook, X, Slack)
• n8n hosted or cloud instance

📦 What You Get:

• ✅ Fully configured .json template for n8n
• 
  

💸 Pricing:

Package Includes Price Free Starter Template

🚀 No Coding Required

Just:

• Copy the Google Sheet
• Add your API keys
• Import the n8n workflow
• Watch your content post itself 💥