The prices of products at various shopping websites fluctuate frequently and wouldn’t it be useful if there were a mechanism that will alert you when the prices of specific products change. Well, Google Sheets can help here.
USING THE PRICE TRACKER – STEP BY STEP
You can now use this Google Sheets based Price Tracker to monitor and compare prices of products on Flipkart, Snapdeal, Infibeam and Amazon India.
The Price Tracker will take no more than a minute to setup.
1. Click here to copy the Price Tracker Google Sheet in your Google Drive.
2. Put the links (URLs) of one or more products from Snapdeal, Flipkart, Amazon.in or Infibeam in column A. You’ll have to put the links of individual product pages and not categories or search pages. You can add or remove items from this list later on as well while the Price Tracker is active.
3. Go to the Cell A11 and put your own email address. This is the address where the price alerts will arrive.
4. Open the India Price Tracker menu in the Google sheet (see screenshot) and choose Authorize. Next go to the same menu and choose Start Tracker to begin tracking.
That’s it. You’ll get daily email alerts when the prices of any of these products change. Internally, this tool is screen scraping prices from Flipkart and Snapdeal while in the case of Amazon, it gets the prices through the Amazon API.
The tracker runs once every 24 hours but you can always change the frequency manually. Go to the Tools menu in the sheet and choose Script Editor. Go to Resources -> Current Triggers and change the frequency of the trackPrices trigger from daily to hourly.
0 comments:
Post a Comment