How to use Google Sheets with ShoppingScraper?
A few simple steps to follow if you want to use ShoppingScraper in Google Sheets:
-
Create a new Google Spreadsheet
-
Click on Tools -> Script Editor.
-
Click Create script for Spreadsheet.
-
Delete the placeholder content and paste the code from this script.
-
Rename the script to ImportJSON.gs and click the save button.
-
Back in the spreadsheet, in a cell, you can type “=ImportJSON()” and begin filling out it’s parameters.
Paste this code in the cell to show all columns:
=ImportJSON("https://api.shoppingscraper.com/product/googleshopping/nl/{EAN_GTIN}?api_key={API_KEY}&images={TRUE_FALSE}&specs={TRUE_FALSE}&metadata={producitd:5555}","","allHeaders,rawHeaders,noTruncate,noInherit")
Preview of the JSON import:
Paste this code in the cell to inherit the data from the upper row:
=ImportJSON("https://api.shoppingscraper.com/product/googleshopping/nl/{EAN_GTIN}?api_key={API_KEY}&images={TRUE_FALSE}&specs={TRUE_FALSE}&metadata={producitd:5555}","","allHeaders,rawHeaders,noTruncate")
