Back to Templates
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.