In this project google sheets updation and emails were automated to monitor the preferred stock prices.

1. Stock data was extracted from moneycontrol website using the urls saved in a google sheet.
2. Stock prices were updated in a new worksheet of google sheet to monitor the change as per convenience.
3. Bar chart of all data was prepared to visualise the change.
4. A comparison of present stock price and average of previous seven day data was made to observe the rise or fall in prices and with a fall in prices a mail was generated to inform about the fall.