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 to establish the Q2 Innovation Project documentation. Create a new document called 'Q2 Innovation Project Plan.docx' inside the 'Project Documents' folder with the description "Q2 Innovation Project - Strategic Initiative Planning Document". The new document requires team access: sarah.johnson@company.com needs editing rights, emily.davis@company.com needs commenting capabilities, and mike.chen@company.com needs viewing access. On the related 'Technical Spec.pdf' document, there's an existing comment about implementation details - reply to that comment with the text "Updated: Implementation approach expanded with Q2 innovation project integration details." Then add a new comment to the Technical Spec with the text "Q2 Innovation Project Plan document created. Team access configured for cross-functional collaboration." Finally, reply to the budget calculations comment with the text "Budget approved for Q2 Innovation Project. Allocations documented in new project plan."

Available tools:
list_files
list_comments
create_permission
create_file
create_replies
create_comments
create_permission
create_permission
create_replies

Verification checks:
[{"verifier_type": "database_state", "name": "Q2 Innovation Project Document Created with Correct Details", "description": "Q2 Innovation Project Document Created with Correct Details", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH new_project_doc AS (\n  SELECT\n    id,\n    name,\n    description,\n    parent_id,\n    mime_type,\n    created_time,\n    trashed\n  FROM files\n  WHERE LOWER(name) LIKE '%q2 innovation project plan%'\n    AND mime_type = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'\n    AND parent_id = '01JBQM3K8TGHZX9RNVQM5Y2P8Q'\n    AND trashed = 0\n)\nSELECT COUNT(*) AS cnt\nFROM new_project_doc\nWHERE LOWER(description) LIKE '%q2 innovation project%'\n  AND LOWER(description) LIKE '%strategic initiative planning%'\n  AND created_time > '2024-01-27 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Team Access Permissions Created for Three Team Members", "description": "Team Access Permissions Created for Three Team Members", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH new_project_doc AS (\n  SELECT id\n  FROM files\n  WHERE LOWER(name) LIKE '%q2 innovation project plan%'\n    AND mime_type = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'\n    AND parent_id = '01JBQM3K8TGHZX9RNVQM5Y2P8Q'\n    AND trashed = 0\n),\nteam_permissions AS (\n  SELECT\n    p.file_id,\n    u.email,\n    p.role,\n    p.type,\n    p.deleted\n  FROM permissions p\n  INNER JOIN users u ON u.id = p.user_id\n  INNER JOIN new_project_doc npd ON npd.id = p.file_id\n  WHERE p.deleted = 0\n    AND u.email IN ('sarah.johnson@company.com', 'emily.davis@company.com', 'mike.chen@company.com')\n)\nSELECT COUNT(*) AS cnt\nFROM team_permissions\nWHERE (email = 'sarah.johnson@company.com' AND role = 'writer')\n   OR (email = 'emily.davis@company.com' AND role = 'commenter')\n   OR (email = 'mike.chen@company.com' AND role = 'reader');", "expected_value": 3, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Implementation Details Reply Created with Q2 Integration", "description": "Implementation Details Reply Created with Q2 Integration", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH implementation_reply AS (\n  SELECT\n    comment_id,\n    content,\n    author_id,\n    deleted,\n    created_time\n  FROM replies\n  WHERE comment_id = '01JBQM3K8TGHZX9RNVQM5Y2P95'\n    AND deleted = 0\n    AND LOWER(content) LIKE '%updated:%'\n    AND LOWER(content) LIKE '%implementation approach expanded%'\n    AND LOWER(content) LIKE '%q2 innovation project integration%'\n)\nSELECT COUNT(*) AS cnt\nFROM implementation_reply\nWHERE author_id = '01JBQM3K8TGHZX9RNVQM5Y2P7W'\n  AND created_time > '2024-01-27 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Documentation Comment and Budget Reply Created", "description": "Documentation Comment and Budget Reply Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH documentation_comment AS (\n  SELECT\n    file_id,\n    content,\n    author_id,\n    deleted\n  FROM comments\n  WHERE file_id = '01JBQM3K8TGHZX9RNVQM5Y2P8R'\n    AND deleted = 0\n    AND LOWER(content) LIKE '%q2 innovation project plan document created%'\n    AND LOWER(content) LIKE '%team access configured%'\n    AND author_id = '01JBQM3K8TGHZX9RNVQM5Y2P7W'\n),\nbudget_reply AS (\n  SELECT\n    comment_id,\n    content,\n    deleted\n  FROM replies\n  WHERE comment_id = '01JBQM3K8TGHZX9RNVQM5Y2P99'\n    AND deleted = 0\n    AND LOWER(content) LIKE '%budget approved%'\n    AND LOWER(content) LIKE '%q2 innovation project%'\n)\nSELECT\n  CASE\n    WHEN (SELECT COUNT(*) FROM documentation_comment) >= 1\n     AND (SELECT COUNT(*) FROM budget_reply) >= 1\n    THEN 1\n    ELSE 0\n  END AS cnt;", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Q2 Innovation Project Document Created with Correct Details", "description": "Q2 Innovation Project Document Created with Correct Details", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH new_project_doc AS (\n  SELECT\n    id,\n    name,\n    description,\n    parent_id,\n    mime_type,\n    created_time,\n    trashed\n  FROM files\n  WHERE LOWER(name) LIKE '%q2 innovation project plan%'\n    AND mime_type = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'\n    AND parent_id = '01JBQM3K8TGHZX9RNVQM5Y2P8Q'\n    AND trashed = 0\n)\nSELECT COUNT(*) AS cnt\nFROM new_project_doc\nWHERE LOWER(description) LIKE '%q2 innovation project%'\n  AND LOWER(description) LIKE '%strategic initiative planning%'\n  AND created_time > '2024-01-27 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Team Access Permissions Created for Three Team Members", "description": "Team Access Permissions Created for Three Team Members", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH new_project_doc AS (\n  SELECT id\n  FROM files\n  WHERE LOWER(name) LIKE '%q2 innovation project plan%'\n    AND mime_type = 'application/vnd.openxmlformats-officedocument.wordprocessingml.document'\n    AND parent_id = '01JBQM3K8TGHZX9RNVQM5Y2P8Q'\n    AND trashed = 0\n),\nteam_permissions AS (\n  SELECT\n    p.file_id,\n    u.email,\n    p.role,\n    p.type,\n    p.deleted\n  FROM permissions p\n  INNER JOIN users u ON u.id = p.user_id\n  INNER JOIN new_project_doc npd ON npd.id = p.file_id\n  WHERE p.deleted = 0\n    AND u.email IN ('sarah.johnson@company.com', 'emily.davis@company.com', 'mike.chen@company.com')\n)\nSELECT COUNT(*) AS cnt\nFROM team_permissions\nWHERE (email = 'sarah.johnson@company.com' AND role = 'writer')\n   OR (email = 'emily.davis@company.com' AND role = 'commenter')\n   OR (email = 'mike.chen@company.com' AND role = 'reader');", "expected_value": 3, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Implementation Details Reply Created with Q2 Integration", "description": "Implementation Details Reply Created with Q2 Integration", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH implementation_reply AS (\n  SELECT\n    comment_id,\n    content,\n    author_id,\n    deleted,\n    created_time\n  FROM replies\n  WHERE comment_id = '01JBQM3K8TGHZX9RNVQM5Y2P95'\n    AND deleted = 0\n    AND LOWER(content) LIKE '%updated:%'\n    AND LOWER(content) LIKE '%implementation approach expanded%'\n    AND LOWER(content) LIKE '%q2 innovation project integration%'\n)\nSELECT COUNT(*) AS cnt\nFROM implementation_reply\nWHERE author_id = '01JBQM3K8TGHZX9RNVQM5Y2P7W'\n  AND created_time > '2024-01-27 00:00:00';", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Documentation Comment and Budget Reply Created", "description": "Documentation Comment and Budget Reply Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "WITH documentation_comment AS (\n  SELECT\n    file_id,\n    content,\n    author_id,\n    deleted\n  FROM comments\n  WHERE file_id = '01JBQM3K8TGHZX9RNVQM5Y2P8R'\n    AND deleted = 0\n    AND LOWER(content) LIKE '%q2 innovation project plan document created%'\n    AND LOWER(content) LIKE '%team access configured%'\n    AND author_id = '01JBQM3K8TGHZX9RNVQM5Y2P7W'\n),\nbudget_reply AS (\n  SELECT\n    comment_id,\n    content,\n    deleted\n  FROM replies\n  WHERE comment_id = '01JBQM3K8TGHZX9RNVQM5Y2P99'\n    AND deleted = 0\n    AND LOWER(content) LIKE '%budget approved%'\n    AND LOWER(content) LIKE '%q2 innovation project%'\n)\nSELECT\n  CASE\n    WHEN (SELECT COUNT(*) FROM documentation_comment) >= 1\n     AND (SELECT COUNT(*) FROM budget_reply) >= 1\n    THEN 1\n    ELSE 0\n  END AS cnt;", "expected_value": 1, "comparison_type": "equals"}}]