Scrape high-engagement LinkedIn posts and auto-post with Gemini images

Who's it for

This workflow is ideal for:

- Content creators who want to replicate successful LinkedIn strategies - Social media managers monitoring competitor content performance - Marketing teams analyzing trending topics in their industry - Personal brands looking to create data-driven content - Agencies managing multiple LinkedIn accounts

What it does

This comprehensive workflow automates the entire LinkedIn content lifecycle: it scrapes viral posts from target accounts, analyzes engagement patterns, identifies trending topics, generates original AI-powered content based on those trends, creates accompanying images, and automatically publishes to your LinkedIn profile or company page.

How it works

Phase 1: Data Collection (Runs every 12 hours)

- Scheduler triggers the workflow twice daily - Fetches LinkedIn profile URLs from Google Sheets - Processes profiles in batches of 3 to respect API limits - Uses Apify API to scrape recent posts from each profile - Adds 3-second delays between requests to avoid rate limiting - Filters for high-engagement posts (20+ likes, comments, or reposts) - Saves viral posts to Google Sheets with full metadata