Automated Weekly Client Report

ResultTurned 12 logged tasks into a formatted weekly report with hours, results and amount due in one click

My work log becomes a clear weekly report for the client, with an AI summary, next week's plan and the amount due.

The task: Clients want to know what their VA did each week, and weekly payment should be simple and transparent.

What I built:

A Work Log where I record each task: date, category, time, status and result
Every Friday, or in one click, it creates a formatted report: hours worked, tasks completed, time by category and results
AI writes a short summary of the week using only the real numbers from the log, plus next week's plan from tasks still in progress
The amount due is calculated from hours × rate
The report is saved as a Gmail draft for review, and every report is kept in a history sheet

The result: In the demo, 12 logged tasks became a professional report showing 8.17 hours, 10 completed tasks and the amount due, in one click.

Built with Google Apps Script. If a client prefers n8n, Zapier or Make, I can build the same workflow on their paid plan.

The work

1 of 2
Demo: I add a week of tasks to the Work Log and click "Create this week's report". A formatted Gmail draft appears with hours worked, tasks completed, an AI summary, next week's plan, and the amount due.
Full size
2 of 2