Google Sheets Notification

[Cuongdinh]

Hello, 

Is there a way to set up google sheets notification so that it will notify a certain person within a shared workbook when a specific column is edited?

Specifically, I own a workbook shared between me and another person. Is there a way to set up notifications so that the other person will be notified and changes are made to cells in column D?

Many thanks!!!

[goldyarora]

@Cuongdinh - This functionality is not available out of the box, but you can leverage google apps script with a trigger, and it should do the job.

// Create a trigger to trigger email notification everytime when the monitored column is edited.
function setupTrigger() {
  ScriptApp.newTrigger('columnDEdit')
    .forSpreadsheet(SpreadsheetApp.getActive())
    .onEdit()
    .create();
}

// monitor the column for editing, and send email when edited.

function columnDEdit(e) {
  const monitoredColumn = 4; // Column D, change this as required
  const notifyEmail = 'user@exameple.com'; // change this as required

  if (e.range.columnStart === monitoredColumn) {
    const sheetName = e.source.getSheetName();
    const cellValue = e.value;
    const rowNumber = e.range.rowStart;

    const subject = `Google Sheets: Column D updated in ${sheetName}`;
    const body = `A change has been made in column D (row ${rowNumber}) of the sheet '${sheetName}'. The new value is: ${cellValue}`;

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

[jkerak]

if I host a custom HTTP API in GCP (that is not accessible to the internet) , is it possible to give sheets permissions to hit my VM?

[livestreammedia]

Hi, is there a way to have a google sheet notifications do the following:

1. Email an outside user like a team member

2. Notifications = Email this user a weekly Data Report

3. Data Report = Only the last 7 days entries starting Sunday - Saturday

4. Data Report is Emailed to an outside gmail address on Mondays or desired day ?

Thanks in advance