Enrich company information from a list of domains in Google Sheets

Manually gathering and updating company information in a Google Sheet can be a repetitive and time-consuming task, especially when dealing with a long list of links. This Playbook simplifies the process by automatically finding company information for each link in your Sheet and updating the relevant rows with the latest details.

Whether you're maintaining a list of potential partners or tracking competitors, this automation saves you the hassle of visiting each site individually. For example, if you're compiling a report on industry trends, this Playbook will ensure your data is accurate and up-to-date. Similarly, it can help you quickly enrich a list of leads with key company information.

By streamlining data collection and entry, this Playbook enhances your efficiency, allowing you to focus on more strategic tasks.

Let’s set it up!

Step 1: Create a Google Sheets spreadsheet with a list of domains

The first step is to create a Google Sheet with the domains to the websites you want to enrich company information from.

Step 2: 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.

Activate Bardeen (or hit Option + B on Mac or ALT + B on a Windows machine on your keyboard) and click on the playbook card. The setup flow will start. Bardeen will ask you to specify the Google Sheets spreadsheet with the links and the column name for the specific column you have the domains in.

Step 3: Run the automation to enrich company information from a list of domains in Google Sheets

When you run the playbook, Bardeen will find company information for your list of company links in your Google Sheet and update the Sheet with the information for each company.

‍

‍