Import Keepa Data to Google Sheets

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

Note that the Keepa API is not free and requires a paid subscription to Keepa.

Contents

• Before You Begin
• Part 1: Get Your Keepa API Key
• Part 2: Pull Keepa 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 Keepa API Key

1. Log in to Keepa and go to https://keepa.com/#!pricedataapi
2. Your key will be listed there. That's it, you're now ready to use the Keepa API.

Part 2: Pull Keepa API Data into Sheets

For this example, we'll get information about a product. Substitute in your own API key where it says your_key, and (optionally) your own ASIN of interest.

1. Open up Google Sheets and click Extensions > API Connector > Open > Create request.
2. In the request form enter the following:
   • Application: Custom
   • Method: GET
   • Request URL: https://api.keepa.com/product?key=your_key&domain=1&stats=180&asin=B0B754K6Y8
3. This API returns a very large number of distinct fields. Under Output options, set the report style to Grid or Concatenate to reduce the total output. Compact style returns data in a nicer format, but takes a long time to run. JMESPath filters are another good way to filter the response to just the fields you need (send a message to support if you need help with that).
4. Create a new tab and click Set current to use that tab as your data destination.
5. Name your request and click Run. A moment later you’ll see data populate your sheet.
   
   
   

Part 3: API Documentation

Official API documentation: https://keepa.com/#!api

Project object documentation: https://keepa.com/#!discuss/t/product-object/116