Google Sheets
Google Sheets
Google Mail
Google Mail
Linkedin
Linkedin
Autobook Icon
Google Sheets
Create personalized recruiting emails using LinkedIn profile links in Google Sheets
Google Mail
Create personalized recruiting emails using LinkedIn profile links in Google Sheets
Linkedin
Create personalized recruiting emails using LinkedIn profile links in Google Sheets
Create personalized recruiting emails using LinkedIn profile links in Google Sheets

Create personalized recruiting emails using LinkedIn profile links in Google Sheets

This playbook will enrich contacts in a Google Sheet using Apollo.io and their LinkedIn profile links. It will then update the Google Sheet with personalized recruitment emails and additional information obtained from Apollo.io

Bardeen automates your repetitive tasks without code.
Install the Chrome extension for free.

Navigating the tangled web of contacts between Apollo.io and LinkedIn, updating Google Sheets can feel like deciphering an intricate puzzle. The tedious chore of aligning LinkedIn profiles with relevant data is a digital pain point we've all felt. But now, envision a playbook that elegantly dances through these platforms, seamlessly enriching your Google Sheet contacts. 

No more grappling with the chaos of mismatched information or the monotony of manual updates. This digital maestro not only extracts vital LinkedIn insights but also transforms your Google Sheet into a treasure trove of personalized recruitment emails and additional details from Apollo.io. 

Streamlining your recruitment process, it turns the mundane into a harmonious blend of efficiency and tailored communication, leaving you with more time for strategic talent acquisition.

Let’s set it up!

Step 1: Create a Google Sheets spreadsheet

The first step is to create a Google Sheet with the LinkedIn profiles that you want to send emails for.

Bardeen will extract information from the Google Sheet using the LinkedIn links and Apollo.io. It will then use the information to enrich the sheet with contact information like social media links, location data, email addresses, phone numbers and more. Finally, it will create personalized recruitment emails for each contact and update the spreadsheet with the information.

Step 2: Install the extension and choose your email bot

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. Click the “Pin it” button at the top of this page to get this automation saved to your Playbooks.

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 choose or specify your email bot. You can choose an existing bot that you created in the past or customize a new one from the dropdown. For the purpose of this tutorial, let’s choose to customize an email bot.

BardeenAI will begin customizing your email bot by gathering information about you using tools like Apollo.io.

It will then display all the pre-filled information it has found about you.

Review this information and make edits if necessary. This information will be used when constructing your recruiting emails.

After you have read, edited and approved all the information, your email bot is now ready. Bardeen will also ask you to input an optional scheduling link to include in your emails. You will also need to enter the column name that contains your LinkedIn profile links. For our purposes, this is “Profile Link”.

Click on “Save Input” and check mark your email bot, the scheduling link, the maximum number of profiles and the Google Sheets spreadsheet. This will save you time from setup in the future. You can edit Inputs later by hovering over the playbook. 

Step 3: Run the playbook to create personalized recruiting emails using LinkedIn profile links in Google Sheets

To enrich and create recruiting  emails from LinkedIn profiles, activate Bardeen (or hit Option + B on Mac or ALT + B on PC on your keyboard) and run this playbook. It will use the LinkedIn links to get information about the contacts using Apollo.io. It will also use the information and your email bot to generate customized recruitment emails for each contact. Finally, the playbook will update the spreadsheet with the new information.

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

Find more Google Sheets and LinkedIn integrations.

You can also find more about how to increase your personal productivity and automate your recruiting process.

Action Flow

Input

When running a Play- or Autobook you'll be asked for following information:

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

Discover more website data scraping possibilities with ready to use instant data scrapers, or learn how to scrape website data.

Creator Avatar
Creator
Bardeen
Last update:
November 20, 2023

Related & similar Playbooks

Related articles

Why our users love Bardeen

Little Rocket Ship

Launch your productivity boost today.

By clicking “Accept All Cookies”, you agree to the storing of cookies. View our Privacy Policy for more information.