Stacix

Sheets Calendar Sync: user guide

Keep a Google Sheet and a Google Calendar in step, both ways. Plan events in rows, see them on your calendar, and when someone moves an event in Calendar the row updates too. Every sync shows you a preview first, and every sync can be undone.

Made by Stacix. Free.

Install

  1. Install Sheets Calendar Sync from the Google Workspace Marketplace.
  2. Open any spreadsheet and choose Extensions → Sheets Calendar Sync → Open sync panel.
  3. Google asks you to allow access the first time. See what the app can access.

Set up a sheet

  1. Choose Extensions → Sheets Calendar Sync → Add sync columns to this sheet. The app adds the columns it needs (Title, Start, End, All day, Location, Description and a few columns it uses to link rows to events). Columns you already have are kept.
  2. In the sync panel, open Settings and enter the Calendar ID to sync with (in Google Calendar: the calendar's Settings and sharing → Integrate calendar → Calendar ID). We suggest a separate calendar (for example "Team schedule") rather than your main one.
  3. Fill in rows: a title and a start time are enough. Dates can be typed the way you normally write them.

Sync

  1. Click Preview. The panel lists every change it would make: events to create, update or remove in Calendar, and rows to update in the sheet. Nothing has changed yet.
  2. Click Sync to apply exactly that list.
  3. Edit either side later and sync again. Changes made in Calendar (a new time, a new location) come back into the row. If the same event changed on both sides, the preview marks it as a conflict; under Settings → Conflicts you choose who wins: the last edit (default), the sheet, or the calendar.

Only events the app created, or rows you linked, are touched. Other events on the calendar are never changed.

Undo

The panel keeps the last 20 syncs under History. Undo reverses a sync: events it created are removed and rows it changed are put back. If a row or event was changed again after that sync, it is left as it is, so newer work is never lost.

Good to know

  • Invitations from other people are shown in the sheet but can't be edited: the app only writes to events on calendars you own.
  • Copies of a spreadsheet start fresh. A copy never changes or undoes the original's events.
  • Shared sheets: the settings belong to the spreadsheet, so every editor syncs with the same calendar. If another editor's sync would point at a different calendar than the rows are linked to, the app stops and changes nothing.
  • The app stores its settings and sync history in a hidden sheet named _stacix_sync in the same spreadsheet. Deleting it resets the app for that spreadsheet.

What the app can access

The app asks Google for three permissions and uses each only as described:

Permission What it is used for
See, edit, create and delete only the spreadsheet you use it in Read your event rows, write back changes from Calendar, and keep its settings in the hidden _stacix_sync sheet. It can't open any other file in your Drive.
Display and run third-party web content in prompts and sidebars inside Google applications Show the sync panel and the Extensions menu inside Sheets.
View, create, update and delete events on calendars you own Create, update and remove the events that come from your rows, and read changes made to those events in Calendar. It can't change calendars you don't own.

Nothing is sent to Stacix or to any other server. See the privacy policy.