tag:blogger.com,1999:blog-7379565521701914821.post4554950439998593294..comments2024-03-14T18:57:15.880+00:00Comments on The Gift of Script: Bulk create Google Calendar events with optional Google MeetPhil Bainbridgehttp://www.blogger.com/profile/10553620286575352544noreply@blogger.comBlogger48125tag:blogger.com,1999:blog-7379565521701914821.post-71142132658213614662023-10-21T11:48:57.296+01:002023-10-21T11:48:57.296+01:00Excellent! Thank you for sharing.Excellent! Thank you for sharing.Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-33244224357391519442023-10-20T15:39:27.457+01:002023-10-20T15:39:27.457+01:00Ok sorry for the repeated comments but I wanted to...Ok sorry for the repeated comments but I wanted to let you know that I figured out a solution to getting the Meet link instead of the Event link. In the createEvent.gs section I modified your code on lines 256-261 and set it to this:<br /><br />// capture Meet meeting code<br /> var eventMEET = request.conferenceData.conferenceId;<br /><br /> // run Function and paste Meet meeting code into spreadsheet as clickable link<br /> var eventMEETLink = '=HYPERLINK("meet.google.com/"&"' + eventMEET + '")';<br /> pasteIntoSheet((row + 3), eventIDCol, eventMEETLink, '#000000');<br /><br />Hope this helps!nycmeehttps://www.blogger.com/profile/14979308038348915292noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-71625431867723774952023-10-19T20:08:43.508+01:002023-10-19T20:08:43.508+01:00Hello, any way to show the Meet links on the sprea...Hello, any way to show the Meet links on the spreadsheet? Need to share these links and need them all in one place. Thanks for creating this!nycmeehttps://www.blogger.com/profile/14979308038348915292noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-77871982549988692762023-04-12T14:35:39.717+01:002023-04-12T14:35:39.717+01:00You're very welcome!
I have not directly crea...You're very welcome!<br /><br />I have not directly created recurring events via the API, but I can see the options exist (there are a lot of them based on frequency, intervals, end dates, etc). I do freelance work if it's something you specifically require (https://www.pbainbridge.co.uk/p/freelance.html) as it looks like it would need to be tailored.Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-29195598648121323292023-04-12T13:47:05.632+01:002023-04-12T13:47:05.632+01:00Thanks for this. You have literally save a humoung...Thanks for this. You have literally save a humoungous work for us. I was wondering if this can be made recurring? Please suggest work around with script if possible?RRhttps://www.blogger.com/profile/04148838644089365988noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-67910028524874758202022-11-15T00:13:06.311+00:002022-11-15T00:13:06.311+00:00Thank you so much, Phil. It is working now. Apprec...Thank you so much, Phil. It is working now. Appreciate all you have done to make our jobs easy and efficient.VJhttps://www.blogger.com/profile/17023676439122267938noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-49568288524775522062022-11-14T20:38:03.940+00:002022-11-14T20:38:03.940+00:00Hi VJ
Thank you for sharing your Sheet. I see the...Hi VJ<br /><br />Thank you for sharing your Sheet. I see the error now - and it's a typo on my part (sorry about that). I recently added the ability to set the Event Colour and as it's not a 'required' item I believed it would accept a blank value. Unfortunately it does not, so I have been able to default it to '0' which will use your default Calendar colour (hence people do not have to keep changing it if they do not wish to).<br /><br />If you take a fresh copy of the Google Sheet linked in this blog post as I have updated the file for everyone.<br /><br />Ta<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-79786894609568272992022-11-14T00:08:20.647+00:002022-11-14T00:08:20.647+00:00Hi Phil, I am having trouble submitting the contac...Hi Phil, I am having trouble submitting the contact form. The message states "sending..." but nothing happens. Tried on multiple browsers.VJhttps://www.blogger.com/profile/17023676439122267938noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-38982809383027177732022-11-11T09:25:17.439+00:002022-11-11T09:25:17.439+00:00Hi VJ, I have nothing through my contact form ...Hi VJ, I have nothing through my contact form ...Phil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-82731301337329131482022-11-11T03:37:07.936+00:002022-11-11T03:37:07.936+00:00Thank you Phil, yes I tried a very simple event an...Thank you Phil, yes I tried a very simple event and on two different accounts. I have sent you the file through the contact form.<br /><br />thank youVJhttps://www.blogger.com/profile/17023676439122267938noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-8310739573553412632022-11-10T20:03:48.432+00:002022-11-10T20:03:48.432+00:00Hi VJ
Thank you.
Annoyingly (or I'm yet to f...Hi VJ<br /><br />Thank you.<br /><br />Annoyingly (or I'm yet to figure out a way to find it) the Calendar API does not give much back re exactly which bit of data it does not like!<br /><br />So you have set the relevant timezone within the Google Sheet properties?<br /><br />It does create a very quick test event (and then deletes it) to ensure you have entered a valid Calendar ID on the 'Welcome' sheet basically. Have you tried creating a super simple event with just a Title, Description and the timings? (So no Guests, etc)?<br /><br />If you wanted to use the Contact Form on my blog to share a version of you file to see if I can spot anything then I could try to take a look for you. I do have somebody successfully using this in Hawaii currently!<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-90631835636112451672022-11-10T00:53:55.238+00:002022-11-10T00:53:55.238+00:00Hi Phil, thank you for this, it will make our job ...Hi Phil, thank you for this, it will make our job easier.<br /><br />However I am encountering error when running the script:<br /><br />Problem with 'createEvent' Function API call:<br /><br />GoogleJsonResponseException: API call to calendar.events.insert failed with error: Invalid Value<br /><br />I have set the timezone to mine (+8) and the dates are correctly formatted. <br /><br />From the Google Workspace event log, I see that it is creating a event called "create event test" and then deleting it. My event name is not that, so I assume your script is testing before it creates the actual event?<br /><br />Please advise what can I check?<br /><br />thank you<br />VijayVJhttps://www.blogger.com/profile/17023676439122267938noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-35844471637472316582022-05-10T11:06:21.263+01:002022-05-10T11:06:21.263+01:00Hi Brad
Are you formatting the dates correctly as...Hi Brad<br /><br />Are you formatting the dates correctly as detailed in the Column headings? With only 1 date per cell?<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-10752055792009052682022-05-09T23:01:55.835+01:002022-05-09T23:01:55.835+01:00I'm putting in bulk dates and im coming back w...I'm putting in bulk dates and im coming back with this error<br /><br />Problem with 'getSpreadsheetData' Function:<br />Function 'eventsSheetLastRow' returned: -2<br /><br />The log says:<br /> _The number of rows in the range must be at least 1_<br /><br />Bradhttps://www.blogger.com/profile/06925707876969219770noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-23020387785968232762022-02-10T14:24:32.334+00:002022-02-10T14:24:32.334+00:00Excellent Michael, glad you were able to get sorte...Excellent Michael, glad you were able to get sorted.<br />Thank you for the nice comments.<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-55771476194942729222022-02-10T14:23:35.434+00:002022-02-10T14:23:35.434+00:00Thank you very much!
Kind regards
PhilThank you very much!<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-46684144215347770522022-02-10T12:45:50.833+00:002022-02-10T12:45:50.833+00:00Thank you for your work on this - brilliant, it is...Thank you for your work on this - brilliant, it is going to save so much time.Anonymoushttps://www.blogger.com/profile/14556281785354640489noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-28900964966749807732022-02-10T12:22:41.377+00:002022-02-10T12:22:41.377+00:00Yes! I came here for this exact same issue. Soluti...Yes! I came here for this exact same issue. Solution was perfect. <br />Thanks so much for this. I've been trying to teach myself Google Apps Script to create something that does EXACTLY this. You have made my life so much easier. <br />I'm still going to try and learn how to do it, but this is amazing. Michael Walterhttps://www.blogger.com/profile/14950562461054513670noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-29631293675085993802022-02-07T13:06:13.007+00:002022-02-07T13:06:13.007+00:00Hi Michael
That's a really good point - the A...Hi Michael<br /><br />That's a really good point - the Apps Script code gets the TimeZone from the Google Sheet. I'll update the blog post with this step to prevent other people from getting caught out by it, thank you.<br /><br />And thank you for your nice comments! I'm glad it's been able to help you out.<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-45194030783755502922022-02-06T19:44:05.479+00:002022-02-06T19:44:05.479+00:00Yes, #2 was the solution for me. I wonder if copyi...Yes, #2 was the solution for me. I wonder if copying from your template version causes the copied sheet to default to UTC +00:00.<br /><br />More importantly, THANK YOU for this fantastic tool. It saved me so much work, and it was so satisfying to sit back and watch it populate my calendar for me. Really appreciate your sharing this.Michael Protaciohttps://www.blogger.com/profile/01267362585105403853noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-83984527118209454502022-01-17T15:57:40.963+00:002022-01-17T15:57:40.963+00:00Hi
Yes it is.
Kind regards
PhilHi<br /><br />Yes it is.<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-17895396420278269582022-01-17T15:53:37.082+00:002022-01-17T15:53:37.082+00:00Hi is it free to use?
Hi is it free to use?<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-6491695415603610552021-07-09T09:11:11.447+01:002021-07-09T09:11:11.447+01:00Hi
When you say "same issue" ... as?
T...Hi<br /><br />When you say "same issue" ... as?<br /><br />The script uses your local TimeZone so it may be that the copy of the file is stuck somewhere.<br /><br />1) Maybe check the Manifest file first for its TimeZone: https://developers.google.com/apps-script/concepts/manifests<br /><br />2) Check the 'Spreadsheet settings' from the 'File' menu in the Google Sheet itself (there is a TimeZone option in there too).<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-2720402390320431002021-07-07T18:56:17.265+01:002021-07-07T18:56:17.265+01:00Hi Phil - I have same issue. Made a copy of the s...Hi Phil - I have same issue. Made a copy of the sheet and the time published the events using UTC +00:00. I am in New York/ UTC -05:00. Can just work around with a mapping, but curious if you know why it would do soDShttps://www.blogger.com/profile/03991556262473005605noreply@blogger.comtag:blogger.com,1999:blog-7379565521701914821.post-1007117753513236242021-06-29T17:10:28.214+01:002021-06-29T17:10:28.214+01:00Hi Heidi
I'm afraid it's only been design...Hi Heidi<br /><br />I'm afraid it's only been designed to create brand new events and there is no option to update them via the Google Sheet afterwards.<br /><br />Kind regards<br />PhilPhil Bainbridgehttps://www.blogger.com/profile/10553620286575352544noreply@blogger.com