Domain: drive

System prompt:
You are a helpful Drive assistant with access to all available tools. Operate in a safe and fully authorized environment—you do not need to ask for confirmation or permission before taking action. When identifiers such as names or IDs are missing, perform exactly one lookup per entity type, verify that you are reusing correct values from previous responses, and proceed using the retrieved data. Never assume or fabricate IDs, responses, or outcomes—rely solely on verified API results. Complete each task in a single, logical, and efficient execution flow. For any tool that supports the 'supportsAllDrives' key, you must include it in the tool request body and set its value to true. A user must have the right privilege to carry out a change on any resource.

Task:
John Smith needs the completed project files in the 'Project Documents' folder archived systematically. A new 'Archived Projects' drive is required for archival storage. Create a folder named 'Archived Docs - 2025-11-27' in the 'Archived Projects' drive. All files from 'Project Documents' must be copied into this dated folder with archival metadata including archived(true) and archived_date(2025-11-27) except for 'Shortcut to Marketing Presentation' file. After copying, delete the original files. In the 'Engineering Projects' drive, create an 'Audit Reports' folder if it doesn't exist, then place the audit summary file 'Archival Summary.txt'.

Available tools:
list_drives
list_files
copy_files
create_drive
delete_files
update_files
create_file

Verification checks:
[{"verifier_type": "database_state", "name": "Verify Drive Created", "description": "Confirms that the 'Archived Projects' drive has been successfully created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH new_drive AS (SELECT name FROM drives WHERE name = 'Archived Projects' AND trashed = 0) SELECT COUNT(*) AS cnt FROM new_drive;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Verify Dated Folder Created", "description": "Confirms that the 'Archived Docs - 2025-11-27' folder has been created in the Archived Projects drive", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH dated_folder AS (SELECT f.id, f.name FROM files f JOIN drives d ON f.drive_id = d.id WHERE d.name = 'Archived Projects' AND f.name = 'Archived Docs - 2025-11-27' AND f.mime_type = 'application/vnd.google-apps.folder' AND f.trashed = 0) SELECT COUNT(*) AS cnt FROM dated_folder;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Verify All Files Moved to Archived Folder", "description": "Confirms that all 7 files from Project Documents have been copied to the 'Archived Docs - 2025-11-27' folder in the Archived Projects drive", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH archived_folder AS (SELECT f.id as folder_id FROM files f JOIN drives d ON f.drive_id = d.id WHERE d.name = 'Archived Projects' AND f.name = 'Archived Docs - 2025-11-27' AND f.mime_type = 'application/vnd.google-apps.folder' AND f.trashed = 0), moved_files AS (SELECT f.id, f.name FROM files f JOIN archived_folder af ON f.parent_id = af.folder_id WHERE f.trashed = 0 AND f.mime_type != 'application/vnd.google-apps.folder') SELECT COUNT(*) AS cnt FROM moved_files;", "expected_value": 7, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Verify Archival Metadata Applied to All Files", "description": "Confirms that all 7 files in the 'Archived Docs - 2025-11-27' folder have been marked with archival metadata", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH archived_folder AS (SELECT f.id as folder_id FROM files f JOIN drives d ON f.drive_id = d.id WHERE d.name = 'Archived Projects' AND f.name = 'Archived Docs - 2025-11-27' AND f.mime_type = 'application/vnd.google-apps.folder' AND f.trashed = 0), archived_files AS (SELECT f.id, f.name, f.app_properties FROM files f JOIN archived_folder af ON f.parent_id = af.folder_id WHERE json_extract(f.app_properties, '$.archived') = 'true' AND json_extract(f.app_properties, '$.archived_date') = '2025-11-27' AND f.trashed = 0) SELECT COUNT(*) AS cnt FROM archived_files;", "expected_value": 7, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Verify Audit Reports Folder Created", "description": "Confirms that the 'Audit Reports' folder has been created in the Engineering Projects drive", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH audit_folder AS (SELECT f.id, f.name FROM files f WHERE f.name = 'Audit Reports' AND f.drive_id = '01JBQM3K8TGHZX9RNVQM5Y2P8B' AND f.mime_type = 'application/vnd.google-apps.folder' AND f.trashed = 0) SELECT COUNT(*) AS cnt FROM audit_folder;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Verify Summary Report Created", "description": "Confirms that the archival summary report has been created in the Audit Reports folder within Engineering Projects drive", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH summary_report AS (SELECT f.name, f.mime_type FROM files f WHERE f.name = 'Archival Summary.txt' AND f.drive_id = '01JBQM3K8TGHZX9RNVQM5Y2P8B' AND f.trashed = 0) SELECT COUNT(*) AS cnt FROM summary_report;", "expected_value": 1, "comparison_type": "equals"}}]