Sending emails from Sheets in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the main Google Sheets feature used to send emails automatically?

Google Sheets uses Google Apps Script to send emails automatically based on sheet data.

beginner

Which function in Google Apps Script sends an email?

The function MailApp.sendEmail() is used to send emails from Google Sheets scripts.

intermediate

How do you trigger an email to send when a sheet is edited?

You create an onEdit(e) trigger function in Apps Script that runs when the sheet changes, then use MailApp.sendEmail() inside it.

beginner

What information do you need to provide to MailApp.sendEmail() to send an email?

You need to provide the recipient's email address, subject line, and message body at minimum.

beginner

Why is it important to test your email script with your own email first?

Testing ensures your script sends emails correctly and avoids spamming others by mistake.

Which Google Sheets feature allows you to write code to send emails?

A Conditional Formatting

B Data Validation

C Google Apps Script

D Pivot Tables

Google Apps Script lets you write code to automate tasks like sending emails.

What is the correct method to send an email in Google Apps Script?

A MailApp.sendEmail()

B Email.send()

C sendMail()

D Mail.sendEmail()

The correct method is MailApp.sendEmail() to send emails from scripts.

Which trigger runs a function when you edit a Google Sheet?

A onEdit(e)

B onOpen()

C onChange()

D onSubmit()

The onEdit(e) trigger runs when a user edits the sheet.

What minimum information is needed to send an email with MailApp.sendEmail()?

A Message body only

B Recipient email only

C Subject and message body only

D Recipient email, subject, message body

You must provide recipient email, subject, and message body to send an email.

Why should you test your email script with your own email first?

A To save email credits

B To avoid sending wrong emails to others

C To speed up the script

D To change the email format

Testing prevents accidental emails to others and ensures the script works.

Explain how you can send an email automatically when a Google Sheet is edited.

Think about what happens when you change the sheet and how the script reacts.

List the key parts needed to send an email from a Google Sheets script.

What does an email always need to have?