Auto send emails from a Google Spreadsheet

Send emails with a common message as well as individualised message to multiple addresses.

Useful for teachers who want send out similar email messages to an entire class.

Or if you want to send a personalised email to everyone in a group, rather than a group email - people tend to respond to personal emails better than to group emails.

Create a new empty Spreadsheet
Add a few rows of data. Every row should contain an email address in column A and the email message to be sent to that person in column B. For testing purposes, you may want to use your own email address in column A
Open the Script Editor by clicking on the 'Tools' menu, then select 'Script editor...'.
Save the Script
Select the function sendEmails in the function combo box and click "Run"
Check out your email Inbox. Messages are usually immediately delivered, but sometimes it takes a few seconds.

automatically email google spreadsheet
google sheets send email based on cell value
google sheets email trigger
google spreadsheet email notification script
email google spreadsheet as attachment
google spreadsheet send email when changed
failed to send email: no recipient (line 14, file "code")
google sheets send email based on date