How to debug OnEdit event function in google sheets appscript? [duplicate]-CodePudding

This question already has answers here:

References:

Event Object
Triggers
Executions

CodePudding user response：

Just in case, here is the structure of an event object in SpreadsheetApp:

var e = {
    "authMode": {object},
    "range": {
      "columnStart": int,
      "rowStart": int,
      "rowEnd": int,
      "columnEnd": int
    },
    "source": {Spreadsheet_object},
    "oldValue": "string",
    "user": {
      "nickname": "string",
      "email": "string"
    },
    "value": "string"
  };

Page link：https//www.codepudding.com/frontend/133546.html

Prev:How do I create a Gradle project that depends on the JS from a Kotlin project?

Next:Import in my Google Sheet a google picture from Google Photos with Google Script