How To Use Product Search API To Find Latest Offers

Reading Time: 4 minutes

In this article, we will learn how to use product search API to import latest offers data to Google Sheets using Amigo. This API helps to query product offers from across the web in real-time from many major and minor stores – Amazon, eBay, Walmart, Best Buy, Target, and many more.

To import real-time product search data to Google Sheets, we will follow the steps below:

Product Search data imports to Google Sheets

Here’s the step-by-step guide to import real-time product search data to Google Sheets.

Install the Amigo Data add-on

Install the Amigo extension 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 extension and install

Generate the API key

Sign up or log in to  RapidAPI.

RapidAPI page to sign up

Once you’re logged in, go to the Real-time product search API documentation in RapidAPI.

Learn how to use product search api

Choose a subscription plan from the Pricing menu. In this tutorial, we will choose the Basic option

Click on the endpoints and scroll down a bit. You will find your API key under the Header Parameters.

Choose an endpoint

For this tutorial, we will find latest offers on iPhone with the Search endpoint. This endpoint provides us with multiple offers from all the various stores on the web. In the required parameter section, type in the item you wish to search for–which, in our case, is iPhone.

You can fine-tune the search results by specifying optional parameters like country, language, min_price, max_price, etc.

Click the Test Endpoint option to run the query.

The success message indicates that the endpoints are functioning correctly. 

On the right side under Code Snippets, select Shell-> cURL from the dropdown menu.

Select the cURL from Shell

Copy the URL excluding the apostrophes and also note the headers.

Import data to Google Sheets

Go back to Google Sheets and launch the Amigo Data extension.

Select Custom API from the list of sources.

Selecting the source in Amigo Data

Paste the endpoint in the API URL bar.

Pasting the endpoint

Then expand the Details tab and enter the following as headers:

Name: X-RapidAPI-Host, Value: real-time-product-search.p.rapidapi.com

Name: X-RapidAPI-Key, Value: your_key

Replace your_key with your RapidAPI key.

Then click the PREVIEW button.

Flatten the data points and then click IMPORT.

Click to preview, flatten and import

A snippet of the imported data.

Snippet of imported data

You can likewise import other types of data from Real-time Product Search API. Following are some other examples.

Product offers data

Using the Product Offers endpoint, you can import the data for all the offers that are available for the product. In the required parameters section, type in the product_id of the item you wish to search for. The product_id can be obtained from the Search endpoint which can be seen from the snippet of the imported data. You can filter the search results by specifying country and language parameters in the optional section.

Product reviews data

Using the Product Reviews endpoint, you can import all the reviews for a product. In the required parameters section, type in the product_id of the item you wish to fetch reviews for. You can get refined search results by specifying optional parameters like country, language, ratings, etc.

After importing the data, you can set a refresh schedule so that the data are updated automatically at regular intervals. In order to receive latest offers, you can automate importing real-time product search data to Google Sheets. To learn how to set a refresh schedule, follow this link.

Amigo extension can connect Google Sheets to multiple sources and allows you to import data automatically. It’s a convenient and versatile tool to import and export data to Google Sheets. It can save you a lot of time and effort. To learn more visit our blog.

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. 

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