Google Sheets™ add-on · Google Calendar™ timesheets
HourLane — Timesheets from Google Calendar
Your calendar already knows where the hours went.
HourLane reads the calendars you choose and writes one row per event into a Timesheet tab: date, start, end, hours, client and more. The client comes from a tag in the title, such as [Acme], or from your own rules. Refresh any time and your edits stay. With Pro, add hourly rates and email a statement per client every month.
- Timesheet free, refresh as often as you like
- Reads your calendar, never changes it
- No BiLingoPlus server in between
Illustration, not a screenshot: HourLane is not published yet.
How it works
From Google Calendar to a timesheet in three steps
Set it up once per spreadsheet. After that, one press of Refresh brings the timesheet up to date.
1Open it from the Extensions menu
In a Google Sheets spreadsheet: Extensions → HourLane → Open HourLane. The panel opens on the right.
- Work (main)Client projectsFamilyThis month ▾
2Tick your calendars, pick the period
Any calendar you can see the details of. This week, last week, this month, last month, the last 30 days or your own dates.
42 entries · 61.5 h · 4 clientsfor 2026-11-01 – 2026-11-30.
3Press Refresh
Every event becomes a row with its hours and client, and the Summary tab adds them up per client and month.
Clients from the title
Type the client once, in the event, and the timesheet knows it
Put the client in square brackets at the start of the title, or as a #tag anywhere in it. HourLane takes the tag out of the Event column.
From the title rules of HourLane 1.0. “Unassigned” is the default; you can name your own.
- Rules for everything else“Title contains retainer”, “Calendar is Client projects”, “Guest email domain is acme.com” or “Event colour number is 11” → a client. Rules are checked first, in order, then the tag, then the default.
- A refresh keeps your editsMark an entry not billable, add a note, change its client or correct its hours: the next refresh replaces the period from the calendar and keeps those changes.
- A running logRows outside the chosen period stay as they are, so last month is still there after the period moves on.
Features
Made for billing your time
Rounding your way
Keep exact minutes, or round each entry to 6, 10, 15, 30 or 60 minutes, to the nearest step or always up.
Rates and amounts (Pro)
Type an hourly rate per client in the Rates tab. Every billable entry in the Timesheet gets its Amount, and the Summary adds them up per client and month.
| Client | Hourly rate | Currency |
|---|---|---|
| Acme | 120 | USD |
Statements by email (Pro)
One client, one month: a statement tab, or an email to you with a table of dates, work, hours and amounts and a CSV file. On the 1st, HourLane can email last month’s statements to you and to each client.
And more
- This week, last week, this month, last month, last 30 days or custom dates
- All-day and declined events skipped (both can be switched off)
- Only events containing a word, if you like
- Recurring events: one row per occurrence
- Times in your main calendar’s time zone
- Summary tab: hours and billable hours per client and month
- Attendees, location and a link to each event
- Refresh from the Extensions menu, too
Compared
Ways to get calendar time into a timesheet
Scroll the table sideways →
| Way | Client for each entry | When the calendar changes | Rounding | Cost |
|---|---|---|---|---|
| Typing the hours by hand | You type it | You find and fix the row | In your head | Free |
| Export the calendar (.ics) and clean it up | Not in the file | Export and clean up again | Formulas you write | Free |
| Your own Apps Script | Only if you write the code | The script rebuilds the sheet; notes are lost unless you code around it | Only if you write it | Free, plus your time |
| HourLane | From [Client] or #client tags, or your rules | Refresh: the period is replaced, your edits kept | 6, 10, 15, 30 or 60 minutes, nearest or up | Free · Pro $4.99/month or $39/year |
The export and the do-it-yourself script, step by step: how to turn Google Calendar into a timesheet in Google Sheets.
Pricing
The timesheet is free. Pro bills it.
Checkout opens when HourLane launches on Google Workspace Marketplace.
Pro · rates, statements, automatic
or $39 a year · checkout opens at launch
- Hourly rates and an amount for every entry
- A statement per client and month: tab, email and CSV
- Refresh every morning; last month’s statements emailed on the 1st
- Everything in Free
Free
No plan limit on events, and refresh as often as you like.
- Refresh by hand, from the panel or the menu
- Every calendar you can see, rules and [Client] tags
- Rounding to 6, 10, 15, 30 or 60 minutes
- Timesheet and Summary tabs
Pro will be bought inside the add-onPaddle is our Merchant of Record14-day refund on any charge
Privacy & permissions
It reads your calendar and never changes it
| Reads | The calendars you tick, for the period you choose: each event’s title, times, guests and their responses, location, colour and link. And only the spreadsheet you open HourLane in (Google’s “this spreadsheet only” permission). |
|---|---|
| Sends | Event data goes only into your own spreadsheet. Nothing is sent to BiLingoPlus. With Pro, statement emails go out from your own Google account to you and, if you choose, to your clients, and the add-on asks Paddle whether your email has an active subscription. |
| Permissions | spreadsheets.currentonly · calendar.calendarlist.readonly · calendar.events.readonly · script.container.ui · script.scriptapp · script.send_mail · script.external_request · userinfo.email |
Both calendar permissions are read-only: HourLane cannot create, change or delete an event. No ads, no selling of data and no AI reading your calendar.
Full privacy policy →
Made by BiLingoPlus LLC, Wyoming · support from the people who build itQuestions
Questions about calendar timesheets
Does HourLane change my calendar?
No. Its two calendar permissions are read-only: one lists your calendars, the other reads events. It cannot create, change or delete an event, and it writes only into the spreadsheet you use it in.
How are recurring events counted?
Each occurrence is its own row, with its own date and hours, so a weekly call shows up once a week. Cancelled occurrences are left out, and so, unless you switch it off, are the ones you declined.
Which time zone are the times in?
The time zone of your main Google Calendar, the same zone your calendar shows. The spreadsheet’s own time zone setting does not change them.
Can it read several calendars?
Yes. Tick as many as you like from your Google Calendar list: your own, shared and team calendars, any you can see the details of. The Calendar column says where each entry came from.
How does HourLane know the client?
From your rules first (title contains, calendar, guest email domain or event colour), then from a tag in the title, [Acme] Design review or Design review #acme. Anything else goes to “Unassigned”, or to a default client you name.
Will a refresh overwrite what I changed in the sheet?
No. Billable, Notes, a client you changed by hand and hours you corrected are kept. The rest of the period is updated from the calendar, and rows outside the period are not touched.
Is a statement an invoice?
No. A statement is a summary of the hours, and the amounts if you set a rate, for one client and one month. It is not a tax invoice; attach it to your own invoice or send it as it is.
Is HourLane free, and when can I install it?
The timesheet is free, with manual refresh as often as you like. Pro, for rates, statements and automatic refresh, will be $4.99 a month or $39 a year. HourLane is not on Google Workspace Marketplace yet; write to us on the support page to hear when it is.
Guides
Guides for calendar timesheets
Guide
How to turn Google Calendar into a timesheet in Google Sheets
The calendar export, a script you can copy, and an add-on — and what each one leaves you to do by hand.
Read the guide →Help
HourLane setup and troubleshooting
Calendars, periods, rounding, what a refresh keeps and the permissions Google asks for.
Open the help →Help
Clients from tags and rules
[Acme] and #acme in titles, and rules by title, calendar, guest domain or colour.
Open the help →
Get HourLane
Your calendar, already a timesheet.
- Timesheet free, refresh as often as you like
- Reads your calendar, never changes it
- No BiLingoPlus server in between
More tools from BiLingoPlus
Other tools from the same studio
-
Translate Slides with AI
Translate a whole deck into 100+ languages
Google Slides™Free + Premium100 slides free every month · Premium from $9.99/mo billed yearly
-
GridScoop
Export web tables and data grids to Excel & CSV
ChromeFree + Pro300 rows a day free · Pro $15/year
-
Cardwright
Turn highlighted text into flashcards for Anki
ChromeFree + ProFree for 25 cards and 3 decks · Pro $4.99 once
Google Calendar™, Google Sheets™, Gmail™ and Google Workspace™ are trademarks of Google LLC. HourLane is an independent add-on, not made or endorsed by Google.