Import DataForSEO Data to Google Sheets

In this guide, we’ll walk through how to pull SEO keyword, backlinks, and site data from the DataForSEO API directly into Google Sheets, using the API Connector add-on for Sheets.

Contents

• Before You Begin
• Part 1: Get DataForSEO API Key
• Part 2: Pull DataForSEO API Data into Sheets
• Part 3: API Documentation

Before You Begin

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

Part 1: Get Your DataForSEO API Key

1. Log into DataForSEO
2. In the lefthand navigation bar, click API Settings > API Access
3. You'll see your API password. Copy it and keep it handy as we'll use it shortly.
   
4. One last step: Because the DataForSEO API requires Basic Authentication, we need to encode the API login and API password in the screenshot above to base 64. You can do this by entering those values into this form in the format login:password (i.e. first your API login, then a colon, then your API password). Note that the API password is not the same as the password you use to log into the website.
   
   The encoding script runs in your browser, and none of your credentials are seen or stored by this site.
   Base64 Encode

Part 2: Pull DataForSEO Data into Sheets

Postman browser

DataForSEO provides a huge number of data points in their documentation. Therefore, I recommend you use their online Postman request browser . Once you find the endpoints you're interested in, you can copy their example curl request configurations into API Connector's curl import tool, as a fast way to get started.

We'll only use their endpoints marked as "live". The other endpoints require that you first send a request configuration through the POST method, then later send a second request to fetch the results with the GET method. The "live" endpoints provide immediate responses.

Example: Google Ads

For this example, we'll fetch keyword data from Google. Subsitute in your own encoded credentials from above where it says your_encoded_credentials.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: POST
   • Request URL: https://api.dataforseo.com/v3/keywords_data/google_ads/search_volume/live
   • Headers
     • Authorization: Basic your_encoded_credentials
     • Content-Type: application/json
   • Request body: [{"location_code":2840,"keywords":["buy laptop","cheap laptops for sale","purchase laptop"],"date_from":"2024-01-01","search_partners":true}]
     
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 keyword data populate your Google Sheet.
   
   

Part 3: API Documentation

Official API documentation: https://docs.dataforseo.com/v3/

Postman request browser: https://documenter.getpostman.com/view/2812008/UVR8qo6p#intro