What this workflow does
Automatically scrapes LinkedIn profile posts for multiple users and saves structured data to Google Sheets. No LinkedIn login, cookies, or browser automation needed — it uses the Apify API directly.
Actor used: LinkedIn Profile Posts Scraper by API Maestro
How it works
- Reads LinkedIn usernames from a Google Sheet
- Runs the Apify actor for each username (processes sequentially)
- Waits for results (up to 3 minutes per profile, responds as soon as data is ready)
- Transforms nested post data into clean flat columns
- Appends results to an output Google Sheet
Data extracted per post
- Post text, URL, and type (regular, quote, repost)
- Engagement metrics: reactions, likes, comments, reposts
- Author info: name, headline, username
- Dates: exact timestamp and relative date
- Media: type and URL (images, videos, documents, articles)
- Reshared post detection
Use cases
- Content research: Analyze what top performers post and what gets engagement
- Competitor monitoring: Track competitor LinkedIn activity automatically
- Social selling: Build prospect intelligence from their posting history
- Engagement analytics: Identify trends in post types, timing, and reactions
Setup (5 minutes)
- Apify API token: Create a free account at apify.com, get your token from console.apify.com/account/integrations. Add it as a Query Auth credential in n8n with name
token. - Google Sheets: Connect your Google account. Create two sheets — an input sheet with a
usernamecolumn, and an empty output sheet. - Configure nodes: Set your sheet URLs in the “Read Usernames” and “Save to Google Sheets” nodes.
- Run it: Add usernames like
neal-mohanorsatyanadellato your input sheet and click Execute.
Nodes used
Manual Trigger, Google Sheets (read + append), HTTP Request (x2), Code, Split In Batches
Workflow JSON
Built by APIMaestro — more LinkedIn scrapers available on the Apify Store.