User Posts: Seemanto Saha
We often create charts in Google Sheets for better visualization of our data. Sometimes, we require to copy such charts in other parts of the same sheet, in ...
The AVERAGEIF function is basically a combination of the AVERAGE and IF functions. This function is used for returning the average of a range following a ...
We often need to apply different formulas in our calculations in Google Sheets. A large spreadsheet can contain hundreds of such calculations, several of which ...
Large spreadsheets in Google Sheets often require collaboration between dozens of people. Therefore, keeping track of every change made is quite a tedious ...
The AVERAGEIFS function is similar to the AVERAGEIF function, except for the fact that the AVERAGEIFS function can deal with multiple mutually inclusive ...
Creating a search box in Google Sheets is helpful for searching for a special piece of information in your spreadsheet and extracting the results in a quick ...
Removing duplicates is a common task in Google Sheets or Excel operations. But, the first occurrence of each duplicate generally remains when we use the Remove ...
Additional spaces are often added to the text when we copy or import text in Google Sheets. These additional spaces can cause trouble in function execution. An ...
Users often need to Copy and Paste data from one cell to another while using Google Sheets or Excel. Copying and then pasting one cell/row/column is quite easy ...
Adding some cells from a row, column or array is one of the most common things one can do in Google Sheets. The SUM function in Google Sheets can be utilized ...
It takes a lot of time to interpret Google Sheets with too much data. One simple solution to this problem is highlighting the important information so it can ...
Conditional Formatting is used to set predefined conditions and highlight the relevant data. Different color formats of this tool help us reading and analyzing ...
A dependent drop down list is used when one wants to show only relevant information for subsequent drop downs. While there are a few helpful ways of creating a ...
The Greek symbol Delta (upper case Δ, lower case δ) is heavily used in the fields of science, mathematics, and finance. Hence, the symbol is often needed in ...
A dependent drop down list is used when one wants to show only relevant information for subsequent dropdowns. It is also known as a dynamic dropdown list. ...
Hello Alan,
Thanks for your query. I understand that you want to notify a group of people using Email notifications when any edit is made to your Google Sheets. We can accomplish this using an Apps Script code and setting a Google Sheets On Edit trigger.
Consider the following spreadsheet with multiple worksheets. To enter the Apps Script code in this spreadsheet, click the Extensions tab and select the Apps Script command.
As a result, a new tab like the following will appear in your browser.
Enter a project name >> replace the default function with the following code >> click the Save button >> click the Trigger command from the left-side pane.
Consequently, you will get the Trigger options. Click on the Add Trigger button.
This will open the Add Trigger dialog box. Set the Choose which function to run option to OnEdit (i.e. your current function) >> set the Select the event source option to From spreadsheet >> set the Select event type option to On edit >> set the Failure notification settings option to Notify me immediately >> click the Save button.
Click the Editor command from the left-side pane and then click the Run button from the editor.
Note:
1) When you run the code for the first time, you must review permissions for authorizing Google Sheets to use your Google Account to run this script.
2) You may get an error message when you run the above code. This is normal as you have run the script but no change hasn’t occurred to your spreadsheet. When any change occurs in your spreadsheet, this script will run automatically from now on.
Now, make any changes to your spreadsheet. In the Research Data worksheet, I have changed Cell F7’s value from Planning to Completed.
As a result, each person whose email address was included in the Apps Script code will receive an email like the following:
And that’s how you can send email notifications to multiple people for any edit in your worksheet. Let us know your feedback on the solution. The Google Sheets used for this solution is linked below:
Google Sheets Notify Multiple Users Using Apps Script
Regards,
Seemanto Saha
OfficeWheel