The LinkedIn Profile Tracker
Monitors a list of LinkedIn profiles from a Google Sheet for job changes, updates the sheet, and sends an email summary of any detected updates.
Cesar Sanchez
Featured Apps
This automation helps you stay informed about career moves within your professional network. It systematically works through a list of LinkedIn profiles you provide in a Google Sheet.
Here's how it works:
- Read Profiles: The automation starts by reading the list of LinkedIn profile URLs and their current details from your specified Google Sheet. You can copy and use this spreadsheet to start.
- Fetch Latest Data: For each person, it uses a LinkedIn integration to retrieve their latest professional information, including their current job title, company, and location.
- Compare and Detect: It then compares this fresh data with the information stored in your sheet.
- Update and Timestamp: If any changes are found, the automation instantly updates the corresponding row in your Google Sheet with the new details and adds a "Last Checked" timestamp. Even if no changes are found, the timestamp is updated to record that the profile was checked.
- Notify on Change: If one or more profiles were updated, a single, consolidated email is sent to you. This email provides a clear summary of all the changes, formatted as "old value → new value," making it easy to see what's new at a glance. If no one on your list has made a move, the automation finishes silently without sending an email.
Usage Ideas
- Sales Prospecting: Track key prospects and receive alerts when they move to a new company, creating a warm outreach opportunity.
- Talent Sourcing: Monitor a pipeline of potential candidates and be the first to know when a star performer might be looking for a new role.
- Competitive Intelligence: Keep an eye on employee movement at competitor companies to spot trends or strategic shifts.
- Alumni & Network Management: Stay connected with your professional network or company alumni by keeping up-to-date with their career progression.
- Investor Relations: Track the leadership teams of portfolio companies or potential investment targets.
Customization Ideas
This template provides a powerful foundation that you can easily tailor to your specific needs. You have the flexibility to:
- Connect Your Data: Use any Google Sheet by simply providing its URL. You can also customize the names of the columns (e.g., "Profile URL", "Current/Last Company") to match your existing sheet's layout.
- Choose Your Notification Channel: While it defaults to sending a Google Mail message, the notification step can be modified to send alerts to other services, such as Slack or Microsoft Teams.
- Customize Alerts: You can completely rewrite the notification message. Change the email subject line, edit the body content, and adjust the formatting to create the perfect alert for you or your team.
- Define What to Track: By default, the automation tracks changes to a person's company, job title, and location. You can adjust this to monitor other professional details available on their profile.
- Use Different Tools: If you don't use Google Sheets, the data source can be swapped out for another service like Airtable to read and store the profile information.
Notes
You can use this spreadsheet to start:
https://docs.google.com/spreadsheets/d/1yQ8JnordKwNoHt8RNTM-7jlzT-5PoVmjmyhABYmRHhE/copy
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
emailRecipient | string | None |
Email address where change notifications will be sent. | ||
googleSheetUrl | string | None |
URL of the Google Sheet containing LinkedIn profile data to monitor. The sheet must have columns: Profile URL, First Name, Last Name, Location, Current/Last Title, Current/Last Company, and Last Checked. | ||
