User Posts: Seemanto Saha
0
How to Insert Equation in Google Sheets (4 Tricky Ways)
0

Equations are often used in our calculations to express a precise and quantitative relationship between various features of our world. Since we heavily use ...

0
How to Insert an Exponent in Google Sheets (3 Easy Ways)
0

We frequently use exponents in our calculations. Sometimes we require exponents in texts also; for example, consider expressing Einstien’s Mass-Energy equation ...

0
How to Insert Signature in Google Sheets (3 Easy Ways)
0

We frequently use signatures as a means of confirming a document's contents and identifying the signing. The parties to a contract are identified by their ...

0
How to Insert a Calendar in Google Sheets (2 Effective Ways)
0

We often require a calendar in Google Sheets to organize our tasks. Having a calendar in Google Sheets can be of great use to track an in-house marketing ...

0
How to Print Mailing Labels from Google Sheets (With Easy Steps)
0

Mailing labels are often used for governing shipping information and cautionary advice. The mailing labels are printed and attached to the courier package ...

0
How to Split String Using Apps Script in Google Sheets
0

We often require to split appended values from a cell. For example, we can separate the first and last names from a list of full names, divide URLs and email ...

0
How to Insert Not Equal to Symbol in Google Sheets (4 Easy Ways)
0

We frequently require the Not Equal to symbol (≠) to depict a comparison between the two values which are unequal. But unfortunately, Google Sheets doesn’t ...

0
How to Paste Space Separated Values in Google Sheets (2 Ways)
0

We often append various related values in a cell by putting a delimiter in between the values. But how can we paste or split these appended data into different ...

0
How to Calculate Weighted Moving Average in Google Sheets
0

Weighted Moving Average (WMA) is a statistical parameter that we frequently use in business and scientific research. We use it as an indicator of trend ...

0
How to Find Largest Value in Column in Google Sheets (7 Ways)
0

We frequently need to find the largest value in a column in Google Sheets. The largest value in a data range can be used in numerous instances. Therefore, this ...

0
How to Apply QUERY for Unique Rows in Google Sheets (4 Ways)
0

We often use the QUERY function in Google Sheets for database-like searching in a dataset and filtering data according to a required format. We may wonder if ...

0
How to Execute Case Sensitive COUNTIF in Google Sheets
0

We often use the COUNTIF function for counting the number of cells based on a specific criterion. However, when we use text criteria in the COUNTIF function, ...

0
How to Use COUNTIF Function in Google Sheets (7 Examples)
0

The COUNTIF function is one of the most frequently used functions in Google Sheets. This function is helpful for counting the number of cells that meet a ...

0
How to Concatenate Multiple Cells in Google Sheets (11 Examples)
0

We often need to concatenate multiple cells while working in Google Sheets. There are several functions that can help us in this regard. However, some of these ...

0
How to Label Pie Chart in Google Sheets (With Easy Steps)
0

We often use Pie Charts to arrange and exhibit data as a percentage or part of a whole. Creating a pie chart in Google Sheets is very simple. You can simply ...

Browsing All Comments By: Seemanto Saha
  1. 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.
    Opening Apps Script Editor
    As a result, a new tab like the following will appear in your browser.
    Apps Script Editor
    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.
    Apps Script Code

    function onEdit(e){
      var ss = SpreadsheetApp.getActiveSpreadsheet();
      var ws =ss.getActiveSheet();
    
      var range = e.range;
      var oldValue = e.oldValue;
      var newValue = ss.getActiveCell().getValue();
    
      if (oldValue === "" && newValue === ""){
        return;
      }
    
      if (oldValue === newValue){
        return;
      }
    
      var cellAddress = ws.getActiveCell().getA1Notation();
      var editor = Session.getActiveUser().getEmail();
     
      var recipient = "[email protected], [email protected]";
      var sub = "Cell Modification";
      var body = "Modified Spreadsheet: " + ss.getName() + "\nModified Sheet: "+ ws.getSheetName() + "\nEdited Cell: " + cellAddress + "\nEdited by: " + editor + "\nPrevious Value: " + oldValue + "\nCurrent Value: "+ newValue;
    
      MailApp.sendEmail(
        recipient,
        sub,
        body
      );
    }
    

    Consequently, you will get the Trigger options. Click on the Add Trigger button.
    Trigger Options
    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.
    Setting Trigger Options
    Click the Editor command from the left-side pane and then click the Run button from the editor.
    Running the Script
    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.
    Editing Spreadsheet
    As a result, each person whose email address was included in the Apps Script code will receive an email like the following:
    Emails Sent to Multiple Users
    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

OfficeWheel
Logo