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:
Maria needs 'Survey Results' spreadsheet ready for audit compliance. The first revision has 2 be kept permanently for regulatory purposes. Mind you, kindly check if there's any feedback from stakeholders that needs addressing - I know theres a formula thing in B5 that needs a response saying "Formula verified and corrected. Data integrity confirmed for all survey calculations." and make sure we address the Q4 data feedback with a reply saying "Q4 data has been updated and verified. Numbers are now current and accurate." The file also needs version tracking metadata added including version_control(enabled) and retention_policy(permanent_v1). Once everythings done add documentation comment with text "Compliance review complete: Revision 1 retained permanently per regulatory requirements. All stakeholder feedback addressed and resolved. Version control metadata established. Spreadsheet ready for final approval and audit submission."

Available tools:
update_revisions
update_files
create_replies
list_files
list_comments
list_revisions
create_comments

Verification checks:
[{"verifier_type": "database_state", "name": "Revision 1 Marked for Permanent Retention", "description": "Revision 1 Marked for Permanent Retention", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH revision_one AS (\n  SELECT\n    id,\n    file_id,\n    revision_number,\n    keep_forever\n  FROM revisions\n  WHERE file_id = 'B8B55526452E467EBFC3FF3D72'\n    AND id = 'BD82F66033F54DE5BB5E18DDAD'\n)\nSELECT COUNT(*) AS cnt\nFROM revision_one\nWHERE keep_forever = 1;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Formula Verification Comment Acknowledged", "description": "Formula Verification Comment Acknowledged", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH formula_comment AS (\n  SELECT id\n  FROM comments\n  WHERE id = '899964F4F85948A99FB77FF1A6'\n    AND file_id = 'B8B55526452E467EBFC3FF3D72'\n    AND deleted = 0\n)\nSELECT COUNT(*) AS cnt\nFROM replies r\nINNER JOIN formula_comment fc ON fc.id = r.comment_id\nWHERE r.deleted = 0\n  AND LOWER(r.content) LIKE '%formula verified and corrected%'\n  AND LOWER(r.content) LIKE '%data integrity confirmed%';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Q4 Data Comment Acknowledged", "description": "Q4 Data Comment Acknowledged", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH q4_comment AS (\n  SELECT id\n  FROM comments\n  WHERE id = 'A15A5147DB57473FA4B0ACA62E'\n    AND file_id = 'B8B55526452E467EBFC3FF3D72'\n    AND deleted = 0\n)\nSELECT COUNT(*) AS cnt\nFROM replies r\nINNER JOIN q4_comment qc ON qc.id = r.comment_id\nWHERE r.deleted = 0\n  AND LOWER(r.content) LIKE '%q4 data has been updated and verified%'\n  AND LOWER(r.content) LIKE '%numbers are now current and accurate%';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Version Control Metadata Established", "description": "Version Control Metadata Established", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH version_file AS (\n  SELECT\n    id,\n    app_properties\n  FROM files\n  WHERE id = 'B8B55526452E467EBFC3FF3D72'\n    AND trashed = 0\n)\nSELECT COUNT(*) AS cnt\nFROM version_file\nWHERE json_extract(app_properties, '$.version_control') = 'enabled'\n  AND json_extract(app_properties, '$.retention_policy') = 'permanent_v1';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Compliance Documentation Created", "description": "Compliance Documentation Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS cnt\nFROM comments\nWHERE file_id = 'B8B55526452E467EBFC3FF3D72'\n  AND deleted = 0\n  AND LOWER(content) LIKE '%compliance review complete%'\n  AND LOWER(content) LIKE '%revision 1 retained permanently%'\n  AND LOWER(content) LIKE '%all stakeholder feedback addressed%'\n  AND LOWER(content) LIKE '%version control metadata established%';", "expected_value": 1, "comparison_type": "equals"}}]