In this video we will teach you how to send email from Google sheets directly by using the Apps script. We will be using the MailApp library in our code. This video also discusses a use-case where automatic email is sent from Google sheets to each row in the sheet, keeping in mind that we do not have to send a very large number of emails.
A Great feature of Google Sheets which every Professional or Student should know to be more effective.