Import Amazon Data To Google Sheets

Import Amazon data to Google Sheets
Reading Time: 5 minutes

In this article, we’ll learn how to import Amazon data to Google Sheets. We can scrape product details such as titles, images, prices, ratings, and reviews, find deals, and a bunch of other things. We can then easily compare products, keep track of market pricing trends, and keep an eye on competitors.

All these can be easily done with the Amigo Google Sheets extension which lets us easily and quickly scrape data from multiple e-commerce sites and from various other data sources. 

Read on to learn how to import Amazon data to Google Sheets. But first, let us get familiar with the steps involved.

  1. Install the Amigo extension in Google Sheets
  2. Get the API endpoint URL
  3. Pull the data to Google Sheets

How to import Amazon data to Google Sheets

Install the Amigo extension in Google Sheets

Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace.

Amigo in Google Workspace Marketplace

Click here to install.

Alternatively, you can get it from Google Sheets.

  • Open a new sheet
  • Go to Extensions→Add-ons→Get add-ons
  • Search for Amigo and install

Get the API endpoint URL

Sign up or log in to RapidAPI.

Click this link to go to the Amazon API documentation in RapidAPI. Or simply search for Amazon API in the RapidAPI Hub and click the top result.

Amazon API documentation page in RapidAPI

Click on the Subscribe to Test button and subscribe to a plan of your choice, after which you’ll be able to run the test and import Amazon data to Google Sheets.

Subscribe to the API

Click Endpoints to go back to the API Playground. On the left is the list of the type of data that can be retrieved.

List of available data
Product endpoints

We’ll use the /api/product/[productId] as an example to scrape data such as the product URL, images, prices, and discounts among other things.

Under Required Parameters, we need to fill in the product ID of the product details we want to retrieve.

Product ID

Note: The product ID can be found in the URL of the product listing. The alphanumeric characters following /dp/ is the product ID.

Product ID in the URL

The Optional parameters can be left blank. We can also use the productURL parameter in the Optional Parameters instead of using the productId in the Required Parameters to scrape the product data.

Paste the product listing URL in Amazon in the productURL field and set the productId to 0.

Opitonal parameters

The API endpoint URL along with the headers–which will be required to import Amazon data to Google Sheets–can be found in the Code Snippets section.

Change the language from Node.js (Axios) to Shell→cURL. Copy the URL and note also the headers.

The API endpoint URL and headers

Pull the data to Google Sheets

Open Google Sheets and launch Amigo. To connect to Amigo, go to Extensions→Amigo: Data Exports and Reports→Connect.

Launching the Amigo Add-on

We’ll be presented with a list of sources to connect and import data. Select Custom API.

Select Custom API as the source to connect

Paste the endpoint URL (without the apostrophes) in the API URL field.

Entering the endpoint URL

Then expand the Details tab and enter the headers. The headers can be found in the Code Snippets. The characters to the left of the colon are the header names and those to the right are the header values. Enter these as separate headers. Do not include the apostrophes.

Name: X-RapidAPI-Host, Value: amazon24.p.rapidapi.com

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

Entering the headers

Preview of the data

The data will be imported into Google Sheets in a moment. Below is a snippet of the imported data.

Snippet of the imported data

Visit our blog for to find out about the kinds of data that you can import to Google Sheets and many other useful–and also cool–things you can do with Amigo Data.

Some recommended articles:

Connect Amazon Marketplace to Google Sheets

How to Connect Shopify to Google Sheets

Import eBay Data To Google Sheets And Find The Best Deals

X
Hire expert data analysts on-demand. Get 30 Days Free Trial