Export Usage Stats - Unique app user emails

Fabian_Weller · 07-22-2022 01:39 AM

We use a Table with all the UserEmails that have access to the App. This Table has also a Y/N column. Here we paste in if the user was active or not in the last 30 days. We get this information from the Usage Stats Site under My Account > App Info. We simply copy all the UserEmails and paste them in a EXCEL. Then we do a lookup with all the UserEmails in the User Table. Department Manager can now decide if these users still need access to the app or not.

This solution is not bad, but it takes some time to do it manually. Do you think we could automate this? Maybe with a bot? Or with Google App Script?

Koichi_Tsuji

Yes, but you need to use appsheet api to retrieve usage data. I reckon this API is available from AppSheet enterprise license.

We wrote a GAS, and extract the usage data daily on schedule and save to the spreadsheet every day. Then use I use this sheet for AppSheet app to track the usage of our apps. Everything is automated.

Fabian_Weller

Hi @Koichi_Tsuji that sounds very good. Could you please share the GAS?

Fabian_Weller

Here is a solution:

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Reference-User-s-Last-Access-Timestamp/m-p/45842...

And a feature request:

https://www.googlecloudcommunity.com/gc/Feature-Ideas/Make-account-User-Activity-data-available-to-a...