Cellendar · Google Sheets™ add-on
Beta · Coming soonYour spreadsheet rows, as calendar events. Kept in sync.
Cellendar turns the rows of your Google Sheets™ spreadsheet into Google Calendar™ events, then keeps them matched: new rows become events, edited rows update them, and rows you mark for deletion remove them. No template to copy, no duplicates.
What it does
Built for sheets that people actually edit
-
Works with your sheet as it is
Point Cellendar at your existing columns. It suggests a mapping from your headers (Title, Start, End, Location, Guests and more) and you can change any of it. It doesn't clear your sheet or make you copy a template.
-
Check before anything is written
Before each sync you see what will happen: how many events will be created, updated, deleted or left alone, and which rows need attention, with a button that jumps to the row.
-
A status in every row
A
Sync statuscolumn says what happened to each row in plain words: “✓ Updated”, “⚠ Start date is not a date”. Nothing is skipped silently. -
Real sync, not one-off copies
Edited rows update their events, and a delete marker removes an event while keeping the row. Cellendar notices changed rows by itself, so you don't have to tick “update” boxes. Switch on automatic sync and it runs about a minute after edits, plus hourly.
-
Time zones and all-day events done right
Add an optional time zone column per row; otherwise the spreadsheet's own time zone is used. For all-day events the end date is inclusive: 12–16 means through the 16th.
-
No duplicates, no surprise emails
Running a sync twice, a dropped connection or a double click won't create a second copy of an event. Invitations go to guests only if you turn that on.
-
Safe with several editors
A shared sheet often has more than one editor. The sync belongs to the person who set it up. Everyone else sees who is syncing, and can't accidentally re-create the events from their own account.
Handing it over is a deliberate step: another editor chooses Take over sync, and from then on the sync is theirs.
How it works
Three steps, once
-
Open the add-on
In your spreadsheet, choose Extensions → Cellendar → Set up sync.
-
Confirm the columns and pick a calendar
Check the suggested column mapping and choose the target calendar. No calendar is preselected, so events never land somewhere you didn't choose. You can also create a separate calendar just for these events.
-
Check rows, then apply
Review the summary and apply the changes. Next time, Sync now applies edits straight away, and still stops to ask before deleting anything. Or switch on automatic sync and let it run by itself.
Permissions
Permissions we ask for and why
Google shows a consent screen when you first use Cellendar. Here is every permission on it, in plain language. We chose the narrowest option Google offers for each job.
-
Read and write only the spreadsheet you open it in
To read your rows and write the Sync status column. It cannot open your other files.
Google scope: spreadsheets.currentonly -
See the list of your calendars
So you can choose which calendar to sync to.
Google scope: calendar.calendarlist.readonly -
Create, change and delete events on calendars you own
That is the sync itself. It only touches events that Cellendar created from your rows.
Google scope: calendar.events.owned -
Create a separate calendar and manage its events (optional)
Only if you choose “Create a new calendar” in setup or Settings. Cellendar never deletes calendars.
Google scope: calendar.app.created -
Show a sidebar and dialogs in Sheets
For the setup wizard and the check-before-sync screen.
Google scope: script.container.ui -
Run automatic sync (only if you switch it on)
Lets Cellendar sync about a minute after edits and once an hour. Asked for only when you turn on automatic sync; nothing is scheduled otherwise.
Google scope: script.scriptapp -
Use calendars shared with you (optional, coming soon)
For an upcoming option, “Also use calendars shared with me”. It is asked for only if you turn that option on, and Google shows a separate consent screen at that moment.
Google scope: calendar.events
What we don't ask for
- No access to Gmail.
- No access to Google Drive or your other spreadsheets.
- No full calendar access: Cellendar cannot delete your calendars or change their sharing.
- No Awlware account and no sign-up.
- No contacts, no location.
Where your data goes
Your spreadsheet and calendar contents are processed inside Google's own Apps Script environment. During the beta nothing is sent to us: Cellendar has no server of its own.
Sync settings are saved in the spreadsheet's document properties. They include the email address of the editor who owns the sync, so the sheet's other editors can see who is syncing.
Details are in our Privacy Policy. You can remove access at any time at myaccount.google.com/connections.
Pricing
Free for real use. Pro later, for bigger schedules.
Free during beta
$0
Everything that works today, free while we are in beta.
- Create, update and delete events from your rows
- No row limit during beta (Google's own daily limits still apply)
- Check before sync and per-row status
- Automatic sync: about a minute after edits, plus hourly (you switch it on)
- Column mapping, time zone per row, calendar per row
Pro
Later
More volume and advanced automation, planned after the beta. Everything in the beta stays free, including automatic sync.
- Everything in Free
- More volume and advanced automation
- Planned: import calendar events into a sheet, recurring events
Cellendar is free during the beta and there is nothing to buy yet. If we add a paid plan, its full price will be shown before anyone pays, and features that are free during the beta will stay available in the free plan.
Beta
Join the beta
Cellendar is being tested now. Send us an email and we'll invite you when a place opens. Tell us what you want to sync, so we can make sure it works for your sheet.
Or write to support@awlware.com with the subject “Cellendar beta”. We only use your address to contact you about the beta.