Steps to Use Google Sheets As an Amazon Price Tracker…Prices of different items might keep changing everyday on Amazon. With the help of one Google Spreadsheet, you will be able to keep a track of these price changes with your email. All one needs to do is add the links of the concerned products within the Google Spreadsheet and set it up and you’re done. Let us look at the steps below-
Generating Access Keys of Amazon– Sign in to your Amazon Associates account. After that, choose the Product Advertising API from the Tools drop down menu. From there, under the Add Credentials section, choose the Manage Your Credentials option. From there, you’ll see that Amazon has generated a secret key and an access ID key.
Copying Your Price Tracker Spreadsheet on Your Google Account– Remember to keep the layout of the spreadsheet same because if you change it now, it might break the price tracker. After the tracker is uploaded, put up the Amazon link of your product in the Column labelled as A. The Amazon link contains the 10 digit ASIN code that Google uses to monitor the changes in price of that particular product. One can also see that the Google spreadsheet which will be used to track the prices will also list other useful details related to the product such as name of the merchant, details on shipping prices, overall product rank, etc.
Setting Price Limits– This is an optional step. Here, in the price tracker, you can also set up price limits, meaning that whenever a certain discount on the product is offered, or whenever the product reaches a certain price, you will get a notification via your email. This way, you will get a quicker hand on the product, before anyone else. To do this step, simply go to column B and specific the percentage or price you want to specify.
Configuration of Amazon Price Tracker- Inside the Google spreadsheets, you will need to go to the menu of the Amazon Price Tracker, and from there you will need to choose configure. It might come to this that you will need to authorize the Amazon Price tracker script after so as to connect it with the Amazon API and for pending email alerts. After clicking on configure, simply enter your Amazon Access ID key, your secret key and your Amazon email ID, after which you will start receiving email notifications everyday about the products which you’ve put in the price tracker. To conclude, the Amazon price tracker is a very useful tool as it can also track the price changes of Kindle eBooks and help keep track of prices of products on country specific Amazon websites such as Amazon.in, Amazon.es, Amazon.ca, etc. This makes it an extremely useful product indeed.
Use this link to copy your created spreadsheet on your Google Account.