Find all Job roles for a list of LinkedIn companies in Google Sheets

Manually scrolling through countless LinkedIn profiles, cross-referencing them with specific job roles, and transferring this information to a Google Sheets spreadsheet can be an incredibly tedious task. 

Whether you're a recruiter aiming to identify potential candidates or a professional looking to expand your network, the process can be time-consuming and error-prone.

This automation simplifies this journey by automating the search for people you may know based on a specified job role within a list of LinkedIn companies. It then neatly organizes and saves the results into a new tab in your Google Sheets spreadsheet. 

No more hours wasted on repetitive tasks or the risk of missing out on valuable connections. This automation aims to make your networking efforts more efficient and effective, helping you connect with the right individuals in your professional field.

Let’s set it up!

Please be aware that the excessive or abusive use of extensions, bots, or automation tools on some websites can lead to penalties, including temporary or even permanent restrictions on your account. We recommend you read and adhere to the specific terms of the websites you are visiting and using to avoid any disruptions or issues. We do not assume any responsibility for the consequences of abuse.

Step 1: Pin the playbook and integrate Google Sheets

First, click the “Pin it” button at the top of this page to save this automation. You will be redirected to install the browser extension when you run it for the first time. Bardeen will also prompt you to integrate Google Sheets if you haven’t done so already.

Activate Bardeen (or hit Option + B on Mac or ALT + B on PC on your keyboard) and click on the playbook card. The setup flow will start. Bardeen will ask you to specify the Google Sheets spreadsheet and the column that contains your links.

For example, the column that contains the links in the spreadsheet above is “Company”.

Bardeen will also ask you to specify the keyword. 

Click on “Save Input” and checkmark Google Sheets, your column and the keyword. This will save you time from setup in the future. You can edit Inputs later by hovering over the playbook. 

Step 2: Run the playbook to find job roles for a list of LinkedIn companies

Whenever you want to find job roles for companies from your spreadsheet, press Option + B on Mac or ALT + B on PC on your keyboard to launch Bardeen. Click on the playbook card and run the playbook to get the results. It will use the “LinkedIn People You Might Know” scraper and get the profiles based on your inputs. It will then save the information in a new tab and include headline, name and profile URL.

You can also edit the playbook and add your next action to further customize the automation.

Find more LinkedIn and Google Sheets integrations.

You can also find more about how to increase your personal productivity and automate your sales workflow.