Rowdate

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

ClientServiceDateTimeDurationStaff emailCancel
Ayşe DemirHaircut12.11.202610:0045elif@salon.com
Mehmet KayaColour12.11.202611:0090can@salon.comyes
Zeynep AkPhysio13.11.202609:301 h

Setting up the sync with Rowdate

  1. Extensions › Rowdate › Open Rowdate, then pick the calendar (a shared "Bookings" calendar works well).
  2. Title: {{Client}} · {{Service}}. Date, time and duration are matched from the headers above.
  3. 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.
  4. Sync all rows.

From then on:

Good to know

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.

Install Rowdate free Setup guide Pricing

More guides