Import Walmart Data To Google Sheets

Import Walmart data to Google Sheets
Reading Time: 5 minutes

Many strategies and methods have been contrived on how to get the best shopping deals. And numerous articles have been written on them that to add one more to the stockpile will not increase their usefulness, but, on the contrary, will diminish their values–for now filtering the wheat from the chaffs becomes a harder task. Or so you think. And true that.

But this one is different. It’s novel, unconventional, and, unlike many others, it works. What you do is, find the best deals and offers before they even surface, thus enabling you to grab them before anybody else. We can connect Walmart to Google Sheets using Walmart API and retrieve offers, department information, product reviews and several others.

We’ll use a Google Sheets extension called Amigo. It’ll enable us to pull data from Walmart to Google Sheets. It’s easy to use, requires no coding or technical knowledge to use and does most of the tasks itself. The installation link can be found below. Use it and you’ll have an advantage in hunting Black Friday deals.

Read on to find out how. But first, let us get familiar with the steps to import Walmart data to Google Sheets.

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

Steps to import Walmart data to Google Sheets

Install the Amigo extension in Google Sheets

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

Amigo Data 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.

Search for Walmart and click the first option from the results. Or click this link to go directly to the Walmart API documentation page.

Walmart API in RapidAPI

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

Subscribe to test button

Click Endpoints to go back to the API Playground. On the left is the list of available endpoint categories.

List of endpoint categories
Endpoints under product category

Click the products/v2/list endpoint to retrieve a list of products for a given product category–eg, electronics, Black Friday Deals.

This endpoint has one required parameter–the cat_id. This the department ID for the product category and can be found in department/v3/list endpoint. For example, the cat_id for “Electronics” is 3944.

The category ID

Enter the deptId value got from the department list endpoint in the cat_id field.

The category ID
The optional parameters

The API endpoint URL along with the headers–which will be required to import Walmart 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 from the sheet into which you want to fill in the data. To connect to Amigo, click Extensions→Amigo: Data Exports and Reports→Connect.

Connect to Amigo

You’ll be presented with a list of sources to connect to. Choose Custom API.

Select Custom API as the source to connect

Paste the endpoint URL in the API URL field. Do not include the apostrophes. (Likewise for the headers.)

Entering the endpoint URL in Amigo

Then expand the Details tab and enter the header. For the endpoint we’ve selected, the headers are:

Name: X-RapidAPI-Key, Value: YOUR_API_KEY

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

The headers

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

Snippet of the imported data

Similarly, we can search for products, offers for a specific product, get a list of stores and get a list of deals. For more information and to explore the endpoints, visit the Walmart API documentation.

If you want to constantly keep watch of the deals and the prices but have no time or eyes to do it, you can simply set an automatic refresh schedule and Amigo Data will retrieve the latest data and send them to you via email. Click here to learn how to set a refresh schedule.

Visit our blog 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:

Import eBay Data To Google Sheets And Find The Best Deals

Import Realtor Data To Google Sheets

How to Connect Shopify to Google Sheets