Clockless / Guides

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

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.

  1. Open a new Google Sheet and name it, for example "Timesheet October 2026".
  2. Go to Extensions > Apps Script.
  3. Delete the sample code and paste the script below.
  4. Change the two dates to the period you want to bill.
  5. Click Save, then Run.
  6. 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:

ColumnHeadingFormula (row 2)What it does
HBilled minutes=CEILING(E2, 15)Rounds up to the next 15 minutes
IHours=H2/60Converts to decimal hours
JAmount=I2*120Multiplies 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.

  1. List each client name in one column, for example L2:L4.
  2. In M2, total their hours: =SUMIF(G:G, L2, I:I)
  3. In N2, total their amount: =SUMIF(G:G, L2, J:J)
  4. 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:

DateTitleMinutesClientBilled minutesHoursAmount
14 OctAcme weekly sync50Acme601.00A$120
15 OctSmith tutoring45Smith tutoring450.75A$90
16 OctAcme design review20Acme300.50A$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

Manual spreadsheet vs timer apps vs Clockless

Each approach suits a different way of working.

OptionGood atTrade-off
Google Sheets + scriptFree, fully customisable, you own the dataSetup per period, formulas to maintain, no tracking of invoiced hours
Toggl, Clockify, HarvestStrong timers, detailed reports, team featuresYou start and stop a timer, which is easy to forget
ClocklessWorks straight from your calendar, no timerGoogle 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:

  1. Pulling events. Clockless reads your calendar directly. All-day events and meetings you declined are skipped automatically.
  2. 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.
  3. Rounding. Each meeting is rounded to your billing increment, such as 6, 15 or 30 minutes.
  4. 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

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.