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 allows you to import up to 5000 events per day, import “changes and new events” 10 times per day and update/delete up to 200 events per day. Any paid subscription allows unlimited Imports and Exports.
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 automatic syncing, edit events in bulk or use formulas to populate or extract calendar data… your imagination is the only limit!
Please use the "Issues" section to report issues with the Google Sheets Add-on Sheets2GCal