Skip to content

li-post-setup.md

Latest commit

 

History

History
306 lines (244 loc) · 10.1 KB

li-post-setup.md

File metadata and controls

306 lines (244 loc) · 10.1 KB
Raw

LinkedIn Content Automation Workflow - Setup Guide

Overview

This n8n workflow automatically discovers trending articles from RSS feeds, analyzes them with Gemini AI, generates engaging LinkedIn posts, and organizes everything in a Google Sheets content calendar for easy scheduling and tracking.

What This Workflow Does

  1. Monitors RSS Feeds - Pulls latest articles from industry sources (TechCrunch, The Verge, etc.)
  2. Filters Recent Content - Only processes articles from the last 24 hours
  3. AI Content Analysis - Gemini evaluates each article for relevance and engagement potential
  4. Smart Filtering - Only keeps articles with 60+ relevance score
  5. Generates LinkedIn Posts - Creates professional, engaging posts optimized for LinkedIn
  6. Suggests Optimal Timing - AI recommends the best date/time to post
  7. Content Calendar - Everything organized in Google Sheets with performance tracking

Setup Instructions

Step 1: Get Your Gemini API Key

  1. Go to https://aistudio.google.com/app/apikey
  2. Click "Get API Key" or "Create API Key"
  3. Copy your API key (starts with "AIza...")

Step 2: Create Your Google Sheets Content Calendar

  1. Create a new Google Sheet
  2. Name it "LinkedIn Content Calendar" (or your preference)
  3. The workflow will automatically create all necessary columns:
    • Post ID, Status, Scheduled Date/Time
    • Post Content, Article Title, Article Link
    • Relevance Score, Engagement Potential
    • Target Audience, Key Takeaway
    • Performance Metrics (Likes, Comments, Shares)
    • Notes
  4. Copy the Sheet ID from the URL
    • Example: https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID_HERE/edit

Step 3: Import the Workflow

  1. Open your n8n instance
  2. Click "Add Workflow" or the "+" button
  3. Click the three dots menu (⋮) → "Import from File"
  4. Select linkedin_content_automation.json
  5. The workflow will load with all nodes

Step 4: Configure Credentials

Gemini API Credential

  1. In n8n, go to Settings → Credentials
  2. Click "Add Credential" → Search for "Query Auth"
  3. Name it "Gemini API Key"
  4. Set:
    • Name: key
    • Value: Your Gemini API key
  5. Save

Google Sheets Credential

  1. In the workflow, click on "Add to Content Calendar" node
  2. Click "Create New Credential"
  3. Follow OAuth2 flow to connect your Google account
  4. Authorize n8n to access your Google Sheets

Step 5: Configure RSS Feeds

The workflow comes with 2 RSS feeds pre-configured:

  • TechCrunch: Technology and startup news
  • The Verge: Tech, science, and culture

To Add More RSS Feeds:

  1. Click the "+" button between "Schedule Trigger" and "Merge RSS Feeds"
  2. Search for "RSS Feed Read" node
  3. Add the RSS feed URL
  4. Name it descriptively (e.g., "RSS Feed - Wired")
  5. Connect it to the "Merge RSS Feeds" node

Recommended RSS Feeds for B2B/Tech:

AI & Technology:

  • TechCrunch: https://feeds.feedburner.com/TechCrunch/
  • The Verge: https://www.theverge.com/rss/index.xml
  • Wired: https://www.wired.com/feed/rss
  • VentureBeat AI: https://venturebeat.com/category/ai/feed/
  • MIT Technology Review: https://www.technologyreview.com/feed/

Business & Marketing:

  • Harvard Business Review: https://feeds.hbr.org/harvardbusiness
  • Fast Company: https://www.fastcompany.com/latest/rss
  • Marketing Land: https://marketingland.com/feed
  • CMSWire: https://www.cmswire.com/rss/

Industry Specific:

  • SaaS: https://www.saastr.com/feed/
  • eCommerce: https://www.practicalecommerce.com/feed
  • Finance: https://www.finextra.com/rss/headlines.aspx

Step 6: Update Google Sheets Connection

  1. Click on "Add to Content Calendar" node
  2. Select your Google Sheets credential
  3. Click "Document ID" → Select your calendar sheet
  4. Click "Sheet Name" → Select "Sheet1" (or your sheet name)

Step 7: Customize AI Prompts (Optional)

Analysis Prompt (Node: "Gemini - Analyze Article")

Edit to match your agency's focus:

  • Change industry focus (e.g., healthcare, finance, real estate)
  • Adjust scoring criteria
  • Modify target audience definitions

Post Creation Prompt (Node: "Gemini - Create LinkedIn Post")

Customize your brand voice:

  • Tone: Professional, casual, authoritative, friendly
  • Length preferences
  • Hashtag strategy
  • CTA style

Step 8: Test the Workflow

  1. Click "Execute Workflow" button (play icon)
  2. Watch the nodes execute step by step
  3. Check your Google Sheet for new posts
  4. Review the generated content and scores

Workflow Behavior

Scheduling

  • Default: Runs daily at 8 AM
  • To change: Click "Schedule Trigger" → Modify "Cron Expression"
  • Common schedules:
    • Twice daily: 0 8,16 * * *
    • Every 6 hours: 0 */6 * * *
    • Weekdays only: 0 8 * * 1-5

