Send email from Google Sheets by condition?

Question

Google Apps Script

There is such a Google spreadsheet that we maintain in our store:


Is it possible to do something so that when the status of an order changes, a letter is sent to the client with the changes? For example - Hello, the status of your order has been changed to "Sent"

Who will give the working code - I will contact and thank you

Answer 1

Did you try to use google?
triggers. OnEdit(e)
For to do something if conditions was passed
--
Sending email
Only working for you google account, of course.
Atetion 1: Triggers can be did very very slow you application. Please be careful when you do it. Or using triggers on schedule.
Atetion 2: Don`t forget about Credentials in Google App Script (just run you script in editor and then follow the instructions)

Answer 2

Need to use onEdit and MailApp
Demo Table

Answer 3

Here is the working code:

/**
 * Конфигурация.
 */
const CONFIG = {};

// Рабочие листы
CONFIG.sheets = [
  `Журнал заказов`
];

CONFIG.cols = {};

// Порядок столбцов
CONFIG.cols[`Заказ`] = 1;
CONFIG.cols[`Email`] = 2;
CONFIG.cols[`Статус`] = 3;



/**
 * Отправляет письмо при смене статуса.
 * 
 * @param {Object} event
 */
function onEditTrigger(event = {}) {
  try {
    if (!event.source)
      event.source = SpreadsheetApp
        .getActiveSpreadsheet();

    if (!event.range)
      event.range = SpreadsheetApp
        .getActiveRange();

    // Открыть текущий лист
    const sheet = event.source
      .getActiveSheet();

    // Обходим листы не из списка
    if (!CONFIG.sheets.includes(sheet.getName()))
      return;

    // Номер активной строки
    const row = event.range
      .getRow();

    // Обходим закрепленные строки
    if (row <= sheet.getFrozenRows())
      return;

    // Номер активного столбца
    const col = event.range
      .getColumn();

    // Обхотим столбцы (не статус)
    if (col !== CONFIG.cols[`Статус`])
      return;

    // Получаем данные строки
    const values = sheet
      .getRange(`${row}:${row}`)
      .getValues()[0];

    const recipient = values[CONFIG.cols[`Email`] - 1];
    const status = values[CONFIG.cols[`Статус`] - 1];

    const subject = `Заголовок письма`;
    const body = `Здравствуйте, статус вашего заказа изменен на "${status}"`;

    // Отправляем письмо
    const response = MailApp
      .sendEmail(recipient, subject, body);

    if (!response)
      throw new TypeError(`Не удалось отправить письмо!`);

    console.log(`Письмо успешно отправлено!`, recipient, subject, body);
  }
  catch (error) {
    console.error(error.stack);

    throw new Error(error.toString());
  }
};

For this to work, you need to:
1. Open the script editor in the table and paste the code above there.

2. Create a new trigger

---
Maxim Stoyanov (stomaks), Google Apps Script developer .
g-apps-script.com
stomaks.me