Automate LinkedIn Comment Scraping to Google Sheets

Transform your LinkedIn engagement analysis with this powerful n8n workflow that automatically extracts comments from LinkedIn posts and organizes them in Google Sheets. Perfect for marketers and social media managers who need to analyze community interactions without manual data entry.

What this workflow does

This automation streamlines LinkedIn comment collection through a seamless 5-step process. Users submit a form with a LinkedIn post URL, triggering the workflow to create a dedicated Google Sheets spreadsheet named after the post. The system sends a POST request to Apify's LinkedIn comment scraper actor, which fetches all comments and replies from the specified post. Raw data is then transformed using a Set node to extract four essential fields: Comment text, Author (formatted as clickable hyperlink), Author Headline, and Comment URL. Finally, each processed comment populates a new row in the automatically generated Google Sheet for immediate analysis.

Use cases

• Sentiment analysis: Collect customer feedback and opinions from LinkedIn posts to gauge brand perception
• Lead generation: Identify potential prospects who engage with industry-relevant content
• Community management: Track engagement patterns and respond to comments more efficiently
• Competitive research: Analyze competitor post engagement and audience reactions
• Content strategy: Understand which topics generate the most discussion and engagement

Technical details

This LinkedIn automation workflow leverages key n8n nodes including Form Trigger for URL submission, HTTP Request node for Apify API integration, Set node for data transformation, and Google Sheets nodes for spreadsheet creation and data population. The workflow requires an Apify account with API access to the LinkedIn comment scraper actor, plus Google account permissions for Sheets and Drive access.

Setup involves configuring the form submission trigger, adding Apify API credentials, connecting your Google account, setting the target Google Drive folder, and verifying column mapping alignment. This workflow is ideal for growth hackers, marketers, and social media managers seeking to automate LinkedIn comment scraping without manual copy-pasting.