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!
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.
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.
This playbook saves me 60-90 minutes that I'd spend copy-pasting 20 new jobs details from LinkedIn daily - now it only takes me 5 minutes. Gamechanger!