Content Filtering

Articles must meet BOTH criteria to be added to calendar:

  • Relevance Score: 60+ (relevant to B2B tech/AI)
  • Engagement Potential: 60+ (likely to generate interaction)

You can adjust these thresholds in the "Filter Recommended Only" node.

Post Status Flow

  1. Draft - Generated and ready for review
  2. Scheduled - Approved and ready to post (manually update in Sheet)
  3. Posted - Published to LinkedIn (manually update + add timestamp)
  4. Archived - Past posts for reference

Using the Content Calendar

Daily Workflow:

  1. Morning: Check new posts added overnight
  2. Review: Read each draft post, edit if needed
  3. Approve: Change status from "Draft" to "Scheduled"
  4. Post: Copy content to LinkedIn at suggested time
  5. Track: Update "Posted At" timestamp and performance metrics

Google Sheets Columns Explained:

Column Purpose
Post ID Unique identifier for tracking
Status Draft / Scheduled / Posted / Archived
Scheduled Date AI-suggested posting date
Scheduled Time AI-suggested posting time
Post Content Ready-to-copy LinkedIn post text
Article Title Source article headline
Article Link Link to original article
Source Which RSS feed (TechCrunch, etc.)
Relevance Score 0-100, how relevant to your audience
Engagement Potential 0-100, predicted engagement
Target Audience Who should read this
Key Takeaway Main insight from article
Created At When workflow generated this
Posted At When you actually posted (manual entry)
Likes Performance tracking (manual entry)
Comments Performance tracking (manual entry)
Shares Performance tracking (manual entry)
Notes Any additional context

Best Practices:

  1. Review Before Posting: Always read and customize AI-generated posts
  2. Add Personal Touch: Insert your own insights or experiences
  3. Track Performance: Update metrics 24-48 hours after posting
  4. Optimize Over Time: Notice which topics/formats perform best
  5. Maintain Consistency: Post 3-5 times per week for best results

Advanced Customization

Add Multiple Industries

Duplicate the analysis node and create industry-specific filters:

  • Tech posts (Monday, Wednesday, Friday)
  • Business strategy posts (Tuesday, Thursday)
  • Case studies (weekends)

A/B Test Post Formats

Create variations:

  • Different hooks
  • Various lengths
  • With/without questions
  • Different hashtag strategies

Automated Performance Tracking

Add a second workflow that:

  1. Reads the Google Sheet
  2. Uses LinkedIn API to fetch post metrics
  3. Updates performance columns automatically

Email Digest

Add Gmail node to send daily summary:

  • "5 new posts ready for review"
  • Top-scoring articles
  • Suggested posting schedule for the week

Cost Estimation

For 30 posts per month:

  • Gemini API: ~$0.50/month (3 calls per post × 300 tokens)
  • RSS Feeds: Free
  • n8n: Free (self-hosted) or $20/month (cloud)
  • Google Sheets: Free

Total: ~$20-21/month for fully automated LinkedIn content

Troubleshooting

No articles appearing in calendar

  • Check RSS feed URLs are working (test in browser)
  • Verify relevance score threshold (try lowering to 40)
  • Confirm date filter is set correctly (last 24 hours)
  • Check Gemini API quota

Generated posts are too generic

  • Edit the "Gemini - Create LinkedIn Post" prompt
  • Add more specific instructions about your brand voice
  • Include examples of your best-performing posts
  • Adjust target audience definition

Wrong posting times suggested

  • Edit "Gemini - Suggest Schedule" prompt
  • Specify your audience's timezone
  • Add constraints (e.g., "never weekends")
  • Provide historical performance data

Google Sheets not updating

  • Verify OAuth connection is active
  • Check Sheet ID is correct
  • Ensure sheet isn't protected
  • Confirm column mapping is correct

Content Strategy Tips

Topic Diversity

Use different RSS feeds to cover:

  • Industry news (30%)
  • How-to/educational (40%)
  • Opinion/thought leadership (20%)
  • Company updates (10%)

Engagement Tactics

  • Ask open-ended questions
  • Share contrarian viewpoints
  • Use data/statistics
  • Tell stories
  • Reference current events

Hashtag Strategy

The AI will suggest hashtags, but consider:

  • Mix broad (#AI, #Technology) with niche (#B2BMarketing)
  • Use 3-5 hashtags maximum
  • Track which hashtags drive engagement
  • Create a branded hashtag

Next Steps

Week 1: Setup & Testing

  • Import workflow and configure credentials
  • Add 3-5 relevant RSS feeds
  • Generate 20 sample posts
  • Review and refine AI prompts

Week 2: Content Production

  • Start posting 3-5 times per week
  • Track performance metrics
  • Identify top-performing topics
  • Adjust filtering criteria

Week 3: Optimization

  • Analyze what content resonates
  • Fine-tune AI prompts based on results
  • Experiment with posting times
  • Build a content backlog

Week 4: Scale

  • Add more RSS feeds
  • Create content variations
  • Build workflow #2 (Document Processing)
  • Package as a service for clients

Packaging This as a Service

Offer to clients:

  • "LinkedIn Content Automation Package"
  • Price: $500-1500/month
  • Include: Setup, custom RSS feeds, brand voice tuning, first month management
  • Upsells: Performance reporting, direct LinkedIn posting, multi-platform expansion