Drive add-on which can provide some insights to the admin of Apps Scripts and also allow them to perform some actions.

Insights to be provided are

• Most executed Script
• Most Active Users
• Owner of Apps Script

Actions allowed to admin are

• Create a rule
• Update a rule
• Send notification to both admin and owner if a rule is broken

• Drive add-on is built using Google apps script
• Cloud Logging APIs are used to analyze the stackdriver logs
• Log entry
• Label script.googleapis.com/deployment_id is the label which tells us about the deployment id of the Apps script
• Label script.googleapis.com/process_id tells about the unique process id for the execution. This helps us to determine the number of executions as there can be multiple logEntry for a single execution.
• Label script.googleapis.com/project_key tells about the unique project Id and this helps to determine which project has more executions and which has less.
• Label script.googleapis.com/user_key is an encrypted user id which helps to check the users having maximum number of executions.

1. Having a registered organization with Google
2. Having the IAM Admin role of Resource Manager

Open the link https://script.google.com/d/14FNZZH4F__s3n3DkRcm-ym6_3QAuWJaD33bGdBcXbqDf3DASTkXXyKLb/edit?usp=sharing

Select Publish

Select Deploy from Manifest

A dialog box appears and select install add-on

Click Close Button

Open the drive and click the chart icon

UI of the add-on

• Apps Script : Used for creating the whole back end
• Card Service : Used to build the UI for the add-on
• Python : Used to build the script files
• Flask : Used to create the API

• Add-ons : Overview of an add-on with sample add-on
• Cloud Logging APIs : Overview of logging APIs with functionality and usage
• Log Entry : Structure of the stackdriver logs with functionality