LinkedIn Job to Contact List in Google Sheets
Takes a LinkedIn job posting URL as input, identifies the hiring company, finds contact information for relevant decision-makers (like HR, Recruiters, or Hiring Managers) at that company, and then automatically adds the enriched contact data to a specified Google Sheet.
This powerful automation streamlines your job-seeking or lead-generation efforts. Simply provide a link to a LinkedIn job posting, and the automation gets to work. It first analyzes the job to identify the hiring company and its location. Then, it intelligently searches for the company's website and uses advanced logic to find the correct parent company, even if the job is posted by a small subsidiary.
Next, it taps into a B2B enrichment service to find key contacts—such as Recruiters, HR, and Hiring Managers—at that company, filtering them by the job's location to ensure relevance. Finally, it enriches these contacts with details like their full name, job title, verified email address, phone number, and LinkedIn profile, and neatly appends all this information into a Google Sheet you specify.
Usage Ideas
- Job seekers can find direct contacts at a hiring company to network and stand out from other applicants.
- Sales development teams can use active hiring as a buying signal to identify growing companies and find key decision-makers to contact.
- Recruiting agencies can perform competitor analysis or quickly source contacts at target companies.
- Market researchers can gather data on which companies are hiring for specific roles and in what locations.
Customization Ideas
This template is a great starting point and can be easily customized to fit your specific needs. You can:
- Target Different Roles: Change the job titles you're searching for. Instead of HR and Recruiters, you could look for 'Sales Managers', 'Marketing Directors', or 'Founders'.
- Change Your Output: While this template saves results to Google Sheets, you can modify it to send the contact list to a different destination, such as your CRM, an Airtable base, or as a Slack message.
- Customize the Data: Adjust the columns and information saved for each contact. You might want to add, remove, or reorder fields like email verification status, contact location, or company domain.
- Control the Scope: Easily set the maximum number of contacts you want to find for each company and specify a particular country or region to search within.
Agent Inputs
Required Parameters
Name | Type | Default |
|---|---|---|
googleSheetUrl | string | None |
URL of the Google Sheet where enriched contact results are appended | ||
linkedinJobUrl | string | None |
The LinkedIn job posting URL to analyze (e.g., https://www.linkedin.com/jobs/view/...) | ||
Optional Parameters
Name | Type | Default |
|---|---|---|
contactLocation | string | |
Location to filter contacts by (e.g., "France"). If not provided, the country is automatically extracted from the job posting's location field. | ||
maxContacts | number | 5 |
Maximum number of HR/Recruiter/Hiring Manager contacts to find per company. Use -1 to find all available contacts. | ||
