Track LinkedIn Profile Updates
This automation monitors a list of LinkedIn profiles stored in a Google Sheet for any job changes. When a change in company, title, or location is detected, it updates the Google Sheet with the new information and sends a summary email notification.
This automation acts as your personal career tracker for a list of contacts. Here’s how it works:
- Read Your List: It starts by reading a list of people from a Google Sheet you provide. It expects to find columns for their LinkedIn profile URL, name, and current job details (company, title, location).
- Check LinkedIn: For each person on your list, the automation securely accesses their LinkedIn profile to retrieve their most up-to-date career information.
- Compare and Detect: It compares the fresh data from LinkedIn with the information you have stored in your Google Sheet.
- Update Your Sheet: If it finds any differences—a new job, a promotion, or a move to a new city—it automatically updates the corresponding row in your Google Sheet with the new details.
- Notify You: After checking all profiles, if any changes were found, it sends a single, consolidated email to an address you specify. This email neatly summarizes all the updates, letting you know who changed jobs and what's new.
If no changes are detected, the automation simply finishes its run without sending an email, keeping your inbox clean.
You can use this GSheet as an example: https://docs.google.com/spreadsheets/d/1YaQntGXBmpHGGzZHWWdu2WbYVlOYkkR-hYXwA-Rjf4o/copy
Usage Ideas
- Sales & Business Development: Track key prospects and customers. Get an alert when a contact moves to a new company, creating a warm lead or an opportunity to expand your relationship.
- Recruiting & HR: Maintain a "watch list" of high-potential candidates. Be the first to know when they might be open to a new role. You can also track the career paths of former employees.
- Alumni & Network Management: Keep your alumni or professional network database current automatically.
- Competitive Intelligence: Monitor the movement of key personnel at competitor companies.
Customization Ideas
This template is a powerful starting point that can be easily tailored to your specific needs. You can work with an AI assistant to:
- Change Your Data Source: While it's set up for Google Sheets, you can modify it to read your list of contacts from other spreadsheet tools or databases.
- Customize Your Sheet Layout: Don't have columns named "Current / Last Title"? No problem. You can tell the automation what your columns are named and how they are organized.
- Modify Notification Channels: Prefer to get updates in Slack or Microsoft Teams instead of email? The notification step can be changed to send messages to the platform of your choice.
- Tailor Notification Content: You can completely customize the content and format of the notification. Change the email subject, rewrite the body, or include different information about the detected job changes.
- Control Data Updates: You can decide whether to update your source Google Sheet with new information, save the changes to a different file, or simply receive the notification without altering any data.