How to use Google Sheets with ShoppingScraper?

A few simple steps to follow if you want to use ShoppingScraper in Google Sheets:

  1. Create a new Google Spreadsheet
  2. Click on Tools -> Script Editor.
  3. Click Create script for Spreadsheet.
  4. Delete the placeholder content and paste the code from  this script.
  5. Rename the script to and click the save button.
  6. 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:


Preview of the JSON import:

Paste this code in the cell to inherit the data from the upper row:


Free trial

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Let Scotty help you. Send us a message. Send us a message.