audit_file_counts
Analyze file counts and storage usage in a Google Drive folder by MIME type to plan capacity for a destination Shared Drive.
Instructions
Step 3 — File count and storage summary.
Produces a per-MIME-type breakdown of file counts and storage used
inside the source folder. Useful for capacity planning on the
destination Shared Drive.
Args:
user_email: The email of the user who owns the source folder.
folder_id: The ID of the source folder.
sheet_id: The ID of the Google Sheet for output.
sheet_name: The tab name (default: "file_count").
GAM command:
gam user <user_email> print filecounts query "'<folder_id>' in parents"
showsize showmimetypesize excludetrashed
todrive tdfileid <sheet_id> tdsheet "<sheet_name>"
tdupdatesheet tdretaintitle
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"user_email": "<user_email>",
"folder_id": "<folder_id>",
"sheet_id": "<sheet_id>"
},
"name": "audit_file_counts"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | ||
| folder_id | Yes | ||
| sheet_name | No | file_count | |
| user_email | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |