LinkedIn Company and Employee Post Extractor and Analyzer
This automation extracts recent LinkedIn posts from a specified company and its employees, analyzes the content of each post using an AI model, and saves the collated data and analysis into a new Google Sheet for review.
Airtop Community
Featured Apps
This automation provides a comprehensive overview of a company's and its employees' recent activity on LinkedIn. Here’s how it works:
- Gathers Inputs: It begins by reading data from two Google Sheets you provide: one listing company LinkedIn URLs and another listing employee profile URLs for that company.
- Fetches Posts: The automation connects to LinkedIn to retrieve recent posts from both the main company page and the profiles of each listed employee. It intelligently filters out reshared posts to focus only on original content and ignores posts older than a specified number of days.
- Analyzes Content: Using a powerful AI model, it analyzes the text of every post to determine its main topic, summarize the key message, and identify the content type (e.g., text, article, video).
- Enriches Data: It gathers key engagement metrics for each post, including the number of likes, comments, and shares.
- Generates Report: Finally, the automation creates a new, neatly organized Google Sheet in your Google Drive. This report contains all the collected posts, their engagement stats, and the AI-powered content analysis, sorted with the most recent posts first.
This process gives you a powerful, structured dataset for competitive analysis, content strategy, or brand monitoring.
Usage Ideas
- Competitive Intelligence: Automatically track what your competitors and their key employees are posting about to stay ahead of their marketing and product strategies.
- Content Strategy Insights: Analyze your own company and team's posts to identify which topics and formats drive the most engagement.
- Brand Monitoring: Keep a pulse on how your brand is being represented by your company and employees on LinkedIn.
- Sales Prospecting: Gather intelligence on target accounts by monitoring their company and key decision-makers' posts for conversation starters and business needs.
- Market Trend Analysis: Aggregate posts from multiple companies in an industry to spot emerging trends and key discussion topics.
Customization Ideas
This template is a powerful starting point that you can easily tailor to your specific needs. You'll have the flexibility to:
- Target Any Company: Simply specify the company you want to analyze from your input sheet.
- Control the Scope: Easily adjust how far back in time to look for posts (e.g., the last 30, 90, or 180 days) and how many pages of posts to scan.
- Customize AI Analysis: Define your own set of topics and themes for the AI to use when analyzing post content. This allows you to categorize posts according to what matters most to your business (e.g., "Product Updates", "Hiring News", "Industry Trends").
- Organize Your Data: Provide your own Google Sheets for input data and specify the names of the exact sheets to use. You can also customize the name of the Google Drive folder where your final report is saved.
- Define Your Report: Modify the column headers in the final Google Sheet report to capture the specific data points you need.
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
companiesSheetUrl | string | None |
URL of the Google Sheet containing company data (columns: Company Name, Company URL) | ||
companyName | string | None |
Name of the company to extract LinkedIn posts for (must match a row in the Companies sheet) | ||
employeesSheetUrl | string | None |
URL of the Google Sheet containing employee data (columns: Company Name, Employee Name, Employee URL) | ||
Optional Parameters
Name | Type | Default |
|---|---|---|
folderName | string | linkedin-overview |
Google Drive folder name for organizing output spreadsheets | ||
maxPagesToFetch | number | 10 |
Number of pages to fetch for company posts (higher = more posts, older dates) | ||
postAgeDays | number | 90 |
Only include posts from the last N days | ||
