Sheets2GCal is an add-on for Google Sheets to allow fast event creation in Google Calendar
To get started please install the extension then open any sheet and authorize modifications to your calendars by opening Sheets2GCal in the "Add-ons" menu.
Before using Sheets2GCal please ensure that you have the correct headers. You must have at least the following columns in the first row of your spreadsheet: 'Start' and 'End' as full dates (with date and time), and 'Title'. However, the preferred method is to use both Date and Time columns as per the Sheets2GCal Template provided here:
For the best results, please make a copy (file menu -> copy...) of the official Sheets2GCal Sheet at the link above which is set up with the correct column headers, formatting and data validation. Once you have copied the template you can change the Spreadsheet Locale and Timezone settings to fit your data and Calendar Timezone., and change the formatting of the Date columns (Start, End), the locale and the spreadsheet timezone to suit your requirements. You may also use your own Sheets if the first row contains the correct column headers as explained in the Help.
The 'Start' and 'End' columns can be dates complete with day and time, or only the day - in which case you also need 'Start Time' and 'End Time' columns formatted to a 'Time' format. The official sheet uses the custom 24 hour clock HH:MM, but you can also use the standard 'Time' formatting such as 4:00:00 PM
Sheets2GCal will also process columns called 'Description', 'Location', 'Repeat', 'Interval', 'Count' and 'Guests', if present. The 'Repeat' column should contain either 'daily', 'weekly', 'monthly' or 'yearly', and the 'Count' column the number of times to repeat the event. If no repeat type is specified a daily repeat will be created as long as Count is greater than 0. Specify an integer x in the 'Interval' column to set a repeat every x days, weeks, months or years.
Add a list of emails separated by commas in the 'Guests' field and these will be added to the event. Don't forget to check the "Send Invitations" checkbox if you want invitations sent (future events only).
Sheets2GCal does not store any personal information and uses only the official Google API and OAuth authorization to access your calendars. Your email address will not be shared with 3rd parties, and you will not receive any promotional emails. Authorization for Sheets2GCal can be revoked at any time in your Google Account Settings at https://myaccount.google.com/permissions.
Sheets2GCal is provided free of charge, and the developer may not be held responsible for any problems caused directly or indirectly by the software. For additional help please contact use the Chrome Web Store comments section, or buy a support licence on the support site at the link provided.