eventcal | include attending and maybe facebook events | Calendar library

I am very new to Script editing. I have a Spreadsheet from a source online that I replicated in order to add events for students.

I want to be able to add the Description and then change the event color depending on the class. The script that I am using is copied below. I don't know how to add in the description and color ID for the event.

I wrote this function to bring spreadsheet entries into my calendar. As you see, now I take all entries in the range B5:B30. If I do not fill in all cells in this range, I get an error as my parameters are wrong.

Now if I would be able to only take the values from this range that are not empty, I think all would work. Is there a way to drop empty cells from my range or only execute the getValue() and save it in my definition of signups if there is a value?

I've created a script which loops through each google sheet row and creates a calendar event if the background on a cell in column 5 is = dark yellow 1.

I have the following code for adding Calendar events from Google Sheets, but it is not working. It is not showing any errors or anything, just that it is not updating the Calendar. Any ideas what I might have done wrong? I tried without the "new Date" on the Start and End dates as well.

I am trying to add a custom menu to the google spreadsheet editor's interface to activate 2 scripts.

"scheduleShifts" is running fine, but "clearCalendar" prompted Script function not found: clearCalendar error.

I have tried making some modifications but the same error still appears.

Thank you in advance for all your help.

I managed to get something working where it will take the title and date and put it in the Google calendar but I have to run the script every time. But when I alter a date for an event (dates are always changing) it just makes another event and keeps the old one.

I just want to have a google sheet with titles and dates for when things are happening to be synced up to a google calendar and when dates change, it modifies one event without making new ones. Ideally, without having to run the script every time as well.

Based on a Google Video Tutorial, I created a function to create events on a Google Calendar. It works perfectly, but Im trying to set the color of the event based on cell value. Now Im capable of setting the Event Name, start date, end date and description, the only thing left is to set the color.

Im trying this but it doesn't work:

I have been struggling with this formatting problem I hope someone cane help. At one point in my script I need to concatenate the value which is the date(ie 11/20/2020) with the time(3:00 PM) which is in another column. I then use this to call the calendar service class method createEvent to create the event. The problem I am having is unless I explicitly go into the spreadsheet cells and use the menu to Format-> Number -> Plain Text the cells, I get gibberish on concatenating. For instance if I am concatenating cell B4 with 11/20/2020 and F4 with 3:00 PM a Logger.log of concatenatedDateStartTime looks like:

I'm trying to create calendar events in sheets using Google App Script (I'm very new to this). The sheet contains details of the event (date, time, event title, and guest list) as well as the calendar ID (this is a training calendar). I want to make it simple for the end-user to fill in the information on the sheet, click 'schedule now' and the script run and send the events out to all email addresses mentioned in the guest list.

Here is an example of the sheet:

Here is a copy of the code (I found this on the Google Developer website and tried to adapt it to add guests but haven't been able to get it working and really not sure where to go with this. Ideally, I'd like the guest list to come from the sheet and not be written into the code as an option.