Publish LinkedIn posts from tech trends with Ollama AI quality checks

Who is this for?

This workflow is for solopreneurs, founders, creators, and marketers who want a consistent LinkedIn presence without spending hours writing posts. Ideal for anyone in tech, SaaS, or AI who wants trend-aware content on autopilot.

What it does

Flow 1 — Daily Research (6 AM): - Fetches trending topics from Hacker News, Reddit (8 subreddits), and Product Hunt in parallel - Merges all sources, runs 7-layer deduplication, and ranks by relevance - AI generates 3 LinkedIn post drafts with different angles - Saves all drafts to a Google Sheets queue with status tracking

Flow 2 — Smart Publish (Tue/Wed/Thu at 9:30 AM): - Reads all unpublished drafts from Google Sheets - AI Selector picks the single best draft for today - Selected post passes through an AI Quality Gate (scored 1–10) - Approved posts publish to LinkedIn with a hashtag comment - Posts needing revision get auto-rewritten, then published - Rejected posts are skipped; Telegram notifications on every action

Setup steps

1. Google Sheets — Create a spreadsheet with columns: Post ID, Angle, Hook Line, Full Post, Hashtags, Trend Referenced, Word Count, Best Day, Posting Notes, Status, Created Date, Published Date, LinkedIn URL, AI Review, Revised Post, Dedup Stats, Generated At 2. Ollama — Install locally and pull your preferred model (e.g., ollama pull mistral) 3. LinkedIn OAuth — Register an app at developer.linkedin.com with wmembersocial scope, get your Person URN 4. Telegram Bot — Create via @BotFather, get your bot token and chat ID 5. AI Prompts — Edit the system prompts in AI Writer, AI Selector, and AI Quality Gate nodes to match your persona and brand voice 6. Test — Run the research flow manually first, verify drafts appear in your sheet, then test the publish flow

Requirements