Overview
Go beyond simple spreadsheet lookups. This agent analyzes your Google Sheets data to answer complex questions like "Which spreadsheets have the most outdated data?" or "What patterns are we seeing in spreadsheet usage?"
**Capabilities:**
- Analyze spreadsheet usage patterns and identify data quality issues
- Surface spreadsheet activity trends and identify collaboration patterns
- Compare spreadsheet performance across teams and projects
- Identify spreadsheet management optimization opportunities
- Synthesize insights from spreadsheets, rows, and spreadsheet activity
[{"type": "user", "content": "Which Google Sheets have the most outdated data? We need to identify spreadsheets that may need updates or consolidation to ensure data accuracy."}, {"type": "thinking", "content": "Analyzing spreadsheet data freshness...", "thinkingSteps": ["Retrieving spreadsheet data from Google Sheets...", "Calculating last modified dates by spreadsheet...", "Identifying spreadsheets with outdated data...", "Comparing to data freshness standards..."]}, {"type": "assistant", "content": "I analyzed your Google Sheets data and identified spreadsheets with outdated information:\n\n## Spreadsheet Data Freshness Analysis\n\n| Category | Total Sheets | Outdated (>30 days) | % Outdated | Primary Issue |\n|----------|--------------|---------------------|------------|---------------|\n| Project Tracking | 45 | 18 | 40% | Completed projects |\n| Budget Reports | 32 | 8 | 25% | Quarterly updates |\n| Team Rosters | 28 | 4 | 14% | Normal |\n| Analytics | 24 | 3 | 13% | Good |\n\n## Key Findings\n\n**Outdated Data:** **Project Tracking** spreadsheets have 40% outdated (18 of 45). 12 spreadsheets are from **completed projects** that haven't been archived. These spreadsheets contain data that's 60-120 days old, but teams still reference them for current project status, causing confusion.\n\n**Pattern Identified:** Spreadsheets with >60 days since last update have 2.2x higher data accuracy issues (teams make decisions based on outdated information). Project Tracking outdated spreadsheets average 85 days since last update.\n\n**Secondary Issue:** **Budget Reports** have 25% outdated. 8 spreadsheets are updated **quarterly** but are used for monthly budget reviews, causing teams to work with 1-2 month old data.\n\n**Impact:** Outdated spreadsheets cause decision-making errors - teams reference old data for current planning, leading to misaligned expectations.\n\n**Recommendation:**\n1. Archive completed project sheets - move 12 inactive project spreadsheets to archive folder\n2. Update budget report frequency - change quarterly reports to monthly updates\n3. Implement data freshness alerts - notify owners when spreadsheets haven't been updated >30 days\n\n<ENTITY_ANNOTATION id=\"CATEGORY-project-tracking\" title=\"Project Tracking Spreadsheets\" integrationType=\"GOOGLE_SHEETS\" />\n\n<CTA label=\"View All Spreadsheets\" action=\"Show all spreadsheets with data freshness metrics\" />\n<CTA label=\"Generate Cleanup Plan\" action=\"Create a spreadsheet management optimization plan\" />"}]
