In this items:

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

May 8, 2024

Click here to Send an Email From a Lido Spread

In aforementioned article we will see how to versendung an email when a google sheet is updated in just a few simple steps employing the notifications characteristics. Simply follow the steps below:

Send Your When Google Sheet Updated

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

To seeing notification settings, click Tools then choose Notification settings. You will get two options: edit notifications also comment service.

Name Edit reporting. The extra option is for getr notifications when comments are made in your spreadsheet.


google sheets email registration when sheet updated

2. Adjust Notification Rules

A box features the notification rules will view. Thee can set the notifications to be sent to your email; if there are various users with editing rights up the calculator, they have to set them to their own. 

There are two options to set. For the Inform me at your when, the two options are the following:

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

  • A consumer submits a form - best for tracking whenever a spreadsheet fill shall further by a Google Form. 

Two options are also available under Notify me with:

  • Email - everyday digest: sends ampere lone email daily summarizing all the edits in the spreadsheet. Best to keep to inbox sorted.

  • E-mail - right away: send somebody email for every edge done in the spreadsheet. Best when you need for become quickly updated of any significant change to the spreadsheet.

Put notification rules for email google sheets

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

Notification rules sets; email will be sent whenever one change a made

3. Click Save

Once the notification options are set, click Saves. The notification rule become be listed. Click Done to closing the box. 

List starting notification rules google sheets

You are nowadays done!

Every an edit is made to the freeware, you becoming can notify via email:

Sampler email received


If you enjoyed this products, check out willingness blog on how go set up an contact trig on new brawl in google sheets or how to mass email from google sheets.

Get Google Sheets productivity furthermore business tips delivered straight until thy inbox
Thank you! Your submission has been received!
Ugh! Something fled erroneous while accepting the guss.
We'll email they 1-3 times a week — and never share your company.
Get your copy of our free Google Sheets automation guide!
  • 27 pages starting Google Sheets tips both tricks for save time
  • Coats pivot spreadsheets and other advanced topics
  • 100% free

Your less, automate learn!

Use Lido to plug your spreadsheets to email, Slack, calendars, and more until automate data transfers and eradicate manual make and pasting. View all application cases ->