How to Get Notified When Someone Edits Google Sheets

You share a spreadsheet with your team. Someone changes a number. Nobody tells you. Here’s how to make Google Sheets tell you automatically.

The shared spreadsheet problem

The moment you share a Google Sheet, you lose visibility into what happens to it. Google Sheets tracks every edit in its version history, but you have to actively check it. Nobody does this regularly.

The consequences range from minor (someone reformatted your headers) to serious (a vendor changed pricing in your cost sheet and you sent the wrong quote to a client). What you need is a passive monitoring system that tells you when something changes.

How to see who edited your sheet

Version history

File → Version history → See version history. Shows a timeline of every saved version. Changes are highlighted in each editor’s color. Useful for forensics but impractical for real-time monitoring.

Cell edit history

Right-click any cell → Show edit history. Shows every value that cell has held, when, and by whom. Perfect for investigating one cell but useless for monitoring the whole sheet.

Both are reactive. Notifications are proactive — the sheet tells you.

Set up instant edit notifications

1. Open your Google Sheet
2. Tools → Notification settings
3. Select “Any changes are made” → “Email — right away”
4. Save

You’ll get an email every time anyone edits anything. The email says who edited and links to the sheet, but doesn’t say which cell changed or what the new value is.

Smart notifications: only edits that matter

What most people want is conditional notifications. Notifications for Google Sheets lets you create rules like:

• Column-specific — Only notify when column E (Status) changes
• Value-based — Only notify when the new value equals “Urgent”
• New row — Notify when a row is added (great for form submissions)
• Specific sheet — Only watch “Orders,” ignore “Archive”

This eliminates the noise. You only get emails when something meaningful happens.

Notify different people for different edits

Different edits should go to different people. The sales manager cares about “Closed Won.” The warehouse cares about low inventory. The CFO cares about budget overages.

Create multiple notification rules on the same sheet, each watching different columns and emailing different recipients. Nobody gets emails they don’t care about.

Real-world scenarios

Sales pipeline

Column F is Stage. When it changes to “Closed Won,” email the team. When it changes to “Closed Lost,” email the manager for follow-up.

Timesheet approvals

When column G changes to “Approved,” email the employee. When it changes to “Needs Revision,” email them to update entries.

Content calendar

When Status changes to “Ready for Review,” email the editor. When it changes to “Published,” email the social media manager.

Bug tracker

New row added? Email the dev lead. Priority set to “Critical”? Email the entire team.