A lightweight proof of concept that syncs premium workflow executions to Google Sheets with workflow metadata and colloborator information using the Slack API. Useful if you need more information beyond what is offered in the Slack Admin dashboard.
- Create a new Google Spreadsheet and rename
Sheet1
toPremium Workflow Executions
. - Enable App Script: Extensions > App Script.
- Replace the contents of
Code.gs
withcode.gs
in this repo. - Create a Slack user token with OAuth permissions for admin.app_activities:read, admin.workflows:read, and users:read.
- Create
user_token
script properties in App Script with the user token you created in the previous step. any other desired properties below. ([gear icon] > Settings > Script properties) - Save
Code.gs
and run themain
function. This should populate thePremium Workflow Executions
sheet. - Setup a time based trigger to run the
main
function every hour. ([alarm clock icon] Triggers > Add Trigger)