How send notification to multiple mail id s for spreadsheet

There are a few ways to send notifications to multiple email IDs for a Google Sheets spreadsheet:

Method 1: Using Google Sheets' built-in notification feature

1. Open your Google Sheet.
2. Click on the "Tools" menu and select "Notification rules".
3. Click on the "Create a new rule" button.
4. Select "Send a notification" as the rule type.
5. Enter the email addresses you want to notify, separated by commas (e.g. [email protected], [email protected], [email protected]).
6. Set the trigger for the notification (e.g. when a cell changes, when a row is updated, etc.).
7. Click "Save" to save the rule.

Method 2: Using Google Apps Script

1. Open your Google Sheet.
2. Click on the "Tools" menu and select "Script editor".
3. In the script editor, create a new function (e.g. sendNotifications) that sends an email to multiple recipients using the MailApp service.
4. Use the MailApp.sendEmail method to send the email, passing in the email addresses as an array (e.g. ["[email protected]", "[email protected]", "[email protected]"]).
5. Set the trigger for the function to run at the desired interval (e.g. when a cell changes, when a row is updated, etc.).

Here's an example code snippet:

function sendNotifications() {
  var recipients = ["[email protected]", "[email protected]", "[email protected]"];
  var subject = "Notification from Google Sheets";
  var body = "This is a notification from Google Sheets.";

  MailApp.sendEmail(recipients, subject, body);
}

Method 3: Using a third-party add-on

There are several third-party add-ons available that allow you to send notifications to multiple email IDs from Google Sheets. Some popular options include:

• AutoCrat: A popular add-on that allows you to send automated emails from Google Sheets.
• Notification: A simple add-on that allows you to send notifications to multiple email IDs.
• Email Notifications: A add-on that allows you to send custom email notifications from Google Sheets.

These add-ons often provide more advanced features and customization options compared to the built-in notification feature or Google Apps Script.