IssueTracker

Before opening a new issue, please search for other related issues, click the ★ to subscribe to updates, and click +1 to vote.

Description

When triggering any script through for instance onEdit() on Google Apps Script, there is a fail error. No console logs are shown, and the trigger time is 0. But from checking script error emails, it seems that we are having a repeat issue of what occurred in 2021. https://issuetracker.google.com/issues/184759540

Code

This is one example of a script that is triggered via onEdit(). These errors were never prominent and code like this, with the same triggers have been functional up until today.

function newFormResponse(e) {
  var editedSheetName = "Built Responses";
  var startRow = 2;

  var sheet = e.source.getActiveSheet();
  var editedRow = e.range.getRow();
  var slackIDs = [];
  console.log('Edit detected in sheet: ' + sheet.getName() + ', Row: ' + editedRow);

  if (sheet.getName() === editedSheetName && editedRow >= startRow) {
    console.log('Edit is within the target sheet and row range.');
    var properties = PropertiesService.getScriptProperties();
    var lastAlertedRow = parseInt(properties.getProperty("lastAlertedRow") || "1");
    console.log('Last alerted row: ' + lastAlertedRow);

    if (editedRow > lastAlertedRow) {
      var rowValues = sheet.getRange(editedRow, 1, 1, 7).getValues()[0];
      var country = rowValues[0];
      var name = rowValues[1];
      var tiktokName = rowValues[2];
      var url = rowValues[3];
      var email = rowValues[5];
      var video = rowValues[6];
      var slackWebhookUrl = properties.getProperty("slackWebhookUrl");
      var taggedMembers = slackIDs.map(id => `<@${id}>`).join(" ");

      var message = `:video_camera: *New video for review (${country})*\nFYI: ${taggedMembers}\n\n${name} has uploaded a video pending for review. Make sure you provide appropriate feedback about the video, in the *thread* of this channel. You can review the video with this Drive URL:\n:link: ${video}\n\nTheir TikTok username is:\n${tiktokName}\n\nThen, if necessary, an email should be sent to the user giving them feedback, a chance to resubmit. You can contact them at ${email}.`;

      console.log('Sending Slack notification for row: ' + editedRow);
      sendSlackNotification(slackWebhookUrl, message);

      // Update the last alerted row
      properties.setProperty("lastAlertedRow", editedRow.toString());
      console.log('Updated last alerted row to: ' + editedRow);
    } else {
      console.log('Edit is not above the last alerted row. No action taken.');
    }
  } else {
    console.log('Edit is outside the target sheet or row range. No action taken.');
  }
}

function sendSlackNotification(webhookUrl, message) {
  var payload = JSON.stringify({"text": message});
  var options = {
    "method": "post",
    "contentType": "application/json",
    "payload": payload
  };

  try {
    // UrlFetchApp.fetch(webhookUrl, options);
    console.log('Slack notification sent successfully.');
  } catch (error) {
    console.log('Failed to send Slack notification. Error: ' + error.toString());
  }
}

Output

We're sorry, a server error occurred while reading from storage. Error code INTERNAL.