In this article, we’ll learn how to import Wayfair data to Google Sheets using Wayfair API. We can scrape product details such as titles, images, prices, ratings, and reviews, find deals, and a bunch of other things, and import these data from Wayfair into Google Sheets. We can then easily compare products, keep track of market pricing trends, and monitor competitors by automating the data retrieval process.
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.
Below is a snippet of data imported from Wayfair into Google Sheets.
Read on to learn how to import Wayfair data to Google Sheets. But first, let us get familiar with the steps involved.
- Install the Amigo extension in Google Sheets
- Get the Wayfair API endpoint URL
- Pull the data to Google Sheets
How to import Wayfair data to Google Sheets
Follow the steps below to learn how to the Wayfair API to scrape data from Wayfair and import them to Google Sheets.
Install the Amigo extension in Google Sheets
Install the Amigo Data Google Sheets add-on from the Google Workspace Marketplace to import Wayfair data to Google Sheets.
Alternatively, you can get it from Google Sheets.
- Open Google Sheets
- Go to Extensions→Add-ons→Get add-ons
- Search for Amigo and install
Get the Wayfair API endpoint URL
We’ll use a third-party Wayfair API on RapidAPI to scrape Wayfair data.
Sign up or log in to RapidAPI.
Go to the Wayfair API documentation in RapidAPI. Or simply search for Wayfair API in the RapidAPI Hub and click the top result.
Click on the Subscribe to Test button and subscribe to a plan of your choice, after which you’ll be able to use the Wayfair API to scrape and import Wayfair data to Google Sheets.
Click Endpoints to go back to the Wayfair API documentation. On the left is the list of the type of data that can be retrieved with the Wayfair API.
Click on any one of the headings to expand the endpoints list. For example, Product to fetch product details such as price and deals. And select the product/search endpoint to search for a specific product and scrape the product details.
Under Required Parameters, enter the keyword for the products to search for on Wayfair.
The Optional Parameters are not required but can be used to filter the results and sort them. We’ll change the itemsperpage parameter to 10 and leave the rest as they are.
To view the result, click the Test Endpoint button. The result will be displayed in JSON format under the Results section on the right, if the parameters are valid.
The API endpoint URL along with the headers–which will be required to import Wayfair 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.
Pull the data to Google Sheets
Open Google Sheets and launch Amigo to import the data from Wayfair to Google Sheets. Click Extensions→Amigo: Data Exports and Reports→Connect.
We’ll be presented with a list of sources to connect and import data. Select Custom API.
Enter the Wayfair API endpoint URL (without the apostrophes) in the API URL field.
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.
Name: X-RapidAPI-Host, Value: wayfair.p.rapidapi.com
Name: X-RapidAPI-Key, Value: YOUR_API_KEY
Click the PREVIEW button to retrieve the data from Wayfair and preview them. Flatten and expand the nested datasets and delete the columns that are not required. Then click IMPORT.
Note: The endpoint will return several thousands of distinct data–more than the limit Google Sheets can handle. So, it is recommended that some datasets are deleted and imported separately.
The data will be imported into Google Sheets in a moment. Below is a snippet of the data imported into Google Sheets from Wayfair.
We can likewise scrape data for a specific product, retrieve reviews, and a bunch of other information.
If you want to constantly watch the products and 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 alert you via email. 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 Target Data To Google Sheets
How to Connect Shopify to Google Sheets