Google Sheets - Add (Import) Events in Bulk to Google Calendar Using Apps Script Tutorial - Part 11

gettting error Exception: The parameters (String,String,String) don't match the method signature for CalendarApp.Calendar.createEvent.

Another question about syncing/exporting google sheets to google calendar. Can you make a video about how to include the colors from google sheets into the calendar? As an example if you have a series of events in google sheets that you want to import into calendar and have them highlighted the same color in calendar as they are in sheets. Thanks as always for your videos!!

how you prevent the script to duplicate the events already added to the calendar. let's say I add another event to the excel file and rerun the script, it will duplicate all the previous entries. thanks

Thanks, as always for your videos!! Can I request that you do a video, not so much for events, but for scheduling. We use google sheets for scheduling, and rather than duplicating efforts (and manually entering the schedule into Google Calendar), it would be great to be able to export it. And if you are able to, can you include days off. Reason that I ask is because I've run into the error where will not execute if it's a string (text), rather than date/time (value). To try to get around this, I used if([cell reference]="off", 0...but I'm sure there's a better way than using 12/30/1899 :D. Thanks again!!

Thanks

This Google Apps Scripts for Sheets playlist is brilliant! for the addEvents function, I've used .getSheetByName("Sheet2") for the function to work. Despite clicking and saving Sheet 2, .getActiveSheet() wasn't working for me. Are there any common reasons for this? What makes the class know what my active sheet is?

I'm getting the following error all the time: "Exception: Invalid argument: startTime", although I followed your tutorial twice ;/

How can I add events that repeat weekly/monthly depending on information in the google sheet

Can we download this from your website?

is it possible to automatically sync a sheet to calender as rows get added

I started learn your videos tutorial from Google Sheets till Script now, really helpful, I have improved a lot. Thank you very much. I encountered a problem can't be solve, hopefully Sir could give me an advice. I have created 218 events in Google Sheets and desire to create all those events in Google Calendar, I can't create events in a bulk, how do I solve this problem?

Why my function show Cannot read property 'getTitle' of undefined?

Sir why dont you share the codes too .. thanks

How to get the events from all domains?

Nice video! However: is it possible to do the same thing using different calendars?

how do you add events that are a combination of all day events and specific time events?

Fantastic and thank you, great presentation. Please can I ask, on your last line "description: data[i][4]});" is there a way of including a description from a 6th column in sheets?

Thank you so much!!

🙏🏻

These are a great series of videos! However I'm getting a SyntaxError: Unexpected end of input on the last line. Any help on figuring this out would be great

This code is for one calendar(or one gmail account) only. What if I want/need for more than one gmail ids? Means, I want to send calender events to many people.

Hello, you videos are really helping us in learning google sheets. Keep them coming and you are doing a great job.
Can you do a video on integrating Google tasks Api? Breaking talking for another Google ID and getting the status of tasks and updating the task status in sheet?

dear sir, when we are run this code , then error occur this , (Exception: The parameters (String,String,String,(class)) don't matchthe method signature for CalendarApp.Calendar.createEvent. (line 48, file "Code")) please needs to help for same.

Hi. I hope you REPLY :-)
That’s great put you missed something. What will happen when new events added if for example is connected to google forms! What will happen in this case? Will the script delete the previous ones or overwrite them? shouldn’t be there if condition to add only new added event based on a field to be changed after the script add the event to the calendar? It’s a good point to be considered. Thank you.

Is there an easy way to split the date and time into two columns? If so can someone reply with the logic! ty

thank you

Love your presentation of app script. I enjoy much how faster things work. Is there a way to add events to multiple calendars?

How can I add the addGuest?

Thought (looking at the video's title) that you find out the way to make a bulk creation\updating calendar events...
heh) sad it's not... but cool video never the less

Hi.. I love your training. it makes me smarter. i m very much thankful to your effort that you are giving to us. In this script can u help us to avoid duplicate event and/or deleting any event

forEach does work. You just have to attach it to an array, i.e. data.forEach()

Thank you

Everytime I add some events then run the add events code, the previous events keeps on duplicating after every run. How do I fix it?

Your videos are amazing!!! We use a Google Form for our managers to submit events to be added to our calendars. There are 60 calendars. Is there a way to add in some logic to what you demonstrated so that if certain fields contain certain text it will populate the event to the appropriate calendar? (i.e., If the Marketing column is Yes and the store field contains the word Chicago then the event will populate to the Chicago Marketing calendar?) If not, is there a way to write the macro so that it distributes the events to the appropriate sheet in the worksheet then we can use Zapier to populate the calendars. I'd prefer to avoid using Zapier.

Can I know how to create event in Google Calendar when it meet specified criteria in google sheet? Request leave for example. It create new events when only the request is approved.

Any video about delete events for ex by ID ?

I am having problems, LastRow is giving me a lot of blank rows . I do not know why. I bring the information with a query from another sheet. (When A is not Null). but the script when I run it gives me the information of all the blank cells. [,,,,,,,,] like this. why lr = ss.getLastRow(); is not working?


function addEvents() {
var ss = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
var lr = ss.getLastRow();

var data = ss.getRange("A2:G" + lr).getValues();

for( var i = 0; i<data.length;i++){

Logger.log(data[i][0]);
}
}

**When I Loger.log(lr); --> 1000 (numer of rows in the file)

Is it possible to modify the code to configure the color of each event?

Hi guys, Love your videos. Can you please update this one and see it is possible to invite some "guest" to a particular event, so all of the participants can receive a notification alerts regarding the event (let's say 5 min before it)?

Would you consider posting the code itself so we may copy and paste? I know I am being very lazy! PS- Thank you so very much for your amazing tutorials!!! I have utilized them.

Can you please add a video where you explain how to update the events in the calendar from the sheet?!