The prices of products listed on online shopping site like Amazon or Flipkart may vary every single day and here’s a simple Google Docs based solution to help you keep track of these price fluctuations via email. This helps because if Amazon is offering some big discount on a product that you were planning to buy, you would never miss that deal again.
Track Prices with Google Docs
All you have to do is add the URLs of products that you wish to track inside a Google Spreadsheet. The tool can track prices of all products listed on various Amazon websites (all Amazon.* country domains are supported) and Flipkart.com (if you are shopping in India).
Here’s how you can setup the price tracker inside your Google Docs:
- Open the Google Sheet and enter one or more URLs of product pages from Amazon or Flipkart in column B. The sheet has some dummy data to get you started.
- From the Price Tracker menu, choose the Initialize menu and say “Accept” when asked for authorization. The script is open-source and no one else will have access to your data.
- From the Price Tracker menu, choose Start Tracking and your price tracker is now active. You may close the Google Sheet.
You’ll get an email within a minute or two listing the current prices of the products that you have added in the Google Sheet. The sheet will then send you a daily digest (see sample email) of the product prices with visual hints on how the prices have changed since the last update.
Also, you can add new URLs or delete existing ones from the Google sheet and the background script will automatically pick the changes. And if you ever wish to stop receiving those email alerts, just choose the Stop Tracking option from the Price Tracker menu.
Internally, the Google Script uses Amazon’s Product Advertising API to fetch the latest prices of Amazon products while in the case of Flipkart, the prices are extracted from the Meta and Open Graph tags of their pages. The tool cannot track prices of Kindle ebooks since Amazon’s API doesn’t offer pricing information for Kindle titles via their API.