How to send emails from Google Spreadsheet

First, we need to go to Google Drive to create a new spreadsheet.
Give a name to the spreadsheet
Go to Tools >> Script Editor
Copy and Paste below code
https://github.com/gsuitedevs/apps-script-samples/blob/master/gmail/sendingEmails/sendingEmails.gs



Give a name to the script and Save.
Go to Spreadsheet, enter email address in column A and the email message to be sent to that person in column B

Go to script editor and select the sendEmails function and Click Run
Also, you need to authorize to use Gmail to send messages on your behalf.
Click Authorize Button
After Authorization Click Run it again
Its Done…