Google Sheets Notification When Cell Changes

Need to know the instant a specific cell is edited? Here’s how to set up cell-level change notifications — from a single cell to an entire column.

When you need cell-level notifications

Google Sheets’ built-in notifications are all-or-nothing. There’s no way to say “only email me when cell B2 changes.” But that’s exactly what many people need:

• A manager tracking a quarterly revenue number
• A team lead watching project status changes
• A warehouse operator monitoring stock counts
• A teacher waiting for grade submissions

Monitor a single cell

With Apps Script

Create a function that checks e.range.getA1Notation() against your target cell (e.g., “B2”) and sends an email if it matches. Set up an installable trigger (not simple onEdit).

With an add-on

In Notifications for Google Sheets, create a rule targeting column B. No code needed.

Monitor an entire column

The most common use case. “Email me when anything in the Status column changes.”

In Apps Script, check e.range.getColumn() against the column number you want. In an add-on, select the column in the rule builder.

Monitor a range of cells

Watch a block like C2:F50 (the data area, excluding headers). In Apps Script, add range checking for column and row bounds. In an add-on, select which columns to watch.

Notify only for specific values

The most useful notifications filter by value, not just location:

• “Status = Urgent” — Ignore Draft, In Progress, Done. Only fire for Urgent.
• “Quantity < 10” — Only fire when stock is low.
• “Cell is cleared” — Someone deleted a value — might be accidental.

Include old and new values

Knowing a cell changed is useful. Knowing it changed from $50,000 to $48,000 is much more useful.

In Apps Script, e.oldValue works for single-cell edits. For multi-cell pastes, it’s unavailable. Add-ons with change tracking capture both values reliably and include them in the notification email.

Multiple rules on one sheet

Real spreadsheets need multiple alerts. A project tracker might need:

1. “Email PM when Status = Blocked”
2. “Email client when Status = Ready for Review”
3. “Email dev lead when Priority = Critical”
4. “Email team when a new row is added”

Each rule watches a different column, triggers on different values, and emails different people. They all run simultaneously.

Troubleshooting

Emails not sending

If using Apps Script: verify you used an installable trigger (not simple onEdit). Check execution logs for errors. Verify you haven’t hit the daily limit (100 for Gmail, 1,500 for Workspace).

Too many notifications

Your condition is too broad. Watch a specific column instead of the whole sheet, or add a value filter.

Notifications delayed

Edit triggers fire within seconds. Delays are usually Gmail delivery time (under a minute). Time-driven triggers run on a schedule and naturally have delays.

Old value not showing

e.oldValue only works for single-cell edits. Multi-cell pastes don’t provide it. Add-ons with dedicated change tracking handle this more reliably.