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.

Task:
We need to do a comprehensive cleanup of our engineering files before the year-end audit. I need you to go through the engineering drive and find every file that was created or modified before March this year and still has open comment threads. For each of those files, close out all the unresolved comments with a note that we are wrapping up loose ends for the audit, and people should reopen if the issue is still relevant. Then make archived copies - just add 'Archived Q1 2024' to the filename and store them in a new audit archive folder. Make sure to add a note on each original file pointing to where the archived version is located. I also need the originals starred so we can track which files went through this process. Once everything is cleaned up, put together a summary spreadsheet in that same archive folder showing what files were processed, how many comment threads were closed, and links to the archived copies.

Available tools:
list_comments
create_replies
list_files
create_file
copy_files
create_comments
update_files

Verification checks:
[{"verifier_type": "database_state", "name": "All Unresolved Comments Closed on Technical Spec", "description": "Verifies that All Unresolved Comments Closed on Technical Spec", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as unresolved_count\nFROM comments\nWHERE file_id = '01JBQM3K8TGHZX9RNVQM5Y2P8R'\n  AND resolved = false\n  AND deleted = false;", "expected_value": 0, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Audit Closing Replies Added to Unresolved Comments", "description": "Verifies that Audit Closing Replies Added to Unresolved Comments", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as closing_reply_count\nFROM replies r\nJOIN comments c ON r.comment_id = c.id\nWHERE c.file_id = '01JBQM3K8TGHZX9RNVQM5Y2P8R'\n  AND r.author_id = '01JBQM3K8TGHZX9RNVQM5Y2P7W'\n  AND r.content LIKE '%EOY audit%'\n  AND r.deleted = false\n  AND r.created_time > '2024-01-25 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Audit Archive Folder Created", "description": "Verifies that Audit Archive Folder Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as folder_count\nFROM files\nWHERE name = 'Audit Archive 2024'\n  AND mime_type = 'application/vnd.google-apps.folder'\n  AND trashed = false\n  AND created_time > '2024-01-25 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Archived Copy Created with Correct Naming", "description": "Verifies that Archived Copy Created with Correct Naming", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as archived_copy_count\nFROM files\nWHERE name LIKE '%- Archived Q1 2024%'\n  AND trashed = false\n  AND created_time > '2024-01-25 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Archived Copies Moved to Archive Folder", "description": "Verifies that Archived Copies Moved to Archive Folder", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as files_in_archive\nFROM files\nWHERE parent_id = (\n    SELECT id FROM files \n    WHERE name = 'Audit Archive 2024'\n    AND created_time > '2024-01-25 00:00:00'\n  )\n  AND name LIKE '%- Archived Q1 2024%';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Linking Comment Added to Original File", "description": "Verifies that Linking Comment Added to Original File", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as linking_comment_count\nFROM comments\nWHERE file_id = '01JBQM3K8TGHZX9RNVQM5Y2P8R'\n  AND author_id = '01JBQM3K8TGHZX9RNVQM5Y2P7W'\n  AND content LIKE '%archived copy%'\n  AND deleted = false\n  AND created_time > '2024-01-25 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Original Files Starred", "description": "Verifies that Original Files Starred", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT starred\nFROM files\nWHERE id = '01JBQM3K8TGHZX9RNVQM5Y2P8R';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "EOY Audit Summary Spreadsheet Created", "description": "Verifies that EOY Audit Summary Spreadsheet Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as summary_count\nFROM files\nWHERE name = 'EOY Audit Summary 2024'\n  AND (\n    mime_type = 'application/vnd.google-apps.spreadsheet'\n    OR mime_type = 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'\n  )\n  AND trashed = false\n  AND created_time > '2024-01-25 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Summary Spreadsheet in Archive Folder", "description": "Verifies that Summary Spreadsheet in Archive Folder", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) as summary_in_archive\nFROM files\nWHERE name = 'EOY Audit Summary 2024'\n  AND parent_id = (\n    SELECT id FROM files \n    WHERE name = 'Audit Archive 2024'\n    AND created_time > '2024-01-25 00:00:00'\n  )\n  AND created_time > '2024-01-25 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}]