Hill Country Bots
Google Sheets™ add-on

Sheet Calendar Sync


Create and update Google Calendar™ events from Google Sheets™ rows without duplicates, and export calendar time back to a sheet with hour totals per client.

What it does

If you keep a schedule in a spreadsheet, you already know the busywork. Copy each row into a calendar, hope you did not already add it last week, then later copy the time back out for a timesheet. This add-on does both jobs in the sheet you already have.

Put a Title and a Start in your columns, then run Sync this tab. New rows become Google Calendar™ events. Rows that already have an Event ID are updated, not created again. The Event ID is written back onto the row, along with a Row key stored on the event, so a later run can still match the row if a cell got shuffled. Results stay on your tab. We do not overwrite the rest of your data.

Optional columns cover the rest of a useful event: End, All day, Description, Location, Guests, Color, Recurrence (Daily, Weekly, Monthly, Yearly, or an RRULE), a Google Meet™ link, and Client. Recurring events are created as a series. Changing a series later updates the series, not one single instance. That limit is on purpose in this first version, because single-instance edits are where these tools usually go wrong.

Export calendar to a new tab pulls events in a date range and writes Title, Start, End, Hours, and the rest, plus a second tab of hour totals per client. All-day events count as 8 hours a day, which is the useful number for a timesheet. The add-on defaults to your primary calendar. If you want a shared calendar you can edit, paste that calendar ID in the sidebar.

If you want to see it work on the first try, use Insert sample rows, then Sync this tab.

What it asks permission for

The add-on asks Google for three things only, and only so these features can work:

  • See and edit only the spreadsheet you open it in. It reads the event rows and writes Event IDs, sync status, and export tabs in that same file. It cannot open your other spreadsheets, your Google Drive™, or your Gmail™.
  • View and edit events on calendars you can already access. It creates and updates events from your rows, pulls changes back, and exports events for a timesheet. A read-only calendar permission cannot create or update events, which is the main feature. A permission limited to calendars you own would break syncing to a shared team calendar you can edit. A permission limited to calendars the add-on creates itself could not add events to your primary calendar or export your existing time. The add-on does not ask for the broader permission that can create, delete, or re-share whole calendars.
  • Show a sidebar and a menu under Extensions. That is how you sync, pull, and export. No narrower permission exists for an add-on sidebar.

The add-on does not need permission to reach the open web. If you later buy a plan and enter a license key, the key is sent from your browser to Lemon Squeezy to confirm it is active.

The privacy policy explains this in more detail, including how Google user data is used. The terms cover use of the add-on, pricing, cancellation, and refunds.

Pricing

Free to start, 50 events a month, no card needed. Paid plans are not open yet. When they are, payments will go through Lemon Squeezy. Hill Country Bots is the seller, not Google.

Plan Price What you get
Free $0, no card 50 events a month
Pro $5 a month, or $39 a year 2,000 events a month

Prices were set on November 12, 2026. They will be the total price, including any mandatory tax, once checkout is open.

Support

Questions or a bug? Email [email protected]. We read every message.

Built by Hill Country Bots. Legal name: Jerry N. Wiggins Jr, 4301 Hookbilled Kite Drive, Bee Cave, TX 78738.

Related tools

Google Sheets™, Google Calendar™, Google Meet™, Gmail™ and Google Drive™ are trademarks of Google LLC.