Scrape LinkedIn post comments into Google Sheets with Apify

Description

📺 Full walkthrough video: https://youtu.be/y63_F9l_eiU

Who it's for

This workflow is for marketers, growth hackers, and social media managers who want to collect and analyze comments from LinkedIn posts without manual copy-pasting. It is especially useful for community managers running outreach or sentiment analysis.

How it works

A user submits a form providing the LinkedIn post URL to trigger the workflow.
A new Google Sheets spreadsheet is automatically created and named after the post URL to store the results for that session.
The workflow sends a POST request to Apify's LinkedIn comment scraper actor, which fetches all comments (including replies) from the given post.
The raw Apify response is transformed using a Set node, extracting four key fields: Comment, Author (as a clickable hyperlink), Author Headline, and Comment URL.
Each processed comment is appended or updated as a row in the newly created Google Sheet for easy review and export.

How to set up

[ ] Configure the On form submission trigger with the Post URL field
[ ] Add your Apify API credentials in the HTTP Request node
[ ] Connect a Google account with Sheets and Drive access to both Google Sheets nodes
[ ] Set the target Google Drive folder in the 'Create spreadsheet' node
[ ] Verify the column mapping in the 'Set Comment Fields' node matches your sheet headers

Requirements

Apify account with API key and access to the LinkedIn comment scraper actor
Google account with Google Sheets and Google Drive access

How to customize

Extend the 'Set Comment Fields' node to capture additional Apify fields such as comment likes, timestamps, or reaction counts.
Add a Filter node after scraping to store only comments containing specific keywords or from specific authors.
Replace the form trigger with a scheduled trigger or a webhook to automate scraping for multiple posts in batch.