Print

Import Abstract API Data to Google Sheets

In this guide, we’ll walk through how to pull data from Abstract API directly into Google Sheets, using the API Connector add-on for Sheets.

Abstract API provides a suite of utility APIs with functionality ranging from validating emails to looking up IP addresses and creating avatars. For this tutorial, we'll look at their Company Enrichment API, which is very convenient for developing leads or conducting market research. You can adapt the below instructions for any of their APIs.

Contents

Before You Begin

Click here to install the API Connector add-on from the Google Marketplace.

Part 1: Get Your Abstract API Key

  1. Log in to Abstract API and navigate to Company Enrichment. Their free plan provides 100 free calls a month, so you don't need to upgrade unless you need more than that.
    abstract-sidebar
  2. You should be in the "Try it out tab", where you'll see your API key and a pre-written request
    abstract-livetest
  3. Copy the entire pre-written request, as we'll use that next.

Part 2: Pull Abstract API Data into Sheets

  1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
  2. In the request form enter the following:
    • ApplicationCustom
    • MethodGET
    • Request URLpaste in the URL from above
  3. Create a new tab and click Set current to use that tab as your data destination.
  4. Name your request and click Run. A moment later you’ll see data from your test request populate your Sheet.
    abstract-response

Part 3: Reference Data in Your Sheet

You may want to look up data about companies listed in your sheet. In this section we'll show how to run a multi-query request (paid feature) for a list of domains.

  1. List your domains in a tab. Let's call that tab Domains
  2. Where your request URL currently reads airbnb.com, replace it with a cell reference, e.g. https://companyenrichment.abstractapi.com/v1/?api_key=1111111111&domain=+++Domains!A1:A10+++.
  3. Now API Connector will run down that list, running a request for each of the 10 domains in your list.
    abstract-multiresponse
  4. Google Sheets only lets requests run for about 6 minutes, so you can probably only run through a list of about 500 domains with this technique. If you have more, switch to Append mode and set the next request to begin where the prior one left off.

Part 4: API Documentation

Official API documentation: https://docs.abstractapi.com/company-enrichment

Leave a Comment

Jump To