Sheets2GCal is a Google Sheets add-on designed for advanced Google Calendar management using spreadsheets. Create or import events in a spreadsheet, edit them in the Sheet and export the changes to Google Calendar, or edit them in Google Calendar and import the changes back to Google Sheets.
A free account is needed to import large calendars, and a paid subscription is required for importing a range of dates instead of entire calendars, to import only changes from Google calendar and for heavy usage.
Import entire calendars with repeat events displayed as a single row with repeat settings, or import a range of dates to show every occurrence within the period. Importing the entire calendar allows you to copy recent changes to Google Calendar into the Sheet to keep them in sync. Set up daily automatic syncing, edit events in bulk or use formulas to populate or extract calendar data… your imagination is the only limit!
To install Sheets2GCal please visit the Google Workspace Marketplace
To install GCalExtras please click here
To download GCalToolkit for Windows, osX and Linux click here
Sheets2GCal Membership
Sign up for a FREE Membership to enable imports from Google Calendar for Sheets2GCal. Free Members can import maximum 5000 events, and make up to 1000 updates/deletes to Google Calendar per day. Please purchase a subscription for unlimited imports/edits, date-range import and importing changes from Google Calendar to Sheets.
S2GCal GSuite Domain / Year
A yearly subscription to Sheets2GCal for your entire GSuite domain. Once subscribed, all your users will be able to use Sheets2GCal with unlimited* event creation/deletes/edits, Google Calendar imports (full and date-range), import changes from Google Calendar to Sheets, and priority email support.
* usage is not restricted by Sheets2GCal but you are still subject to Google's personal quota restrictions
S2GCal GSuite Individual / Year
A yearly subscription to Sheets2GCal for a single GSuite account. Unlimited* event creation/deletes/edits, Google Calendar imports (full and date-range), import changes from Google Calendar to Sheets, and priority email support.
* usage is not restricted by Sheets2GCal but you are still subject to Google's personal quota restrictions
S2GCal Yearly Personal
Save money with a yearly subscription to Sheets2GCal for personal Google accounts only (not GSuite).
unlimited* event creation/deletes/edits, Google Calendar imports (full and date-range), import changes from Google Calendar to Sheets, and standard email support.
* usage is not restricted by Sheets2GCal but you are still subject to Google's personal quota restrictions
S2GCal Monthly Personal
A monthly subscription to Sheets2GCal for personal Google accounts only (not GSuite): unlimited* event creation/deletes/edits, Google Calendar imports (full and date-range), import changes from Google Calendar to Sheets, and standard email support.
* usage is not restricted by Sheets2GCal but you are still subject to Google's personal quota restrictions