HourLane changelog

Version 1.0 · November 2026 · first release (not on the Marketplace yet)

• First version: a Google Sheets™ add-on that turns Google Calendar™ events into a timesheet. Open it from Extensions → HourLane → Open HourLane, or refresh straight from Extensions → HourLane → Refresh the timesheet.
• The Timesheet tab: one row per event with Date, Start, End, Hours, Client, Event, Calendar, Billable, Notes, Amount (Pro), Attendees, Location and a link to the event, plus one hidden column HourLane uses to recognise each event.
• Calendars and period: any calendar in your list that you can see the details of; this week, last week, this month, last month, the last 30 days or custom dates of up to a year. Times are in your main calendar’s time zone. Recurring events give one row per occurrence.
• Which events count: all-day events and events you declined are skipped (both can be switched off); cancelled and zero-length events are always skipped; an optional “Only events containing” filter.
• Rounding of each entry: exact minutes, or 6, 10, 15, 30 or 60 minutes, to the nearest step or always up.
• Clients: rules first (title contains, calendar is, guest email domain is, event colour number is), then a tag in the title, [Acme] Design review or Design review #acme (the tag is taken out of the Event column), then the default client, “Unassigned” unless you name one. A tag takes the spelling of the same client in the Rates tab.
• Refresh is a running log: rows outside the period stay; rows inside are replaced from the calendar. Billable, Notes, a client you changed by hand and hours you corrected are kept.
• The Summary tab: hours and billable hours per client and month.
• Free: manual refresh as often as you like, every calendar you can see, rules, tags, rounding, the Timesheet and Summary tabs. No plan limit on events.
• Pro ($4.99 a month or $39 a year): the Rates tab (client, hourly rate, currency, email for statements) and an Amount for every billable entry and in the Summary; statements per client and month as a tab or an email with a CSV file; Refresh the timesheet every morning; on the 1st, last month’s statements emailed to you and, if you choose, to each client. Pro switches on by itself in the open panel after payment; Already paid? Activate for another checkout email.
• Several editors: one setup per spreadsheet, shared by everyone who opens HourLane in it; each person reads their own calendars when they press Refresh; automatic refresh runs from the one account that switched it on.
• Disconnect this spreadsheet and Erase my data.