The costs of merchandise listed on varied Amazon purchasing web sites could range on daily basis and a easy Google Spreadsheet may help you monitor these value fluctuations by way of e-mail. Simply add the Amazon objects in a spreadsheet and also you’ll robotically get e-mail alerts when their costs change on Amazon. You’ll thus by no means miss the deal once more.
Observe Amazon Costs with Google Sheets
The Amazon Worth Tracker is simple to configure. All you need to do is add the hyperlinks (URLs) of Amazon product pages inside a Google Spreadsheet. You may add monitor merchandise throughout all Amazon.* web sites. Listed here are the steps concerned:
Step 1: Generate Amazon Entry Keys
Open the Amazon Associates web site and sign-in along with your Amazon account. Subsequent, click on the Instruments menu, select Product Promoting API from the dropdown (hyperlink) and select Handle Your Credentials below the Add Credentials part. Amazon will create an Entry Key ID and a Secret Key that you just’ll want within the subsequent step.
Step 2: Copy the Google Spreadsheet
Click on right here to repeat the Worth Tracker Google Sheet in your Google Account. DO NOT change the structure of the Google Sheet as it might break the tracker.
Now all you need to do is enter Amazon product URLs in column A of the Google Sheet, one per line. For example, right here’s the Amazon URL for iPad
The URL accommodates the 10 digit ASIN code which is utilized by the Google Sheet to establish the precise Amazon product you wish to monitor for value fluctuations.
Along with costs, the Google Sheet lists a number of different helpful attributes of Amazon Merchandise together with service provider’s title, gross sales rank, total financial savings, Prime eligibility and whether or not the product qualifies at no cost transport.
Step three: Set Worth Thresholds (non-obligatory)
With the Worth Tracker, you may as well set value thresholds for particular merchandise and get automated e-mail alerts when the goal value is reached. For example, you may select to obtain alerts when the iPad value drops by 20% of the preliminary worth. Or you may set a goal value (alert when iPad drops to $399) and get automated alerts when the value drops on Amazon.
To specify a threshold for any product, go to column B of the product row and enter the quantity or share values as proven within the screenshot above.
Step four: Configure Worth Tracker inside Google Sheet
Contained in the Google Sheets, go to the Amazon Worth Tracker menu (close to the Assist menu) and select Configure. You’ll have to authorize the Pricer Tracker script as soon as to connect with Amazon API and ship e-mail alerts.
Subsequent enter your entry keys, your e-mail handle and the time if you want to obtain the e-mail alerts. Click on Save to initialize the Amazon Worth Tracker.
That’s it. You’ll obtain a day by day e-mail digest with the value fluctuations as proven under.
Monitor Amazon Merchandise for Worth Drops
Amazon Worth Tracker can monitor costs of all merchandise (together with Kindle ebooks) listed on Amazon.com and the country-specific web sites together with amazon.fr, amazon.de, amazon.es, amazon.ca, amazon.it, amazon.in, amazon.co.jp and amazon.co.uk.
Additionally, you may add extra Amazon URLs, or delete present merchandise, from the Google sheet and the script will robotically decide the adjustments within the subsequent run. And in case you ever want to cease receiving these e-mail alerts, simply select the Cease Monitoring choice from the Worth Tracker menu in the identical Google sheet.
The tracker is written in Google Scripts and makes use of Amazon’s Product Promoting API to fetch the newest costs at fastened intervals. The Worth Tracker is totally free however in case you selected to improve to premium, you get technical help and get to make use of your personal Amazon Affiliate tags.