Personalized Daily Operations Update for Wes

A general daily operations report can give one manager far more information than they need. Wes needs a focused view of the tasks, decisions, deadlines, and department updates that directly affect his responsibilities.

A scheduled report that retrieves Master Tasks data, filters it by Wes's role, assignments, relevant departments, priorities, and approved reporting rules, then uses OpenAI to draft a concise personalized update. The workflow emails Wes and keeps a copy in Daily Reports.

1. 1Schedule by Zapier — starts the weekday report
2. 2Google Sheets — retrieves current Master Tasks records
3. 3Filter by Zapier — keeps tasks relevant to Wes's role and departments
4. 4Formatter by Zapier — organizes the selected task data
5. 5ChatGPT (OpenAI) — generates a concise personalized update
6. 6Gmail — delivers the report to Wes
7. 7Google Sheets — saves the report in Daily Reports
8. 8No-data and error paths — handle quiet days or delivery failures

• Gives Wes a focused daily view instead of a broad operational dump
• Highlights assigned, urgent, high-priority, and overdue work
• Surfaces missing assignees, decisions, and approvals needing attention
• Shows completed and in-progress responsibilities
• Reduces time spent checking multiple task sheets
• Creates a historical record of personalized reports sent