Internal operations · Reporting

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.

  1. 01

    Capture

    Tasks from calendar events, forms and meeting notes collected in Google Sheets.

    Google CalendarGoogle Sheets
  2. 02

    Process meetings

    Recordings and transcripts turned into structured notes and summaries in Docs and Sheets.

    AskElephant / FirefliesGoogle Docs
  3. 03

    Describe

    AI summarises the work and writes management-ready task descriptions.

    OpenAIGemini
  4. 04

    Normalise

    Times converted from Manila to Pacific Time.

  5. 05

    Compile

    A scheduled report combines meetings, completed tasks, work in progress, useful quotes and action items.

  6. 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

n8n workflow canvas for the End-of-Day Reporting Agent, organised into labelled groups (opens full size in a new tab)
The n8n workflow. Grouped into the daily EOD build, meeting processing, sheet updates and calendar sync. Select the image to open it full size.

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.