Google Sheets
Google Sheets
Linkedin
Linkedin
Apollo.io
Apollo.io
Autobook Icon
Google Sheets
Qualify and enrich leads from a Google Sheet
Linkedin
Qualify and enrich leads from a Google Sheet
Apollo.io
Qualify and enrich leads from a Google Sheet
Qualify and enrich leads from a Google Sheet

Qualify and enrich leads from a Google Sheet

This Playbook will enrich leads from a Google Sheet using a lead's email address and Apollo. It will then search for information on various sources like LinkedIn and will make a qualification decision with all the available information based on your custom classifier. All the results will be saved on a new tab in your Google Sheet.

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

Ever grappled with the challenge of enriching leads manually, bouncing between Google Sheets and multiple platforms like Apollo and LinkedIn? The back-and-forth, the data scattering—it's a lead qualification obstacle course. But what if you could streamline this journey? Visualize effortlessly enriching leads from your Google Sheet, tapping into Apollo and LinkedIn for a comprehensive profile. 

This playbook not only eases the process but also empowers you to make informed qualification decisions based on your custom classifier. All the results neatly compiled in a dedicated tab within your Google Sheet. 

Say farewell to the lead qualification puzzle and embrace a more cohesive, efficient workflow. It's not just about automation; it's about simplifying your lead enrichment journey. Ready to let your Google Sheet become the command center for informed decisions?

Let’s set it up!

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.


Make sure your Google Sheet is setup with the email addresses of the leads that you want to qualify. Take note of the name of the column that contains the email addresses. For the example below, that would be “Contact Email”. We will need this column name during the setup.


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 customize your sales qualification task. Once you click this option, the qualification flow will start. Bardeen will ask you questions about your business.

It will then ask you to describe your qualification criteria. It’s important to give clear details here, as this prompt will be the main way Bardeen will qualify your leads. For the example below, I described clearly the criteria for my qualification based on the leads that I want to qualify.‍

Once this step is completed, Bardeen will ask you to train the model.

This step is optional. However, we recommend that you complete this step as it will increase the quality of your results.

After your qualification is entered, complete the setup by specifying or creating a Google Sheets spreadsheet. Bardeen will ask you to specify the column in the spreadsheet that contains the column of the email addresses in your spreadsheet. For our example, this was “Contact Email”


Click on “Save Input” and checkmark Google Sheets and your qualifier. You can edit Inputs later by hovering over the playbook. 

Step 2: Run the playbook to qualify and enrich leads from Google Sheets

To qualify your leads, press Option + B on Mac or ALT + B on PC on your keyboard to launch Bardeen. Click on the playbook card and run your playbook. It will get information for the leads using Apollo.io and analyze the information based on your qualification task. It will then add a tab to your Sheet with the qualification results and also include the information from ‍Apollo.


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 and prospecting workflow.

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.