Google Sheets - Use Apps Script to Create Google Calendar Events Automatically

How to add events to a Google Calendar and email guests all from a Google Sheet using Apps Script and a button.

We receive commission on purchases made through some links on this page
_______________________________________________
🎓Software Recommendations:

_______________________________________________
🎓Data Course Suggestions: (coursera)

_______________________________________________
🎓AI Course Suggestions: (coursera)
_______________________________________________
🖥️ Office items I can't live without:
_______________________________________________
📲 Find me
_______________________________________________

⌚Chapter Time Markers:

00:00:00 - Intro
00:00:42 - I'm Eamonn. You're awesome
00:00:54 - Time in Google Sheets
00:01:07 - Dropdown Times
00:03:08 - Combine Date and Time
00:04:17 - Create a Calendar
00:04:44 - Apps Script
00:06:19 - For Each Loop
00:08:30 - Run Function with Button
00:09:44 - Optimize Columns

=============================
#googlesheets #spreadsheets #dataanalytics #googlecalendar #appsscript

[EamonnCottrell]

And, I've added an IF statement since recording the video that allows you to check the box in column H if an event is already created in your calendar so that running the script multiple times doesn't create duplicate events.

[AnneJoy-pk]

I was actually searching for this! Thank you so much.

[pixachuchu]

Hi! do you have a way were I can add another column for Calendar Description and what code to use for that? Thank you so much!

[NathaniaJo_ID]

this is what i am looking for. thank you very much!

[MURID-adisandy]

Thank you very much. Could you create a video on updating calendar data from a spreadsheet, or perhaps provide some related information?

[OffScore.Warwick]

hello! from 5:03 in the video, for some reason the variable "events" keeps coming up as "undefined" when i've tried to do the exact same thing with code. it also says that line 2 "is not a function".
is there a way that this could be fixed? i'm new to coding so i'm not really sure what i'm doing hahah.
aside from this, this is a very helpful video; thank you!

[SanOscar]

Great tutorial! F finally I have a real solid explanation under it time format! Thanks I have subscribed.

[Thizizparadize]

Thanks for the video! Can you please make one on adding descriptions please!

[Alesas]

I've created the google sheet and script from scratch following your guide. I am in the UK so tiem and date format are set for me. Every time I run the script it inputs the the date as though it is American instead of UK format. If I have the time set to 15:00 Pm it also puts the time in around 10/11am :S Any ideas how I can fix this? Cheers.

[willhennegan]

Great information! However, I’m trying to set up the time in your sheets to include thirty minutes increments. Example, if an event starts at 4:30 opposed to 4pm. How can I change this to have it work? Thanks

[torinodiscovery]

THANK YOU!!!! I only have one question: I have added the advanced parameter description, but ideally I would need to populate the calendar field with the content of more that one cell per row, do you think it's possible? Anyways thanks, this is an awesome tutorial!!

[pun]

Thanks a lot for the script. It is a really helpful tutorial!!

[RegieBenavidez-ug]

thank you so much for this. i just have one question. do you have another video how to create calendar events everytime a new line/row is created in google sheets?

[itsjzpa]

Thank you for this one truly helpful. Btw, is there any update regarding how to add description? Looking forward to hear from you! Cheers! 🍻

[ianpaul]

Is there a way to script that if an event time is say 7 AM- 5PM to have Google Calendar automatically check mark the "ALL Day" indicator in google calendar?

Secondly is there a way to create and "edit" button so that you can edit the Column details in your spreadsheet and then run a button to just edit the details within the "event" on the google Calendar?

[WilliamVanner]

Hopefully one last question! I changed the named range for the event and it created the events on the calendar but it didn't send any of the invites past the initial range any idea why that would be?

[adrianachong]

Hi. Not sure if youre still replying.

Is it possible to add new events as time goes on, and to use multiple sheets in the same spreadsheet?

[muthiahanif]

thanks for the video! i can run it but still cannot to send the invitation, how to send it?

[TaavoKuutan]

Okay, I got it working. Do you think its possible to add more info to the newly created events...for example adding an address in the Google Sheet, and the location is in the event on the Calendar, via Google Maps?

[AlbaÅhlander]

Hey Eamonn! Do you got a minute to spare and perhaps can help me? I've been sitting for hours trying to get it right and also trying different codes. Everything in AppScript is running smoothly, however NOTHING is showing on my calendar... Do you maybe got and idea of whats up?