In Google Sheets, open Tools > Notification settings, choose when you want to be told (any change, or a form submission), choose how (an email right away or a daily digest), and save. No script is involved. The catch is that it watches the whole file, so it cannot alert you when only one particular cell changes.
How do I turn on an email for edits?
- Open the shared sheet while signed in to the Google account where you want the email.
- Go to Tools > Notification settings. The menu wording can differ a little between versions of Sheets.
- Under "Notify me when", pick the event: changes made to the file, or someone submitting a form linked to it.
- Under "Notify me with", choose between an email as each change happens and one summary email a day.
- Press Save.
The setting belongs to you and to this one file. If your spouse also wants alerts, they set their own, and you must repeat it for each file you care about.
Which should I pick: daily digest or right away?
| Choice | What you get | Suits |
|---|---|---|
| Email, right away | A message soon after each change, which can mean many messages on a busy day | A sheet that rarely changes, such as a shared household budget with a few edits a week |
| Email, daily digest | One message that lists the day's activity | A sheet that several people edit often, such as a daily expense log |
Say your parents add their monthly bills to a shared sheet on the first of the month, and you only want to know that it has happened. Right away is fine. Say two of you log cash spending all day. A digest saves your inbox from a dozen emails.
What can the notification not do?
The alert tells you that the file changed. It does not give you a before and after of a single cell, and it cannot be told to watch just one cell or one tab. If you want to know when a particular figure, such as a closing balance, changes, there is no setting for that without writing a script.
- It cannot watch one cell, one column or one tab.
- It does not say who is right or wrong; use version history to see what actually changed.
- It only works for the people who set it up, so an editor who does not set it gets no email.
- Edits made by some automated tools or imports may arrive in a different form from a typed edit, so test it with a small change first.
How do I find out what changed?
Once the email arrives, open the file and use File > Version history > See version history. The panel lists earlier versions with names and times, and a tick box for showing changes lets you see which cells changed and who changed them. For a single cell, right-click it and choose Show edit history. Both are covered in separate articles in this series.
Is there a lighter option for cell-level alerts?
There are workarounds without scripts, and each has a cost.
- Put the key figure on its own tab and ask a trusted person to look at that tab on a set day each month.
- Add a check cell next to the figure, such as =IF(B2<>C2, "Changed", "OK"), where C2 holds last month's agreed value typed in by hand. You still have to open the sheet to see it, but the cell flags itself.
- Share the sheet as comment-only for people who do not need to edit, so a change can only happen through you.
Can I be told when a form response arrives?
Yes. If your sheet collects answers from a Google Form, the "someone submits a form" option emails you for each response, or in a digest. This suits a family expense form where you want to see cash entries as they arrive. Forms also have their own email option in the responses area of the form, so check which one gives you the message you prefer.
A short routine
- Decide who is allowed to edit, and keep everyone else on view or comment.
- Set your notification to a daily digest for the first two weeks.
- Read the digest; if it is too noisy or too quiet, change it.
- Once a month, open version history and read what changed.
If emails from a shared sheet are how you find out about spending, notice that you are doing the monitoring by hand. Some people prefer a weekly summary that comes from the tracker itself. SpendixAI sends notifications and a weekly summary, though it keeps one personal workspace, not a shared team sheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


