Scrape LinkedIn post comments into Google Sheets with Apify

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

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

1. A user submits a form providing the LinkedIn post URL to trigger the workflow. 2. A new Google Sheets spreadsheet is automatically created and named after the post URL to store the results for that session. 3. The workflow sends a POST request to Apify's LinkedIn comment scraper actor, which fetches all comments (including replies) from the given post. 4. 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. 5. 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