Sync a Google Sheet to Google Calendar, and keep it in sync

If your bookings or deadlines live in a Google Sheet, you can have each row show up as a Google Calendar event, and have the event follow when the row changes.

What you need in the sheet

• A header row, then one booking per row.
• A column for what (a client, class or task) and one for the date.
• Optional: start and end time (or a length in minutes), a place, notes, a contact email, and a status column.

Dates can come from formulas (=B2+7, =TODAY()+1); what counts is the value the cell shows. Without a start time, a row becomes an all-day event.

Steps

1. Install ScheduleRow from the Google Workspace Marketplace, then open your sheet and choose Extensions → ScheduleRow → Open.
2. Connect your Google account once. ScheduleRow makes its own calendar for the tab and can't see your other calendars.
3. Check which column holds what (it guesses from your headers) and the time zone your times are in.
4. Press Save and sync, pick the sheet in Google's file picker, and look at the preview of what it will add. Press Add them to the calendar.

What happens after that

• Edit a row and its event changes within about a minute, whether or not the sheet is open. Sync now in the sidebar does it at once.
• Sort, filter or insert columns: each row keeps its event, and columns are followed by their headers.
• Delete a row, or set its status to Cancelled, and its event comes off the calendar.
• A date ScheduleRow can't read is pointed out with its cell, and that row's event is left as it was.

Common snags

• Events a few hours off: choose your time zone in the sidebar; it's what your times are read in.
• A sheet uploaded from Excel: save it as a Google Sheet first (File → Save as Google Sheets).

Get ScheduleRow on the Google Workspace Marketplace. Free for up to 25 bookings a month, reminders included; Pro is unlimited for $6 a month. Questions? support@schedulerow.com