Automate Email Sending from Google Sheets with 1 click - HTML & JavaScript!
Send automated email from Google Spreadsheets with 1 click!
This ended up being a much longer video than I anticipated as I tried to cover the steps that you would need to take to make this automation happen ^_^
To make it easier to follow, I am mentioning the timestamps of the topics covered in the video:
0:00 Intro & Use Case
2:18 Prior Knowledge
3:10 Getting Data From Spreadsheet
22:30 Creating HTML Template
39:00 Setting Email Time/Click
43:30 Conclusion
As with all things, once I was done with the video, I realised there were scope to refactor the code to make it a little bit more simpler and have done that update in the public code I am sharing below in the comments!
Would really love any constructive feedback on how to improve this type of content and whether there is actually any need to make such format of videos :D
GitHub Repo containing the used code: https://github.com/Ishmam156/AutomateEmail...
Link to decode emailed HTML: https://www.webatic.com/quoted-printable-c...
Link to prettify HTML: https://www.browserling.com/tools/html-pre...
Based on this tutorial: https://spreadsheet.dev/send-html-email-fr...
A thank you to Mukit whose formatting and nicely execute formula has been used showing the daily and weekly average in the dummy spreadsheet file!