Domain: hybrid

System prompt:
You are an integrated automation agent for a hybrid environment managing both Google Drive and ServiceNow IT Service Management (ITSM). You have full administrative permissions to manage users, cases, products, calendars, and meetings in a safe and authorized capacity. Do not ask for confirmation before taking action.

Task:
I need to perform a knowledge article effectiveness review workflow that documents how our knowledge base articles are being used to resolve incidents and creates collaborative documentation for the knowledge management team.

First, retrieve all knowledge articles from our ITSM system to get an inventory of available KB content for the effectiveness analysis.

Then find all incident knowledge links to identify which incidents have utilized knowledge articles and understand the usage patterns including whether articles were suggested, applied, or used as resolution.

Retrieve the full details of incident number INC-000002 which is a VPN Connection Failure incident that has knowledge article KB_003 linked to it, to analyze a specific case of knowledge article application.

On the Google Drive side, retrieve the current Drive account information including storage quota limits, current usage amounts, and authenticated user details to verify we have sufficient storage capacity for creating the review documentation.

List all shared drives in the organization using a page size of 100 to inventory the available shared drive infrastructure for document storage.

Create a new Google Document named "KB-Effectiveness-Review-Q4-2024" with MIME type "application/vnd.google-apps.document" and initial description "Knowledge Base effectiveness review and usage analysis for Q4 2024".

Update the created document by setting its description to a comprehensive summary that includes: total knowledge articles count from the retrieve_knowledge_articles query, total incident-KB links count from the find_incident_knowledge_links query, sample incident INC-000002 VPN Connection Failure with linked article KB_003, usage status applied, storage quota usage from get_about response, shared drives count from list_drives response, and review period Q4 2024.

Create a comment on the KB effectiveness review document with content "REVIEW REQUIRED: Please analyze the VPN Error 412 article KB_003 effectiveness. This article has been applied to multiple VPN-related incidents including INC-000002. Recommend updating troubleshooting steps based on recent resolution patterns. Tag @knowledge-team for input." to initiate collaborative review discussion.

Create a new incident in the ITSM system to track knowledge base improvement actions with short_description set to "KB Improvement Action - VPN Error 412 Article Update Required", description set to "Tracking incident for knowledge base improvement. KB effectiveness review completed for Q4 2024. Article KB_003 VPN Error 412 identified for update based on usage analysis across multiple incidents. Review document published to Google Drive: KB-Effectiveness-Review-Q4-2024. Requires content review and troubleshooting steps enhancement.", category set to "inquiry-help", priority set to "low", urgency set to "low", impact set to "low", caller_id set to "USER_080", assigned_to set to "USER_004", assignment_group set to "GROUP_002", and channel set to "self-service".

Finally, send a notification for the newly created tracking incident to email jose.roberson@servicenow.com with subject "KB Review Complete: VPN Article Update Required - Q4 2024" and message "The knowledge base effectiveness review for Q4 2024 has been completed. KB_003 VPN Error 412 article has been identified for improvement based on incident usage analysis. A collaborative review document with comments has been published to Google Drive. Please coordinate with the knowledge management team to update the article content and troubleshooting steps." using type "update" and status "queued" for organization ORG_001.

Available tools:
update_files
create_incident
send_notification
find_incident_knowledge_links
list_drives
retrieve_knowledge_articles
create_file
create_comments
find_incident_by_number
get_about

Verification checks:
[{"verifier_type": "database_state", "name": "KB Effectiveness Review Document Created", "description": "Verifies that KB Effectiveness Review Document Created", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS doc_count FROM files WHERE name = 'KB-Effectiveness-Review-Q4-2024' AND mime_type = 'application/vnd.google-apps.document' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Document Description Contains KB Analysis Data", "description": "Verifies that Document Description Contains KB Analysis Data", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS kb_count FROM files WHERE name = 'KB-Effectiveness-Review-Q4-2024' AND description LIKE '%KB_003%' AND description LIKE '%INC-000002%' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Document Description Contains Storage Quota Information", "description": "Verifies that Document Description Contains Storage Quota Information", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS quota_count FROM files WHERE name = 'KB-Effectiveness-Review-Q4-2024' AND description LIKE '%Storage Quota%' AND description LIKE '%Q4 2024%' AND trashed = false", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Collaborative Review Comment Created on Document", "description": "Verifies that Collaborative Review Comment Created on Document", "gym_name": "gym-google-drive-mcp", "validation_config": {"query": "SELECT COUNT(*) AS comment_count FROM comments c JOIN files f ON c.file_id = f.id WHERE f.name = 'KB-Effectiveness-Review-Q4-2024' AND c.content LIKE '%REVIEW REQUIRED%' AND c.content LIKE '%KB_003%'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "KB Improvement Tracking Incident Created", "description": "Verifies that KB Improvement Tracking Incident Created", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS incident_count FROM incident WHERE short_description = 'KB Improvement Action - VPN Error 412 Article Update Required' AND category = 'inquiry-help'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Tracking Incident Assigned to Correct Group", "description": "Verifies that Tracking Incident Assigned to Correct Group", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS assign_count FROM incident WHERE short_description = 'KB Improvement Action - VPN Error 412 Article Update Required' AND assignment_group = 'GROUP_002' AND assigned_to = 'USER_004'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": "Stakeholder Notification Created with Correct Subject", "description": "Verifies that Stakeholder Notification Created with Correct Subject", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS notif_count FROM notification WHERE subject LIKE '%KB Review Complete%' AND subject LIKE '%VPN Article Update%' AND type = 'update'", "expected_value": 1, "comparison_type": "equals"}}, {"verifier_type": "database_state", "name": " Notification Sent to Correct Admin Email", "description": "Verifies that  Notification Sent to Correct Admin Email", "gym_name": "gym-itsm-mcp", "validation_config": {"query": "SELECT COUNT(*) AS email_count FROM notification WHERE email = 'jose.roberson@servicenow.com' AND subject LIKE '%KB Review Complete%' AND status = 'queued'\n", "expected_value": 1, "comparison_type": "equals"}}]