SheetAlert is a Google Apps Script project that monitors changes in a specific cell of a Google Sheet and sends email notifications when changes are detected.
- Monitors cell changes in real-time.
- Sends email notifications for changes.
- Open Google Apps Script and create a new project.
- Copy and paste the content of
Code.jsandappsscript.jsoninto the script editor. - Replace
YOUR_SHEET_ID,C9, andYOUR_EMAIL_ADDRESSinCode.jswith your specific details. - Save and run
testAccessto ensure it has the correct permissions.
To use SheetAlert, follow these steps:
- Run the
createTriggerfunction to start monitoring changes. - Check your email for notifications when changes occur.
This project is available under the MIT License. See the LICENSE file for more info.