Templates › Shift schedule
Put your Google Sheets shift schedule in Google Calendar
Keep planning the rota in a spreadsheet. Calendrow turns each shift into a calendar event, updates it when you move a shift, and handles shifts that end after midnight.
Who it's for: Store, restaurant, clinic and warehouse managers who plan shifts in a sheet and want staff to see them in Google Calendar.
The template
| Shift | Start | End | Employee | Location | Notes |
|---|---|---|---|---|---|
| Open – Alex | 2026-12-07 07:00 | 15:00 | Alex | Main St store | Count the safe |
| Mid – Priya | 2026-12-07 11:00 | 19:00 | Priya | Main St store | |
| Close – Sam | 2026-12-07 15:00 | 23:00 | Sam | Main St store | Lock up |
| Night – Jordan | 2026-12-07 22:00 | 06:00 | Jordan | Warehouse | Overnight |
| Open – Alex | 2026-12-08 07:00 | 15:00 | Alex | Main St store |
After making a copy, check the time zone: File → Settings → Time zone. A copy keeps the template's zone (US Central), and Calendrow reads times in the sheet's zone. CSV: in Google Sheets choose File → Import → Upload, then "Replace spreadsheet". Dates use the YYYY-MM-DD format, which Sheets reads as real dates in any locale.
Set it up in 3 minutes
- Open your sheet (or the template) and choose Extensions → Calendrow → Open Calendrow.
- Match the columns:
Calendrow field Column Title Shift Start Start End End (a time is enough) Location Location Description Notes - Create a calendar for it (Calendrow suggests a name), click Preview, check the times, then Sync.
Every row gets a status: Created, Updated, Unchanged, Skipped or Error, with a plain-English reason. Sync again any time; changed rows update their events and nothing is duplicated.
Tips
- Overnight shifts: if End is only a time (like 06:00) and it is earlier than Start, Calendrow ends the event the next morning.
- Put the name in the title ("Close – Sam") so everyone can scan the calendar. A formula like
=B2&" – "&D2builds it for you. - Share the calendar with your team: in Google Calendar, open the calendar's settings and add people under "Share with specific people". Give them "See all event details" so they can't change shifts there; the sheet stays the source of truth.
- Swapped a shift? Edit the row and sync again. The existing event moves; nothing is duplicated.
Questions
Can each employee get only their own shifts?
Not in the free version: one sheet tab syncs to one calendar. A simple workaround is one tab per person (a FILTER formula can build it) synced to its own calendar. Routing rows to different calendars by a column value is planned for Calendrow Pro.
What happens when I delete a shift row?
The event stays in the calendar for now. Delete it in Google Calendar, or wait for the opt-in cleanup of events whose rows were deleted, planned for the next free update.
Does it handle daylight saving?
Yes. Times are read as the wall-clock time in your spreadsheet's time zone, so a 7:00 AM shift stays at 7:00 AM on both sides of the clock change.
Launching on the Google Workspace Marketplace in November 2026.
More: all templates · guides