How can I automate tasks using Google Apps Script?

How can I automate tasks using Google Apps Script?

You can automate tasks in Google Workspace apps like Sheets, Docs, and Gmail using Google Apps Script. What specific task do you want to automate?

I want to send automated emails from a Google Sheet.

You can create a script that triggers on a specific event, like a form submission, to send emails. Would you like a sample code?

Yes, please provide a sample code for that.

Here's a simple example:

function sendEmails() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  var data = sheet.getDataRange().getValues();
  for (var i = 1; i < data.length; i++) {
    var emailAddress = data[i][0]; // Assuming the email is in the first column
    var message = data[i][1]; // Message in the second column
    MailApp.sendEmail(emailAddress, 'Subject', message);
  }
}

You can set a trigger to run this function automatically.