How to Make a Timesheet from Google Calendar (Step by Step)
Turn Google Calendar events into a timesheet in Google Sheets: export with a free script, round to billing increments, total by client. Plus a faster way.
To make a timesheet from Google Calendar, pull your events into Google Sheets, work out each event's length, round it to your billing increment, then total the hours by client. Google Calendar has no "export to Sheets" button, so the most reliable free method is a short Apps Script, which takes about 15 minutes to set up the first time.
This guide walks through that method step by step. At the end is a faster way that skips the spreadsheet entirely.
What you need before you start
- A Google account with your work sessions in Google Calendar.
- A blank Google Sheet.
- Your hourly rate and billing increment (for example 6, 15 or 30 minutes).
- A way to tell clients apart: their email domain, a word in the event title, or an event colour.
The last point matters most. If your events say "Meeting" with no attendee, no spreadsheet can work out who to bill.
Step 1: Pull your calendar events into Google Sheets
Google Calendar can export a .ics file, but it isn't spreadsheet-friendly. A script that reads your calendar and writes rows to a sheet works much better.
- Open a new Google Sheet and name it, for example "Timesheet October 2026".
- Go to Extensions > Apps Script.
- Delete the sample code and paste the script below.
- Change the two dates to the period you want to bill.
- Click Save, then Run.
- Approve the permission prompt. The script needs to read your calendar and edit this sheet.
function listEvents() {
const sheet = SpreadsheetApp.getActiveSheet();
const start = new Date(2026, 9, 1); // 1 October 2026 (months start at 0)
const end = new Date(2026, 10, 1); // 1 November 2026
const events = CalendarApp.getDefaultCalendar().getEvents(start, end);
const rows = [['Date', 'Title', 'Start', 'End', 'Minutes', 'Guests']];
events.forEach(e => {
if (e.isAllDayEvent()) return; // skip all-day events
if (e.getMyStatus() === CalendarApp.GuestStatus.NO) return; // skip declined meetings
const mins = (e.getEndTime() - e.getStartTime()) / 60000;
const guests = e.getGuestList().map(g => g.getEmail()).join(', ');
rows.push([e.getStartTime(), e.getTitle(), e.getStartTime(), e.getEndTime(), mins, guests]);
});
sheet.getRange(1, 1, rows.length, rows[0].length).setValues(rows);
}
Switch back to the sheet. You'll see one row per event, with columns A to F filled in. Recurring meetings appear as separate rows, one per occurrence.
The script skips all-day events (holidays, "working from home") and meetings you declined. Neither should be billed.
Step 2: Tag each event with a client
Add a heading "Client" in column G. Then match each row to a client using the guest emails or the title.
In G2, use a formula like this and fill it down:
=IFS(ISNUMBER(SEARCH("acme.com", F2)), "Acme",
ISNUMBER(SEARCH("Smith", B2)), "Smith tutoring",
TRUE, "")
This says: if a guest's email contains "acme.com", the client is Acme. If the title contains "Smith", it's Smith tutoring. Otherwise leave it blank.
Add one line per client. Rows left blank are personal or unbillable, so check them quickly before moving on.
Step 3: Round to your billing increment
Most hourly billers round each session, not the monthly total. Add these headings and formulas, then fill them down:
| Column | Heading | Formula (row 2) | What it does |
|---|---|---|---|
| H | Billed minutes | =CEILING(E2, 15) | Rounds up to the next 15 minutes |
| I | Hours | =H2/60 | Converts to decimal hours |
| J | Amount | =I2*120 | Multiplies by an A$120 hourly rate |
Change 15 to your own increment. Use =MROUND(E2, 15) instead if you round to the nearest increment rather than up.
Format column J as currency with Format > Number > Currency.
Step 4: Total the hours by client
Add a small summary on a second tab, or to the right of your data.
- List each client name in one column, for example L2:L4.
- In M2, total their hours:
=SUMIF(G:G, L2, I:I) - In N2, total their amount:
=SUMIF(G:G, L2, J:J) - Fill both formulas down.
A pivot table does the same job. Select your data, choose Insert > Pivot table, put Client in Rows, and Hours and Amount in Values.
A worked example
Here are three October sessions at A$120/hour, billed in 15-minute increments:
| Date | Title | Minutes | Client | Billed minutes | Hours | Amount |
|---|---|---|---|---|---|---|
| 14 Oct | Acme weekly sync | 50 | Acme | 60 | 1.00 | A$120 |
| 15 Oct | Smith tutoring | 45 | Smith tutoring | 45 | 0.75 | A$90 |
| 16 Oct | Acme design review | 20 | Acme | 30 | 0.50 | A$60 |
The summary shows Acme at 1.5 hours (A$180) and Smith tutoring at 0.75 hours (A$90).
Note the 50-minute sync. Rounded up to 15-minute increments, it bills as a full hour: A$120.
Common problems and fixes
- Events show the wrong time. Check File > Settings > Time zone in Sheets and in Apps Script (Project Settings). Both should match your calendar.
- Some meetings are missing. The script reads your default calendar only. For another calendar, replace
getDefaultCalendar()withgetCalendarById('your-calendar-id'). You'll find the ID in that calendar's settings. - Clients can't be matched. Start adding the client as a guest or putting their name in the title. A colour per client also works;
e.getColor()returns it in the script. - Hours were billed twice. Spreadsheets don't track what you've already invoiced. Add an "Invoiced" column and mark rows by hand after each invoice.
Manual spreadsheet vs timer apps vs Clockless
Each approach suits a different way of working.
| Option | Good at | Trade-off |
|---|---|---|
| Google Sheets + script | Free, fully customisable, you own the data | Setup per period, formulas to maintain, no tracking of invoiced hours |
| Toggl, Clockify, Harvest | Strong timers, detailed reports, team features | You start and stop a timer, which is easy to forget |
| Clockless | Works straight from your calendar, no timer | Google Calendar only; no phone app |
Timer apps are a good fit if your work isn't already in your calendar. If your sessions are scheduled there anyway, a timer means recording the same time twice.
The faster way: Clockless
Clockless turns your Google Calendar events into billable hours, timesheets and invoices. There's no timer and no spreadsheet to build.
Here's how the steps above map across:
- Pulling events. Clockless reads your calendar directly. All-day events and meetings you declined are skipped automatically.
- Tagging clients. You set matching rules once per client: an attendee's email domain (like acme.com), a word in the event title, or the event colour. You can change the rules at any time.
- Rounding. Each meeting is rounded to your billing increment, such as 6, 15 or 30 minutes.
- Totalling and exporting. Clockless exports it as a CSV.
It also handles the step after the timesheet. Pro creates invoices in any currency, including Australian tax invoices with your ABN and GST. Once hours are invoiced, they're marked so nothing is billed twice.
If you issue tax invoices, the ATO's tax invoice page lists what they must show. Only GST-registered businesses issue a "tax invoice".
What it costs
- Free: 2 clients, this week and this month, timesheet export.
- Pro: A$11 a month or A$99 a year. Unlimited clients, any period including past months, PDF tax invoices, tracking of invoiced hours, and multiple calendars (Chrome extension only). Cancel any time.
Privacy
Clockless has read-only access to your calendar. All the work happens in your browser or your own Google account. Your events are never copied to Clockless's servers, because there aren't any.
Clockless is free on the Chrome Web Store: two clients and your first invoice, no card needed.
Questions
Can Google Calendar export straight to Google Sheets?
No. Google Calendar only exports .ics files, which don't open neatly in Sheets. An Apps Script like the one above, or a tool such as Clockless, bridges the gap.
Will the script change or delete my calendar events?
No. It only reads events and writes rows to your sheet. Google will still ask you to approve calendar access the first time you run it.
How do I bill a 50-minute session in 15-minute increments?
Rounded up, 50 minutes becomes 60 minutes, which is A$120 at A$120 an hour. Rounded to the nearest increment with MROUND, it becomes 45 minutes (A$90), because 50 is closer to 45 than to 60. Pick one rule and apply it consistently.
Does this work with Outlook or Apple Calendar?
The script works with Google Calendar only, and so does Clockless. If you use another calendar, you'd need to sync it to Google Calendar first or use a different method.
Can I make a timesheet for a past month?
Yes. In the script, change the start and end dates to any past period. In Clockless, past months are part of Pro; the free plan covers this week and this month.