Amazon price alert Tracker in Google Sheets Detailed Demo скачать в хорошем качестве

Amazon price alert Tracker in Google Sheets Detailed Demo

Update: Try Amazon Scraper 👉 https://myfreshtools.com/misc/amazon-... to scrape advanced product details such as title, price, ratings, reviews, manufacturer, product availability, badge, strike price, etc., Free Version: https://gum.co/QcHLA Premium Version: https://gum.co/dAQdA Title: Amazon price alert Tracker in Google Sheets -Detailed Demo video Blog Post: http://www.amarindaz.com/amazon-price... Free Version: https://gum.co/QcHLA Premium Version: https://gum.co/dAQdA Description: The prices of products listed on the Amazon shopping website vary every day and a simple Google Spreadsheet can help you keep the monitor and track these price fluctuations via email. Just add the items that you wish to buy from Amazon in a spreadsheet and it will send you an email alert when the product’s price drops on Amazon. You’ll thus never miss the deal again. ***How To Get Amazon Price Alert In Google Sheets? When you click on the link (either Freemium or Premium), you have popped up asking email ID to send the detailed document and Payment (only for premium) to complete the purchase. Once you are done, you can check your email for attachment with details to copy Amazon price tracker on your drive. Make sure that you have already logged in with your Gmail account so that you can make a copy of this Sheet to Google drive. Isn’t simple? Now go to Google drive and open the spreadsheet. ***How To Set Up Amazon Price Alert Tracker? There are a few things you need to do on the Spreadsheet before you put Amazon price alert to work. It’s very simple and just one-time setup. Here are the steps Go to the “Settings” tab. That’ll be the first sheet on the tracker. Enter your Name on B1 and enter email ID that you want to get price alert. Amazon price alert settings Now go to the ASIN tab. Enter the ASIN of the product that you want to monitor. ***What is ASIN? ASIN stands for Amazon Standard Identification Number. It’s a 10-character alphanumeric unique identifier that’s assigned by Amazon.com and its partners. It’s used for product-identification within Amazon.com organization. ***Where can I find the ASIN for my Products? It’s simple. Just go to this product and scroll down the Product information page. Otherwise, you can use the search option (Ctr l+ F) and type “ASIN” on your browser. You can find ASIN as shown below. Just copy and put it on Column A of ASIN tab. Amazon price alert finding ASIN Go to carts or wish list that contains the products you want to buy in future. You can copy those product ASINs and put it in the first column of ASIN tab. Finally, your sheet will look like below Amazon price tracker list You can find “Amazon price alert tracker” menu button. Click that and it’ll display drop down as shown below. Click the “First Run” option to initialize the script. Alternatively, you can also click on the button “Click here for the first-time run” in the ASIN tab. Amazon price tracker first Run Now, you need to give authorization by clicking continue button Price tracker authorize Select the Gmail account for authorization Select the Gmail account Sometimes, you’ll get pop up like this for verification as we are connecting to Amazon API (Google consider this as the third-party app). Click the advanced link and select “Go to APT” link. Verify the app Now you want to give access to the Script to connect with Amazon API, your Gmail for sending email on behalf of you to the Email ID entered in the settings tab and automatically run scripts every day on the server side. Click “Allow” to proceed further. Allow access to Amazon tracker That’s it, you are done! Your script will run for the first time and show you the results on the ASIN and for confirmation, you’ll get an email as well. From now onwards, everything is automated! It’ll track the price every day and send you an update. You can add/remove products when needed. ********* Tutorial Playlists ********* Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tut... Automate internet explorer with VBA- https://goo.gl/Xmy8Af Autoit tutorials for beginners- https://goo.gl/JHB1E2 Selenium Webdriver tutorials for beginners -https://goo.gl/QqxTrF ***** Contact me ******* Blog: http://www.amarindaz.com/contact/ FB page:   / amarindaz   ****** Books written by me ******* Autoit tutorials for beginners: http://amzn.to/2GjaDbD Excel VBA for beginners: http://amzn.to/2nhI067 ****** Productivity tool ******** My Favorite YouTube Tools ? https://goo.gl/MX9Z4p and ?https://goo.gl/UW1uRX ****** Gear Used To Shoot This Video ***** _Audio & Microphone http://amzn.to/2GibdGu *******Learning partner******* Video courses ?https://click.linksynergy.com/fs-bin/... 💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK Check out Kite 👉 http://bit.ly/get-kite