Help & Support
Send Feedback
Sheets2GCal
Sheets2GCal is an add-on for Google Sheets to allow fast event creation in Google Calendar
34,973 users
Works with
Install
Overview
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:

https://docs.google.com/spreadsheets/d/1WakZLLrglkyFokNC8qvG0dhM_qA3US9vI6sw3PiiMak

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).

Privacy

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.

Disclaimer

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.
Reviews
A User of Sheets2GCal
January 27, 2020
How do you change the defaulted email address for the google calendar in the plugin?
Submit reply
Cancel
A User of Sheets2GCal
January 20, 2020
Very nice. It delivers what it says!
Submit reply
Cancel
James V Spring
August 26, 2019
Thank you!!!!! My previous scheduling script just stopped working due to google sunsetting UiApp. I needed to put like 300 events up tonight and you saved me.
Submit reply
Cancel
A User of Sheets2GCal
April 23, 2019
It worked I guess, in a fashion. I spent quite a long time working out how to get the events on the right day, and in the right time slot - including in the expected timezone. :/ Seemed to be expecting UTC+2 or something. It seems to me that there must be a better way.
Submit reply
Cancel
A user of Sheets2GCal
April 26, 2019
Hi Jon, if you have set the correct timezone for both the Sheet and your system correctly events should be created at the right time and day - was that not the case for you?
A User of Sheets2GCal
March 5, 2019
Really helpful but missing the ability to UPDATE an existing Calendar Event. Is that coming anytime soon?
Submit reply
Cancel
A user of Sheets2GCal
May 18, 2019
Yes, this is a work in progress with calendar import to Sheets, and updates from Sheets to Google Calendar - but I'm sorry to say it will not be free.
A User of Sheets2GCal
November 21, 2018
Does a good job uploading events.. Only, it doesn't write the start and end time. Unfortunately all events uploaded events are all day events!
Submit reply
Cancel
A user of Sheets2GCal
April 26, 2019
This is probably caused by incorrect format settings for one or both of the "Start Time" or "End Time" columns which should a time format such as HH:MM - did you use the Template Sheet I provide, or make your own?
A User of Sheets2GCal
October 16, 2018
Needed to schedule 100+ events and putting them in one by one on GCal was a pain. This worked very well. I give it 4 stars because if it had reschdeule columns (mass reschedule events) it would definitely would help more.
Submit reply
Cancel
A User of Sheets2GCal
March 9, 2018
Works great
Submit reply
Cancel
1-8 of 8
Additional information
Search
Clear search
Close search
Google apps
Main menu