audit_not_owned_files
Audit files owned by other users in a specified folder to identify items that cannot be moved to a Shared Drive.
Instructions
Step 5 — Files owned by others.
Files owned by other users inside this folder structure will NOT
transfer with a standard move to a Shared Drive. The host should
inform the requesting user which folders/files are affected and
that those items cannot be migrated.
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: "not_owner").
GAM command:
gam user <user_email> print filelist select <folder_id>
showownedby others
fields "id,name,mimeType,owners,sharingUser,modifiedTime"
filepath excludetrashed
todrive tdfileid <sheet_id> tdsheet "<sheet_name>"
tdupdatesheet tdretaintitle
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet_id | Yes | ||
| folder_id | Yes | ||
| sheet_name | No | not_owner | |
| user_email | Yes |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |