Sync appointments from Google Sheets to Google Calendar
For salons, clinics, tutors, studios and anyone who takes bookings in a spreadsheet.
A spreadsheet is a fine booking book: everyone can edit it, formulas count the week's revenue, and it costs nothing. The trouble starts when the calendar has to match it. Somebody reschedules in the sheet, nobody updates the calendar, and two clients turn up at 10:00.
The fix is to make the sheet the source of truth and let the calendar follow it.
A sheet layout that works
| Client | Service | Date | Time | Duration | Staff email | Cancel |
|---|---|---|---|---|---|---|
| Ayşe Demir | Haircut | 12.11.2026 | 10:00 | 45 | elif@salon.com | |
| Mehmet Kaya | Colour | 12.11.2026 | 11:00 | 90 | can@salon.com | yes |
| Zeynep Ak | Physio | 13.11.2026 | 09:30 | 1 h |
- One row per appointment. Keep row 1 for column names.
- Date and time in separate columns is easiest to type. A single date-time cell works too.
- Duration in minutes (
45), hours (1 h) or1:30, or an end time column instead. - Cancel instead of deleting the row, so the history stays in the sheet.
- Staff email as a guest if each person should see their own bookings in their calendar.
Setting up the sync with Rowdate
- Extensions › Rowdate › Open Rowdate, then pick the calendar (a shared "Bookings" calendar works well).
- Title:
{{Client}} · {{Service}}. Date, time and duration are matched from the headers above. - Map Cancel and, if you like, Guests to the staff email column. Tick "Email invitations to guests" only if you want them to get an email.
- Sync all rows.
From then on:
- Reschedule: change the date or time in the row and sync. The same event moves; the old slot is freed.
- Cancel: write
yesand sync. The event is deleted, the row stays. - New booking: add a row and sync. Unchanged rows are skipped, so it is quick.
- Live sync (Pro): every edit you make in the sheet updates the calendar within seconds, without pressing Sync.
Good to know
- The sheet wins. If someone deletes the event in Calendar, the next sync creates it again from the row. Use the cancel column to remove it.
- Rowdate only touches the events it created from your rows. Your other events are never read.
- Your data stays in your spreadsheet and your calendar. Rowdate runs inside Google Apps Script and has no servers of its own.
- Reminders: map a column with minutes (
30) to get a reminder before each appointment.
Try Rowdate
100 events a month are free. Pro adds unlimited events and live sync for $5 a month, $39 a year or $79 once.