How to Get Email Notifications from Google Sheets

Someone updates a critical spreadsheet and you don’t find out until three days later. Here’s how to get instant email alerts whenever your Google Sheet is edited.

Why you need spreadsheet notifications

Google Sheets is collaborative by design. Multiple people can edit the same spreadsheet at the same time. That’s powerful, but it also means changes happen without you knowing. A vendor updates a price. A team member marks a task complete. An intern accidentally deletes a row.

Without notifications, you’re relying on manually checking the spreadsheet to catch changes. Email notifications turn your spreadsheet into an active tool that tells you when something important happens.

Method 1: Built-in notification rules

Google Sheets has a basic notification feature most people don’t know about:

1. Open your Google Sheet
2. Go to Tools → Notification settings
3. Click Edit notification rules
4. Choose: “Any changes are made” or “A user submits a form”
5. Choose: “Email — right away” or “Email — daily digest”
6. Save

Method 2: Custom Apps Script

For more control, write a custom Google Apps Script. This lets you monitor specific cells, columns, or value changes:

1. Open your Google Sheet → Extensions → Apps Script
2. Write a function that checks the edit location and sends an email
3. Set up an installable trigger (Triggers → Add Trigger → On edit)

This works but has drawbacks. You need JavaScript knowledge. The simple onEdit() trigger can’t send emails — you need an installable trigger. And if the script breaks, you won’t know until you miss a critical notification.

Method 3: Add-on (no code)

The easiest approach is a Google Sheets add-on that handles notification logic for you. Notifications for Google Sheets lets you set up rules like “email me when column B changes to Done” without writing any code.

1. Install from the Google Workspace Marketplace
2. Open the sidebar (Extensions → Notifications for Google Sheets)
3. Create a rule: choose which column to watch, what condition to use, and who to email
4. Save — notifications start immediately

Which method should you use?

Common use cases

Task tracker

Email the project manager when a task status changes to “Blocked” or “Complete.”

Inventory management

Alert purchasing when stock drops below a threshold.

Form responses

Route new form submissions to the right team member based on the response.

Approval workflows

When a manager changes a column to “Approved,” email the requestor automatically.

Data entry monitoring

Get notified whenever a new row is added for real-time quality control.

FAQ

Will I get an email for every single edit?

With built-in rules set to “right away,” yes. With an add-on, you set conditions so you only get notified for changes that matter.

Can I notify someone other than myself?

Built-in only notifies you. Apps Script and add-ons can send to any email address.

Do notifications work on mobile?

Yes — the emails arrive like any other email, so they show up as push notifications if you have Gmail notifications enabled.