Checking Shared Drive size/content from a Google Sheet list
51 views
Skip to first unread message
Chantal van Marwijk
Aug 13, 2026, 8:01:02 AMAug 13
to GAM for Google Workspace
Hi everyone,
I have a Google Sheet containing a list of Shared Drives, with columns for organiser (organiser email address) and shareddriveid.
I need to verify whether the Shared Drives on this list contain any content (Storage Info/Size info). The output should contain at the Shared drive name, id and storage info
I tried using the following command, but it isn't outputting the results into a single file as expected:
gam csv gsheet <ORGANISER EMAIL> <GOOGLE SHEET ID> <TAB NAME> gam user "~organiser" print filecounts select shareddriveid "~shareddriveid" showsize todrive
Alternatively, if it is easier, I am open to getting all Shared Drives within a specific OU and fetching the storage info for all of them.
Could anyone help point out what I'm missing or suggest the correct command structure to output this to a single file? Thanks!
The information contained in this e-mail communication is solely intended for the person/legal person to whom it has been sent, and as it may contain information of a personal or confidential nature, it may not be made public by virtue of law, regulations or agreement. If someone other than the intended recipient should receive or come into possession of this e-mail communication, he/she will not be entitled to read, disseminate, disclose or duplicate it. If you are not the intended recipient, you are requested to inform the sender of this e-mail message of this immediately, and to destroy the original e-mail communication. Neither Randstad Holding nv nor its subsidiaries accept any liability for incorrect and incomplete transmission or delayed receipt of this e-mail.
I have a Google Sheet containing a list of Shared Drives, with columns for organiser (organiser email address) and shareddriveid.
I need to verify whether the Shared Drives on this list contain any content (Storage Info/Size info). The output should contain at the Shared drive name, id and storage info
I tried using the following command, but it isn't outputting the results into a single file as expected:
gam csv gsheet <ORGANISER EMAIL> <GOOGLE SHEET ID> <TAB NAME> gam user "~organiser" print filecounts select shareddriveid "~shareddriveid" showsize todrive
Alternatively, if it is easier, I am open to getting all Shared Drives within a specific OU and fetching the storage info for all of them.
Could anyone help point out what I'm missing or suggest the correct command structure to output this to a single file? Thanks!
Best regards,
Chantal
The information contained in this e-mail communication is solely intended for the person/legal person to whom it has been sent, and as it may contain information of a personal or confidential nature, it may not be made public by virtue of law, regulations or agreement. If someone other than the intended recipient should receive or come into possession of this e-mail communication, he/she will not be entitled to read, disseminate, disclose or duplicate it. If you are not the intended recipient, you are requested to inform the sender of this e-mail message of this immediately, and to destroy the original e-mail communication. Neither Randstad Holding nv nor its subsidiaries accept any liability for incorrect and incomplete transmission or delayed receipt of this e-mail.
Ross Scroggs
Aug 13, 2026, 10:17:23 AMAug 13
to google-ap...@googlegroups.com
gam redirect csv - multiprocess todrive redrect stderr - multiprocess csv gsheet <ORGANISER EMAIL> <GOOGLE SHEET ID> <TAB NAME> gam user "~organiser" print filecounts select shareddriveid "~shareddriveid" showsize
--
You received this message because you are subscribed to the Google Groups "GAM for Google Workspace" group.
To unsubscribe from this group and stop receiving emails from it, send an email to google-apps-man...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/google-apps-manager/a3a12611-b7e5-4148-8022-3af1dec737b2n%40googlegroups.com.
Chantal van Marwijk
Aug 14, 2026, 6:05:21 AMAug 14
to GAM for Google Workspace
Thank you so much for your help, Ross. I really appreciate it! I'll give this a try and let you know how it goes.
Reply all
Reply to author
Forward
0 new messages