Notification rules in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What are Notification Rules in Google Sheets?

Notification Rules are settings that let you get emails when changes happen in your spreadsheet, like edits or form submissions.

beginner

How do you access Notification Rules in Google Sheets?

Click on Tools in the menu, then select Notification rules to open the settings window.

beginner

What types of changes can trigger Notification Rules?

You can get notified when:<br>- Any changes are made<br>- A user submits a form linked to the sheet

beginner

What options do you have for how often to receive notifications?

You can choose to get emails:<br>- Right away (immediately)<br>- Once a day (daily digest)

beginner

Can Notification Rules be customized for specific cells or ranges?

No, Notification Rules apply to the whole spreadsheet or form submissions, not to specific cells or ranges.

Where do you find Notification Rules in Google Sheets?

A Under Tools menu

B Under File menu

C Under Edit menu

D Under View menu

Notification Rules are found under the Tools menu in Google Sheets.

Which event can trigger a Notification Rule?

A When a cell is formatted

B When a sheet is printed

C When a chart is created

D When a form linked to the sheet is submitted

Notification Rules can trigger when a form linked to the sheet is submitted.

How often can you receive notification emails?

A Only once a week

B Every hour

C Immediately or daily

D Only monthly

You can choose to get notifications immediately or as a daily summary.

Can Notification Rules be set for changes in specific cells only?

A No, only for the whole sheet

B Yes, for any cell

C Yes, but only for columns

D Yes, but only for rows

Notification Rules apply to the whole spreadsheet or form submissions, not specific cells.

What is the main purpose of Notification Rules?

A To format cells automatically

B To send emails when changes happen

C To protect sheets from editing

D To create charts automatically

Notification Rules send emails to alert you when changes happen in your spreadsheet.

Explain how to set up a Notification Rule in Google Sheets and what options you can choose.

Think about the menu path and the two main choices for triggers and frequency.

Describe the limitations of Notification Rules in Google Sheets.

Consider what Notification Rules cannot do compared to other alert methods.