How to automatically add a schedule from Google Sheets into Calendar

Everything you need to get anything done, now in one place: introducing Google Workspace, formerly known as G Suite.

Google Workspace Pro Tips are quick tutorial videos to help you automate simple tasks at work. In this video, Google Workspace Developer Advocate, Joanna Smith explains how to automatically add a schedule from Google Sheets into Calendar to make project management easier, and to save you time. This tip introduces Apps Script, an easy-to-use, low-code platform that can help you tailor, and automate different tasks within Google Workspace.

And for coding tips, here are some additional resources:

If you have additional questions, or ideas for future Google Workspace Pro Tips, please leave them in the comments below!

#GoogleWorkspaceProTips
#CustomizingGoogleWorkspace
#GoogleWorkspace

[ARCopros]

Why didn't you put the script and the google sheet in the description to download ?

[dhawalsharma]

Just loved the part where she made it easy for every one to share... And shared the spreadsheet and script with us

[adriennemccue]

Mind-blown! Totally doing this for our nonprofit volunteers! Thanks so much!

[akshaysakure]

Hi Joanna and G-Suite team,
Actually I wanted to use this feature to sync a Project plan in Google sheets to Calendar where I have multiple columns So, Can I add more than 3 columns (as shown in video) ? If yes, can I name them differently than the headers you have given?

[mago]

It would be more simple if you guys have an add on to synch the forms with the calendar, instead of code for every event.

[yikuanho]

This format of video makes it so easy to understand. Thank you so much!

[rbfreitas]

Looking forward to try it out!!! Loved the format! Engaging and easy to follow.

[nmhinton]

Hi, thanks for the video! I'd like to have the (sheets and g-calendar) automated so anytime something is updated on the sheets, it's also updated on the calendar and vice versa. I see it can be customized but is there a way to do it automatically? I'm also curious if I have the locations set with a specified time in different timezones, how can I make that show up on my sheets/caldendar?

[kinectdance]

Is it possible to do the same process in reverse? I want to extract a calendar event/roster but don't want to export the entire calendar. Then use this data in sheets to import it into a doc or PDF

[usernmae]

Is there a link to the coding that she whizzes through? I feel so out of the loop with coding these days I'm a bit shy to ask! I've read the blog post that breaks down the directive for the APP SCRIPT and it's super helpful.

[vincentmarino]

Trying to modify this script so it can be used for lesson planning. Want to be able to type a module #, unit #, start date, end date, lesson description, lesson target into 6 columns on my spreadsheet then run the script to have it show up on my google calendar. Can someone contact me to help me with this or who could I contact for more direct help?
Thanks!

[diamondzieman]

I feel like im watching a tv show. I am a music teacher and I have a full schedule from 8-6pm most days so this really helped lessen the work

[MichaelDaniels]

Also, I have a Sheet one where I have a master schedule where I pull data. is there a way for me to NOT duplicate a calendar event?? I want to run the script but it duplicates as things get added from sheet one. Thank you

[akshaysakure]

I ran the whole thing as specified along with onOpen function. Both of them ran without error but the output didnt get reflected.. Neither the sheet got integrated with Calendar, nor their was a new Menu creation. Can you please help me at this at the earliest?

[hanaanrosenthal]

OMG sweetest how-to tech video I have ever watched!

[Erika-oooi]

Thank you for this! Thinking through our scenario - we have a few dozen people assigning themselves to shifts on the google sheet, who would really only be interested in adding their own shifts on their own google calendars. Any suggestions for this?

[cheswatchdogs]

To coordinate volunteers I have them sign up for slots via Google Forms, The form writes to a sheet that runs THIS Code to populate a calendar with the volunteer dates. I have a Trigger set on "Form Submit" so the calendar updates every time someone completes a form.
However, It seems like this gives up after a while and stops updating after a couple weeks.
When I go in to debug, I run it to test before I make any changes and it starts right back up no issue.

Is there some timeout or other issue with the triggers?

[vasukinagabhushan]

Does this code keep importing new signups into the calendar, as and when they are entered in Google Sheets?

[chrisbetcher]

This is cool, but where do I get the skeleton code from? That seems like the missing bit.

[drone-plus-plus]

Hi Joanna!

Can I access the user's calendar when he edits a cell by a trigger 'onEdit'?
I added a menu with a simple script in 'onOpen' to cause an authorization request, but it does not apply to 'onEdit'.

Thanks.