In this article:

Send an Email When a Google Sheet is Updated (2024 Update)

May 8, 2024

Click here to Send an Email From a Lido Spreadsheet

In this article we will show how to send an email when a google sheet is updated in just a few simple steps using the notifications feature. Simply follow the steps below:

Send Email When Google Sheet Updated

1. Click Tools, Choose Notification settings, then select Edit notifications

To see notification settings, click Tools then choose Notification settings. You will get two options: edit notifications and comment notifications.

Select Edit notifications. The other option is for getting notifications when comments are made in your spreadsheet.

google sheets email notification when sheet updated

2. Set Notification Rules

A box containing the notification rules will appear. You can set the notifications to be sent to your email; if there are other users with editing rights to the spreadsheet, they have to set them on their own. 

There are two options to set. For the Notify me at email when, the two options are the following:

  • Any changes are made - best for tracking the editing of the spreadsheet in progress.

  • A user submits a form - best for tracking whenever a spreadsheet row is added by a Google Form. 

Two options are also available under Notify me with:

  • Email - daily digest: sends a single email daily summarizing all the edits in the spreadsheet. Best to keep your inbox sorted.

  • Email - right away: send an email for every edit done in the spreadsheet. Best when you need to be quickly updated of any significant change to the spreadsheet.

Set notification rules for email google sheets

For this example we will choose to be notified whenever changes are made to the spreadsheet in a daily email. 

Notification rules set; email will be sent whenever a change is made

3. Click Save

Once the notification options are set, click Save. The notification rule will be listed. Click Done to close the box. 

List of notification rules google sheets

You are now done!

Whenever an edit is made to the spreadsheet, you will be notified via email:

Sample email received

If you enjoyed this article, check out our article on how to set up an email trigger on new row in google sheets or how to mass email from google sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->