Min menu


Steps to Use Google Sheets As an Amazon Price Tracker

amazon, google sheets, amazon fba, amazon seller, how to track your amazon sales, amazon sales tracker, how to sell on amazon for beginners, price tracker, what to sell on amazon, selling on amazon.

Steps to Use Google Sheets As an Amazon Price Tracker
Steps to Use Google Sheets As an Amazon Price Tracker

The prices of different items might keep changing every day 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 the 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 labeled as A. 

The Amazon link contains the 10 digit ASIN code that Google uses to monitor the changes in the 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 the 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 specify 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 to 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 every day 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.

how to sell on amazon, best amazon price tracker, how to use macros in google sheets, keep an amazon price tracker, keep a - amazon price tracker, how to start selling on amazon, amazon price tracker.

Use this link to copy your created spreadsheet on your Google Account.

For faster internet to track prices on amazon using this link.

احمد ابو المجد
احمد ابو المجد
Ahmed Abu Al-Majd - Egyptian Arab blogger and YouTuber - supervisor and owner of the Abu Al-Majd YouTube channel - I share my experience in the technical field in a simple way that suits everyone. facebook ــــ twitter ــــ instagram ــــ pinterest ــــ youtube ــــ linkedin ــــ abouelmagd احمد ابو المجد 2