How To Create Google Calendar Events in Google Sheets
Learn how to automate the creation of Google Calendar events directly from Google Sheets using a simple Google Apps Script. This tutorial simplifies the process of managing multiple events by allowing you to send selected rows to your calendar effortlessly.
If we have a series of events and guests, we need to invite to these events and we wanna put them into Google Calendar, but we don't wanna have to do this manually. We want to be able to just select a row, add to Google Calendar and be done with our day. This is going to. Be really awesome for people who are constantly creating weekly events, daily events, monthly events, or you have a number of events that you know you have to put into your calendar at the moment, but you know all the dates, you know all the things. You just have to copy, paste all the information. This video is going to help you even, you don't have to bring out the side panel calendar and add an event there. We will do this all with AB script and it'll be very, very simple once it's all done, and even if you don't want to copy. The app script that I'm doing in this video down below, I'm putting
a link directly to the sheet so you can get this absolutely free. So we're gonna go up to Extension's app script . We have it open already. We're gonna create a function goal called Send to My Calendar. And at the heart of this is a fairly simple piece of code, it's calendar app. Get default calendar, create all day event, and here we're gonna have a few things. We're gonna have a title, we're going to have a date. We have on the same date for the end date . And we're gonna have some options here. We're gonna use JSON, and the very simple thing we need is guests, comma guests. Now this. Second one guess is gonna be a variable. Title is gonna be available. Date is gonna be a variable.
Where is all that coming from? It's coming from our sheet. Whichever row we have selected. If we are on a row or even highlight the whole row , doesn't matter. We know or ab script knows where our cursory and so it's gonna get the entire row if we tell it. So we can do something like spreadsheet app, get active. Range . And here we know what row Get row. So we'll put that in as a variable. Row equals, and now we know what row we're on. We know what sheet we're on. It's always gonna be sheet one. So variable sheet equals spreadsheet . App, get active, spreadsheet , get sheet by name. And here's the name of our sheet.
Sheet one. And so for variable title, it's going to be spreadsheet app, actually sheet that GI Range . The row is gonna be the row we're on. The column is going to be the first column, number one. That's our event name, GI value, that's get value variable. Date is gonna be the exact same thing, except we're going to change it to the second column, right? Because our second column is the date, and I guess it's just gonna be a list of email addresses separated by commas. So we can take this and do variable guess is gonna be that third column. We might have some description as well. Let's put that in. So we need to add comma description, and we'll have a variable called description.
So variable description equals, and we'll get the fourth column here. Now, all of this is fairly simple. Send to my calendar. Whatever is selected, let's run it. We will have to authorize it. Select all , click continue. All I did is delete the second date there. Gave me an error . So we only have one date. Let's see if it added this on June 10th. And here it is, team sync with the A two guests here and with a description, weekly update call. That's pretty cool, right? Very, very simple. But let's make this one step simpler. Not have to come into ABS script and do this line by line. We're gonna create an on open menu that's gonna be able to.
Have us access this from the sheet. So go over to better sheets.co/snippets and we can get a function on open that creates a custom menu . And again, you can get this all here in the sheet down below here on YouTube. Just copy the sheet to your Google Drive. We're gonna call this event menu and we're only gonna need one item, and that's gonna say. Send selected row to calendar. This second part send to my calendar is the function name here, so we'll save that. And all this is doing is on open. We're creating a little menu and I'm gonna show you where that menu is. Let's refresh our sheet and next to the help. Menu up here is the event menu. Send selected road to calendar. So let's select this one and send it and finished.
There it is on the 12th client kickoff. Fantastic. I'm so excited that you were able to watch this and get it and go down below, grab that sheet, get that app script for free. Enjoy. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before. I'm excited to be making a ton more videos here. Ask me questions down in the comments and I will answer them in future videos. But for right now, right here, one of these videos is gonna be your next Google sheet.