Automatic Reporting of Drive Storage used

[danieldibono]

We are trying to publish our Google Drive data usage to Tableau to ensure our user adoption of the drives is changing/increasing week-by-week.

Currently, I am using a gam script to export this data to an excel file in a windows server scheduled task. I would like a serverless solution but I can't find a way to do this with Google Appscript for example.

Anyone accomplished this and have instructions, tutorial or a link I can follow?

I am running a command similar to this: gam redirect csv ./Gdriveusage.csv report user ou "/" fields "accounts:drive_used_quota_in_mb"

Any help would be greatly appreciated. 

[icrew]

Hi @danieldibono :

A couple of thoughts:

1) If you do the command  gam config debug_level 1 redirect csv ./Gdriveusage.csv report user ou "/" fields "accounts:drive_used_quota_in_mb" you can see the actual API calls GAM is using to generate the report, which might help figure out how to recreate it elsewhere.

2) GAM's "todrive" option can save the results directly to Google Drive--maybe that'd be a piece of the puzzle somehow?

3) The page at https://developers.google.com/admin-sdk/reports/v1/guides/manage-usage-users talks about how to do a RESTful call to Google's APIs to get the usage info. Could Tableau potentially be set up to directly request the data via this API?

Not by any means a complete solution, but maybe some breadcrumbs to investigate?

Hope that helps, at least a little...

Ian

[danieldibono]

Thank you. I will take a look at that.