Steps to use Google Sheets as an Amazon price tracker
The prices of different items can change every day on Amazon. With the help of a Google spreadsheet, you will be able to track these price changes with your email. All you have to do is add the links of the products in question inside the Google spreadsheet, configure it and you’re done. Let’s see the steps below:
Amazon Access Key Generation– Sign in to your Amazon Associates account. After that, choose the Product Advertising API from the Tools dropdown menu. From there, in the Add credentials section, choose the Manage your credentials option. From there, you will see that Amazon has generated a Secret Key and an Access ID Key.
Copy your price tracking spreadsheet to your Google account– Remember to keep the spreadsheet layout the same because if you change it now, you might break the price tracker. After loading the tracker, place your product’s Amazon link in the column labeled A. The Amazon link contains the 10-digit ASIN code that Google uses to monitor price changes for that particular product. You can also see that the Google spreadsheet that will be used to track prices will also list other useful details related to the product, such as merchant name, shipping price details, overall product rating, etc.
Set price limits– This is an optional step. Here in the price tracker, you can also set price limits, which means that every time a certain discount is offered on the product, or every time the product reaches a certain price, you will receive a notification through your email. electronic. This way you will get a product faster, before anyone else. To do this step, simply go to column B and specify the percentage or price you want to specify.
Amazon Price Tracker Setup- Within Google Spreadsheets, you’ll need to go to the Amazon Price Tracker menu, and from there you’ll need to choose configure. You may need to authorize the Amazon price tracking script afterwards to connect it to the Amazon API and for pending email alerts. After clicking configure, simply enter your Amazon Access ID Key, Secret Key and Amazon Email ID, after which you will start receiving email notifications every day about the products you have placed in the price tracker. To conclude, Amazon Price Tracker is a very useful tool as it can also track price changes for Kindle e-books and help keep track of product prices on country-specific Amazon websites. , such as Amazon.in, Amazon.es, Amazon.ca, etc. This makes it an extremely useful product.
Use this link to copy your created spreadsheet to your Google account.