Automated email when new line is added to Google Sheets
The most recent row of data will be used in an HTML email sent with Google Apps Script.
This tutorial will show you one example of how to capture data in Google Sheets and then automatically send an email once the data is entered. This system is built on three Google Tools:
1. Google Colab is used to write a Python script that creates a message, which is sent to Google Sheets
2. Google Sheets tracks each successful run of the script
3. Google Apps Script collects the data pushed to Sheets and then sends an email with the most recent value after it is appended to the sheet
This tutorial will not teach you how to write the Python code but I am considering a series of Python lessons. Please let me know if you'd be interested.