Monday, 15 May 2017

A Price Tracker Made for Online Shopping in India

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

Related Posts Plugin for WordPress, Blogger...

Labels

404 AdBlock Add-on Airtel GPRS Trick Airtel SMS Trick Alexa Amazon Amazon Kindle Amazon Prime Android Android 8 Android Oreo antivirus Apple Apple Mac ASCII Audacity Audio Authotkey Backup Balance Transfer in Vodafone Battery Bing Blogger Blogging Bookmarklet Browser Camera Chromebook clock Cloud colors command lines Computer Computer Tricks configuration Contact Creative Commons Credit Card CSS devolop DIY Doodle DOS Download Dropbox E-Mail eBook Email Email Attachment Embed Encryption English Error Evernote Eyes Facebook Facebook Tricks Feedburner Flipkart Font Foursquare Free Internet Free sms trick in Vodafone G Mail Gadget Game Getty Images GIF Gists Github Google Google AdSense Google Analytics Google Apps Google Chrome Google Contacts Google Currents Google DNS Google Docs Google Drive Google Earth Google Font Google Forms Google Images Google Map Google Photos Google Play Store Google Plus Google Print Google Reader Google Script Google Sheets Google Spreadsheet Google Translate GPRS Setting GPS Hacking Health App HelloFax Hindi Hoodie HTML Icons idea Image Editing Images IMEI Indian Railways Infographics Instagram Internet Internet Explorer Internet Tricks iOS iPad iPhone IRCTC iTunes iTV JavaScript JioCinema JioTV Junglee Kindle Language Translation Laptop Laptop. TV Life Time FREE GPRS Life-Style Link Linkedln Linux logo Make Money Online Microdoft Powerpoint Microdoft Word Microsoft Office Microsoft Outlook Mobile Mosaic Music Name Networking nexus Notepad OCR Online Shopping Open DNS OS Outlook Password PDF Petya Phillips Hue Lights Photogtraphy Pixel Play Station Podcasts Pokemon Pokemon Go Polls Print Productivity Proxy Server Pushbullet QR Code Ransomware Reddit Reliance Hack GPRS Reliance Jio RGB Ringtone Router RSS Safe Mode Samsung Galaxy S Scrabble Screen Capture Screen Sharing Screencast Secrets Security Send free sms from PC SEO Sierra Skype Slideshare SMBv1 SMS Snapchat Snapdeal Social Media Solution Sound Device Speech Recognition Sql Steam Sync Synology NAS Tata Docomo GPRS trick Teleprompter Torrent Trick Tricks TV Twitter UltraISO Unicode Unknown Extension Unlimited 2GB Unlimited 3GB Unlimited GPRS USB USB Security Key Video Editing virtual desktop Virus attack VLC Vodafone 110% working trick for GPRS Vodafone 3g Vodafone GPRS VPN wallpapers WannaCry Web Design Web Domain Website Wget Whatsapp WiFi Wikipedia Windows Windows 10 Windows 10 S Windows KN Windows Tricks windows updates Winows N Wolfarm Alpha WordPress XBox YouTube Zip
Twitter Delicious Facebook Digg Stumbleupon Favorites More