End-of-Day Reporting Agent
An automated end-of-day reporting system that consolidates meetings, tasks and notes into a structured daily report, removing the copy-pasting and spreadsheet updates the report used to need.
Every day, as a Gmail draft
Meetings, completed tasks, work in progress, quotes and action items
- Date
- Nov 2025
- My role
- Design and build
- Orchestration
- n8n
- Time zones
- Manila → Pacific
Context
Daily reporting for work done on Manila time and reviewed by management on Pacific Time, with the day's activity spread across calendars, forms, meeting recordings and notes.
The Challenge
The end-of-day report was assembled by hand: copying from calendars and notes, updating spreadsheets, and converting times — administrative work that took time away from the work being reported.
My Role
I designed and built the agent in n8n: task capture, transcript processing, AI summarisation, time-zone handling and the scheduled report.
The Approach
- Centralise every task in one Google Sheet.
- Capture work from where it already happens — calendar, forms and meetings — instead of asking for extra input.
- Let AI handle summaries and task descriptions.
- Produce a draft, not an automatic send, so a person reviews what management sees.
Before and After
Before
- The daily report assembled by copy-pasting from calendars, notes and spreadsheets.
- Meeting outcomes written up by hand.
- Times converted manually from Manila to Pacific for leadership.
After
- Tasks captured automatically from calendar events, forms and meeting notes.
- Recordings turned into structured summaries and management-ready task descriptions.
- Times converted to Pacific automatically.
- A scheduled report lands as a Gmail draft, ready for review and send.
What I Built
Six stages from scattered activity to a review-ready report. Read in order, 01 to 06.
- 01
Capture
Tasks from calendar events, forms and meeting notes collected in Google Sheets.
Google CalendarGoogle Sheets - 02
Process meetings
Recordings and transcripts turned into structured notes and summaries in Docs and Sheets.
AskElephant / FirefliesGoogle Docs - 03
Describe
AI summarises the work and writes management-ready task descriptions.
OpenAIGemini - 04
Normalise
Times converted from Manila to Pacific Time.
- 05
Compile
A scheduled report combines meetings, completed tasks, work in progress, useful quotes and action items.
- 06
Draft
The report lands as a Gmail draft for management review.
Gmail
Continuous sync
Updates from calendars and sheets keep flowing in through the day, so the report is current when it's compiled.
From the build
(opens full size in a new tab)
Outcome
- A manual end-of-day report became a continuously updated workflow.
- Better visibility for management into meetings, progress and next actions.
- Less administrative work for the person reporting.
Technology
- Orchestration
- n8n
- AI
- OpenAI · Gemini
- Meetings
- AskElephant / Fireflies
- Google Workspace
- Calendar · Sheets · Docs · Gmail
Key takeaway
Producing a draft instead of sending automatically keeps a person in control of what management sees, while the system handles the part nobody wants to do: collecting and formatting.