Checkout how to build Email Marketing Tool on google sheets 👉 https://youtu.be/gy7ypKE6rbg
Title: Create Email stock alert in 5 Minutes with Google Apps Script
Tutorial Playlists:
Google apps script tutorial for beginners- https://bit.ly/google-apps-script-tutorial-for-beginners
Automate internet explorer with VBA- https://goo.gl/Xmy8Af
Autoit tutorials for beginners- https://goo.gl/JHB1E2
Blog: www.amarindaz.com
FB page: http://www.facebook.com/amarindaz
Instagram: https://goo.gl/ma9WUh
What is google apps script?
Google Apps Script is a JavaScript cloud scripting language that provides easy ways to automate tasks across Google products and third party services and build web applications.
========================================================
Recommended books:
Learning google apps script- http://amzn.to/2g00LoM
Google apps script for beginners- http://amzn.to/2gVAKvs
========================================================
In this video, you are going to learn how to create simple email stock alert with google apps script.
You have to use the google finance formula to track the current price of the stock. Have to change the spreadsheet Setting recalculation to On change every minute. So, that google finance formula gets refreshed every minute.
Then, you have to write a simple google apps script using SpreadsheetApp and MailApp class to get the stock price and send it to the given email ID.
Finally, you have to set up the trigger(either manual trigger or programmatic trigger) so that script will run for every hour and send email on behalf of you.
if you want to create stock price tracker for your portfolio please contact me www.amarindaz.com/contact/
For more details, please watch the video
Don't forget to subscribe! https://goo.gl/J2453w
Thanks,
Rajan
💼 To Hire Me 👉 https://fwd.cx/WLGgpTiZW5HK
Checkout my app 👉 https://www.myfreshtools.com
