Make a timesheet from Google Calendar in Google Sheets

Your calendar already knows when you worked. A timesheet is those events, for one week or month, with hours added up.

Steps

1. Export the week or month to a sheet (start, end, title, hours).
2. Round each event the way you bill: up to 15 minutes, for example.
3. Group by day or week with a pivot table.
4. Remove events you declined or never answered.

Google Calendar hours report by client

If you track client work in Google Calendar, you can bill from it. You need a way to tag each event with a client and add up the hours.

Free way

1. Pick a rule: one event colour per client, or put the client name in brackets at the start of the title.
2. Export the events to a sheet with their duration in hours.
3. Add a client column (from the colour or the bracket text).
4. Make a pivot table: rows = client, values = SUM of hours.

Check for overlapping events. Two events at the same time count those minutes twice.

How to export Google Calendar to Google Sheets

Google Calendar has no export to Sheets button. Its built-in export gives you an .ics file, which Sheets cannot open as rows.

Free way: an Apps Script

1. In a new sheet, Extensions > Apps Script.
2. Use CalendarApp.getDefaultCalendar().getEvents(start, end) for the date range you want.
3. For each event, write title, start, end and (end minus start) in hours.
4. Run it and allow calendar access.

Watch time zones: the script uses the script's time zone, which may not match your sheet or calendar.

The tool I made for this

I make and sell Export Calendar to Sheets. Export Google Calendar events to Sheets for any date range you pick. Hours by client or event colour, plus a Review tab that catches billing errors.