Marketing & Sales · Tip

Automated LinkedIn Content Pipeline in n8n

A three-part n8n workflow for scraping X, drafting posts, and publishing.

This blueprint outlines a complete end-to-end LinkedIn content automation built inside n8n. It scrapes relevant tweets from X daily, uses an AI agent to draft posts for Telegram approval, and automatically schedules and publishes approved drafts to LinkedIn. It is designed to run automatically using free tiers and self-hosted tools.

How it works

Flow 1 — Scrape X: 5AM Everyday (schedule trigger) → Get AI Tweets (GET https://twitter241.p.rapid... via RapidAPI) → Clean Tweets (code) → Loop Tweets → Find Existing Tweet (read Google Sheet) → Switch (Rules: New / Exists) → if New: Wait → Save New Tweet (append to Sheet); if Exists: 'Already Exists, Ignore' → All Done, End.

Flow 2 — Generate AI Posts: 6AM Daily (schedule) → Google Sheets (read) → Limit → AI Agent (Tools Agent, with sub-nodes: 4.1 model, Chat Mode Memory, Structured Output Parser) → Loop Posts → when Done: Aggregate → Telegram (sendMessage message) — sends drafts to Telegram for approval — and Wait1 → Google Sheets1 (update Sheet).

Flow 3 — Post approved content: Updated News (rowUpdate trigger) → Filter Approved → Max 20 → Get Post Timings (code) → Loop Approved Posts → Wait for Posting → Set Posting (update Sheet) → Download Image → Post LinkedIn (create post) → Set Posted (update Sheet).

What it's for

  • Scrape niche tweets from X daily into a Google Sheet
  • Generate structured LinkedIn drafts from curated tweets using AI
  • Review and approve social media drafts directly via Telegram
  • Schedule and publish approved posts automatically to LinkedIn

Key points

  • Flow 1: Scheduled RapidAPI tweet scraping with deduplication against Google Sheets
  • Flow 2: AI agent drafting using chat memory and structured output parsers
  • Telegram notification step for human review and draft approval
  • Flow 3: Google Sheets row trigger to pick up approved posts and compute timing offsets
  • Automated media handling and LinkedIn publishing node

Pricing

Free to build and run using self-hosted n8n and API free tiers

Details

Type
Tip
Category
Marketing & Sales
Topic
Social Media Automation
Open source
No
Platforms
Self-hosted, Web
For
Content creators, solopreneurs, and automation builders using n8n
Alternative to
Buffer, Taplio, Make, Zapier
Tags
n8n, linkedin, automation, twitter, telegram, ai agents

Why it was saved

  • @architjn, 29 May 2025: Complete blueprint of a real automation the author actually uses, and he states it is completely free to execute — a rare full-architecture reveal rather than a teaser.

Compare

Related

All 16 in Social Media Automation →

Updated