Amazon 2020 Steps to Use Google Sheets As an Amazon Price Tracker
Costs of various objects may preserve altering on a regular basis on Amazon. With the assistance of 1 Google Spreadsheet, it is possible for you to to maintain a monitor of those value modifications along with your electronic mail. All one must do is add the hyperlinks of the involved merchandise inside the Google Spreadsheet and set it up and also you’re accomplished. Allow us to take a look at the steps below-
Producing Entry Keys of Amazon– Check in to your Amazon Associates account. After that, select the Product Promoting API from the Instruments drop down menu. From there, beneath the Add Credentials part, select the Handle Your Credentials possibility. From there, you may see that Amazon has generated a secret key and an entry ID key.
Copying Your Worth Tracker Spreadsheet on Your Google Account– Keep in mind to maintain the structure of the spreadsheet similar as a result of for those who change it now, it’d break the value tracker. After the tracker is uploaded, put up the Amazon hyperlink of your product within the Column labelled as A. The Amazon hyperlink incorporates the 10 digit ASIN code that Google makes use of to watch the modifications in value of that individual product. One may also see that the Google spreadsheet which can be used to trace the costs may also checklist different helpful particulars associated to the product akin to identify of the service provider, particulars on transport costs, general product rank, and so forth.
Setting Worth Limits– That is an elective step. Right here, within the value tracker, it’s also possible to arrange value limits, which means that every time a sure low cost on the product is obtainable, or every time the product reaches a sure value, you’re going to get a notification by way of your electronic mail. This manner, you’re going to get a faster hand on the product, earlier than anybody else. To do that step, merely go to column B and particular the proportion or value you need to specify.
Configuration of Amazon Worth Tracker- Contained in the Google spreadsheets, you have to to go to the menu of the Amazon Worth Tracker, and from there you have to to decide on configure. It would come to this that you’ll want to authorize the Amazon Worth tracker script after in order to attach it with the Amazon API and for pending electronic mail alerts. After clicking on configure, merely enter your Amazon Entry ID key, your secret key and your Amazon electronic mail ID, after which you’ll begin receiving electronic mail notifications on a regular basis in regards to the merchandise which you have put within the value tracker. To conclude, the Amazon value tracker is a really useful gizmo as it could additionally monitor the value modifications of Kindle eBooks and assist preserve monitor of costs of merchandise on nation particular Amazon web sites akin to Amazon.in, Amazon.es, Amazon.ca, and so forth. This makes it a particularly helpful product certainly.
Use this hyperlink to repeat your created spreadsheet in your Google Account.