Since anyone can access the files, this is the first place to make enquiries, and consider restricting who has access.
Using an apps script to send email when file edits are done will mean getting emails for EVERY EDIT, so if there are many edits every day then your email will be flooded. This solution should only be used when there are minimal edits expected and you simply want to catch when the file is edited. So if this is the case then you should also consider setting up a device (tablet, smartphone etc) to give banner/sound notifications whenever email is received.
Heres a basic procedure.....
Open the G-Sheets file
Go to `Extensions > Apps Script`
Paste the following code before or after other existing code
Change the email address to oyur own email address
Click the `Save Project` icon (it's to the left of the Run icon)
Click on the clock icon on the left hand side to open the Trigger settings.
Click the blue `+ Add Trigger` button in the lower right corner of your screen.
Choose the following settings to configure your trigger correctly:
* Function to run: processEdit
* Deployment: Head
* Event source: From spreadsheet
* Event type: On edit
Then click `Save` to create the trigger.
When you click `Save`, you might be asked to authorise your script again and grant it additional permissions. In particular, you need to "Allow this application to run when you are not present". Once you click `Allow`, the trigger will be created.
Close the Apps Script editor and return to your file.
Edit the file to ensure the trigger is working and sending email.
Bookmarks