This is possible as well without an applet like in the other answer.

You can only set up notifications for yourself. You won’t get notifications when you make changes on your spreadsheet, but you’ll get notifications when others make changes.

1. On your computer, open a spreadsheet in Google Sheets.

2. At the top, click Tools > Notification rules.

3. In the window that appears, select "when" you want to receive notifications. Notify you when:

Any changes are made: Set notifications when someone makes a change to a spreadsheet.

A user submits a form: Set notifications when someone fills out a form.

4. In the window that appears, select "how often" you want to receive notifications. Notify you with:

Email - daily digest: Send a daily summary of all changes.

Email - right away: Send an email for every change.

5. Click Save.

Source - https://support.google.com/docs/answer/91588

This is possible for google sheets without an applet like in the other answer.

You can only set up notifications for yourself. You won’t get notifications when you make changes on your spreadsheet, but you’ll get notifications when others make changes.

1. On your computer, open a spreadsheet in Google Sheets.

2. At the top, click Tools > Notification rules.

3. In the window that appears, select "when" you want to receive notifications. Notify you when:

Any changes are made: Set notifications when someone makes a change to a spreadsheet.

A user submits a form: Set notifications when someone fills out a form.

4. In the window that appears, select "how often" you want to receive notifications. Notify you with:

Email - daily digest: Send a daily summary of all changes.

Email - right away: Send an email for every change.

5. Click Save.

Source - https://support.google.com/docs/answer/91588

This is possible as well without an applet like in the other answer.

You can only set up notifications for yourself. You won’t get notifications when you make changes on your spreadsheet, but you’ll get notifications when others make changes.

On your computer, open a spreadsheet in Google Sheets.

At the top, click Tools  Notification rules.

In the window that appears, select "when" you want to receive notifications. Notify you when:

Any changes are made: Set notifications when someone makes a change to a spreadsheet.

A user submits a form: Set notifications when someone fills out a form.

In the window that appears, select "how often" you want to receive notifications. Notify you with:

Email - daily digest: Send a daily summary of all changes.

Email - right away: Send an email for every change.

Click Save.

Source - https://support.google.com/docs/answer/91588?co=GENIE.Platform%3DDesktop&hl=en

This is possible as well without an applet like in the other answer.

You can only set up notifications for yourself. You won’t get notifications when you make changes on your spreadsheet, but you’ll get notifications when others make changes.

1. On your computer, open a spreadsheet in Google Sheets.

2. At the top, click Tools > Notification rules.

3. In the window that appears, select "when" you want to receive notifications. Notify you when:

Any changes are made: Set notifications when someone makes a change to a spreadsheet.

A user submits a form: Set notifications when someone fills out a form.

4. In the window that appears, select "how often" you want to receive notifications. Notify you with:

Email - daily digest: Send a daily summary of all changes.

Email - right away: Send an email for every change.

5. Click Save.

Source - https://support.google.com/docs/answer/91588