Turn spreadsheet rows into calendar events, and keep them in sync.
SyncRows is an add-on for Google Sheets™. Pick the columns with your dates and titles, and every row becomes an event in a calendar of its own. Change the sheet or the calendar and the other side follows.
Coming soon to the Google Workspace™ Marketplace.
Your sheet
| Date | Shift | Who |
|---|---|---|
| Mon 9:00 | Front desk | Anna |
| Tue 14:00 | Stock | Marc |
| Wed 10:00 | Training | Team |
| Fri 8:00 | Delivery | Laia |
Your calendar
How it works
Set it up once from a sidebar in your sheet. Nothing changes in your calendar until you have seen a preview and confirmed it.
-
Map your columns
Tell SyncRows which columns hold the title, start, end, location, description and guests. It suggests a mapping from your column names.
-
Review the preview
See exactly what will happen before anything is written: how many events will be created, updated or removed, and which rows are skipped and why.
-
Stay in sync
Edit a row and its event updates. Move an event in Google Calendar™ and the row updates (Pro). Every change is logged so you can see what happened.
What SyncRows can and can't access
SyncRows asks for the smallest set of permissions it needs. It works on the sheet you open it in and on the calendars it creates for you. Your other calendars stay out of reach.
| Permission | What it lets SyncRows do | What it does not allow |
|---|---|---|
calendar.app.created |
Can create secondary calendars for your synced sheets, and create, read, update and delete events in those calendars only. | Cannot see, read or change your primary calendar or any calendar it did not create. |
spreadsheets.currentonly |
Can read and write the spreadsheet where you open the add-on, to read rows and store each row's event link. | Cannot open any other file in your Google Drive™. |
script.container.ui |
Can show the SyncRows sidebar and dialogs inside Google Sheets. | Cannot access any data on its own. |
script.external_request |
Can check with the SyncRows licence server whether your account has a Pro plan, using your email address. | Cannot send your sheet or calendar content anywhere. Only your email address is sent. |
Your sheet and calendar data stay inside your Google account. SyncRows does not copy them to its own servers, does not sell data and does not use it for advertising or to train AI models. Read the full privacy policy.
Pricing
The free plan is not a trial. Its limits are listed here and in the add-on, and they do not change after you install.
Free
€0
- 1 synced sheet
- Up to 100 rows per sync
- Sheet to calendar
- Sync when you press the button
- Preview and change log
Pro
€5 per month, or €48 per year
- Unlimited synced sheets
- No row limit beyond Google's daily quotas
- Two-way sync: calendar changes return to the sheet
- Automatic sync on edit and every hour
- Preview and change log