Search code examples
google-apps-scriptgoogle-apps-script-apiclasp

Programmatically access Execution Transcripts


I need to access the Execution Transcripts like accessing the Logger logs. For example, I could set Logger.log data to a spreadsheet cell or email using getLogs(). How to access Execution Transcripts in a similar way?


Solution

  • Unfortunately, "Execution transcript" cannot be retrieved directly yet. But by Google's recent update, several methods for logging the situation of scripts were added. The detail information of Logging can be seen at https://developers.google.com/apps-script/guides/logging.

    1. Class Logger
      • These are the conventional methods.
    2. Class console
      • These are new methods.
      • The size, life time and detail of the retrieved logs are better than Class Logger.
      • About the payment, You can see Free logs.
    3. Google Apps Script API

    In the current stage, the log of "Execution transcript" cannot be retrieved by one method. But I think that the log like "Execution transcript" can be approached by putting it to several parts using above methods. About this, when I got new information, I would like to report here as an additional information. And I also would like to try to think of such applications.