💡 New script: cross-app-weekly-review (personal productivity digest across Workspace)

[github-actions[bot]]

Summary

A Google Apps Script that combines signals from Calendar (meetings attended, hours spent), Gmail (emails sent/received, response volume), and optionally Google Tasks (completed/overdue) into a single weekly personal productivity review. Delivered as a narrative email and/or Sheets row for trend tracking. Like a personal standup report that writes itself — no manual time-tracking or journaling required.

Market Signal

Cross-app personal analytics is an emerging category. RescueTime, Clockwise, and Reclaim.ai offer partial views but charge $6-12/month and don't integrate Workspace data holistically. Google Workspace Studio (GA May 2026, 3.5M monthly active users, 170M tasks automated/month) can build cross-app flows but doesn't offer a pre-built personal review template. Gemini Workspace Intelligence (June 2026) integrates Gmail+Drive context but focuses on AI chat, not structured analytics. No open-source tool aggregates Workspace activity into a personal digest. The "weekly review" practice from GTD methodology has millions of practitioners who do this manually.

User Signal

The suite already has forward-looking briefings (calendar-to-briefing-doc) but no backward-looking review. Users deploying multiple scripts (gmail-to-drive + calendar-to-sheets) are already cross-app power users who would value a unified view. The "quantified self" and "weekly review" patterns from GTD/Building a Second Brain methodologies have proven user demand. No existing idea discussion covers cross-app personal analytics.

Technical Opportunity

All required APIs (Calendar, Gmail, Tasks) are already used by existing scripts. The cross-app aggregation pattern would be new to the suite and could serve as a template for future multi-service scripts. Output format options (email via MailApp + Sheets via SpreadsheetApp) are proven patterns. The architecture supports modular data collectors that can be tested independently. Gmail aggregate queries (search with date ranges) return counts efficiently without processing individual messages.

Assessment

Dimension	Score	Rationale
Feasibility	high	All APIs already in use; aggregate queries are lightweight; proven output patterns
Impact	high	Unique cross-app value prop; addresses weekly review habit with zero manual effort
Urgency	med	No direct competitor in the open-source GAS space; Workspace Studio doesn't yet offer this template

Adversarial Review

Strongest objection: Combining multiple API calls in one script increases execution complexity and risks hitting Apps Script's 6-minute execution limit for heavy email accounts.

Rebuttal: The script doesn't need to process individual emails — Gmail API search queries with date ranges return aggregate counts efficiently (e.g., from:me after:2026/08/01 before:2026/08/08 returns a count). Calendar event listing for a single week is lightweight. The execution budget is ample for aggregation queries. If a user's account is exceptionally large, configurable scope limits (specific labels, calendars) provide escape hatches.

Suggested Next Step

Create src/cross-app-weekly-review/ with TDD implementation. MVP scope: Calendar meeting hours + Gmail sent/received counts for the past week, output as a narrative email digest with key metrics. Phase 2: Add Google Tasks integration (completed/overdue counts), Sheets row per week for trend tracking, and configurable sections (enable/disable Gmail, Calendar, Tasks modules independently).