Google Sheets
Google Sheets
When rows are added to Google Sheet Google Sheet (Argument: Google Sheet)
Autobook Icon
Google Sheets
Enrich and update leads from a Google Sheet, when new row is added [Beta]
Enrich and update leads from a Google Sheet, when new row is added [Beta]
Enrich and update leads from a Google Sheet, when new row is added [Beta]
Enrich and update leads from a Google Sheet, when new row is added [Beta]

Enrich and update leads from a Google Sheet, when new row is added [Beta]

This automation uses a beta feature names Always-On. It will monitor and enrich leads from a Google Sheet using a lead's email address and Apollo. It will then update the Sheet with all the results even if your local machine is turned off.

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

Navigating the intricacies of lead management just got a whole lot smoother. Ever felt the frustration of missing out on potential leads because your local machine took a coffee break? This automation, leveraging the beta feature Always-On, is here to bid farewell to those worries. Now, seamlessly monitor and enrich leads from your Google Sheet using Apollo, irrespective of your machine's whims. 

Picture this: Effortless lead updates, even if your computer decides it's time for a nap. No more wrestling with downtime or imagining lost opportunities. 

It's the antidote for those who've felt the sting of missed connections in the world of leads, ensuring you're always in the loop, no matter when your machine decides to call it a day.

Let’s set it up!

Step 1: Set up the automation

The first step is to have your Google Sheet ready with your leads and their email addresses.

Take note of the column name with the email addresses. You will need this when setting up your automation. For the example above, that is “Email Address”.

Step 2: Save the automation

Click the “Try it” button at the top of this page to get this Autobook saved.

You will be redirected to download the browser extension when you run it for the first time. Bardeen will also prompt you to integrate and Google Sheets, if you haven’t done so already. 

To integrate, you will need to find and enter your API key.

If you are unsure how to do this, click here to follow Apollo’s guide. 

Bardeen will then prompt you to enter the Google Sheet spreadsheet and the name of the column that contains the email addresses. 

Step 2: Run the autobook to enrich and update leads from a Google Sheets

Make sure the automation is activated (toggled on).

Once new leads are added to your Sheet, Bardeen will use to get more information on each lead and update the Google Sheet with the information.

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

Action Flow


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
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.
No items found.