Google Sheets - Apps Script Google Calendar API Integration Tutorial - Get Events - Part 10

[@wimino367]

I came back to this video because this content was the first script that I implemented in my company. I'm really grateful for everything I have been learning from you over the last couple of years. Thanks a lot! you are so a great teacher

[@diditaxinl8099]

The same here, thank him so much

[@JohnDopping]

Applying for a position using App Scripts and this is the clearest example of basic API integration I have found. Thank you!

[@marcvanmaastricht977]

Thank you SO MUCH for this video! After the unexpected disappearance of an add-on we depended upon, a spreadsheet we use to keep track of all the activities we do, became completely useless. Then I ran into this video, and using this script with some alterations, I now have everything up and running again... even better and more efficient than before! Thanks again!!

[@AG-xd2eq]

you should make a video on how to embed google sheets on a website and make it look nice, Your videos amazing!

[@siddharthjain6629]

For loop worked here & this one and the next video of calender is amazing, nice works.. !! I appreciate your work & also the google maps video was also amazing. Thanks you very much for such good videos

[@rbfreitas]

Great video. Thanks for sharing! Very clear and straight to the point!

[@AlexK544]

Hello friend! Thank you! You made great work and explained all wery good. With your help I made export from sheets to calendar. I'm so happy now!

[@TheBinaryAcademy]

Is there a way for this to automate? Or does the script have to be run manually? It would be cool if events entered on calendar populated the spreadsheet without the script needing manual input. All works great though. Many thanks

[@sabaripandian116]

You are a great tutor! Thnk you!

[@zanatta.felipe]

Your videos are great. Congrats

[@CrisAmende]

Very good tutoring, understandable and workable

[@LucasPinheiroV8]

Thank you so much! Excelent video!

[@ExcelGoogleSheets]

Glad you enjoyed it!

[@apk29]

Your videos are so great! Thanks for sharing.

[@ujabbfelhasznalo]

Oh nice, have been looking for this stuff! Cheers guys!

[@mimily3353]

Thanks for such a great video! Any chance we can edit the Video Link in the Calendar Events created from Sheets?

[@martinn1071]

Man !! You the man !!! YOU THE MAN !!!

[@TheBinaryAcademy]

I got the start date must be before the end date error even though I changed dates to suit now. When I chose just the date (in UK format) for the actual event it worked, well it said Execution completed but I didn't see the pop up that you did.

[@johanvandervorst]

Thank you for your great and easy to follow video's! I'm trying to get events of 2 calendars and merge them so that I end up with all the events chronologically in a sheet. I'm sure it's possible but I can't get it to work. Would you consider doing an extra video about that?!! Thank you sir.

[@jailbirdx0x]

Do you have a video on how to count only the number of working days with the Calendar API? That means the weekends and public holidays are excluded.

[@sevaricofrathe5733]

You walk through s have saved my sanity so many times. Finally got this to work for my project but I can't seem to get it to pull the guests as well. I'd prefer to not have to run a separate function to pull just that information if possible. I'm worried that it won't line up correctly if my user has other events on their calendar other than the meetings ill be feeding to it.

[@ExcelGoogleSheets]

What have you tried?

[@sevaricofrathe5733]

Added .geteventID. I tried getguestlist but that returns the gmail address which is not going to help. My source info comes in as last name only. So I now have 2 functions. 1 pulls current events from the calendar and the other pushes to the calendar. Just going to sort and combine them in sheet to only add events that don't have an ID.

[@ExcelGoogleSheets]

@@sevaricofrathe5733 try getGuestList().map(function(g){ return g.getName() }).join(",");

[@santosahernandezmendoza7147]

Excelente Script, Thank you Master!

[@Nikita-vq2mo]

Thanks you bro, very useful video ;)

[@giancarloschafloqueguzman9918]

Nice work Thanks

[@jimearnold]

Awesome work! Cant wait for the one about updating the calendar. The use i have is for taking a list of open jobs and adding them to the calendar. I would need to be able to change the date in the spreadsheet and have it update in the calendar. I guess you could clear all entries in the calendar and then add them again? or would you need to update them?

[@derekherzog1569]

this could work for you: sites.google.com/a/newvisions.org/scripts_resources/scripts/formmule

[@PawelGrabiec]

This is so cool :)

[@lineber2]

Great video, thank you.

[@Markd4Comment]

This is for an online spreadsheet with an online calendar. Do you have any lesson for anything off line, i.e. iCal with Numbers?

[@larisamejia5627]

Hi, can you do the same thing if the start time and end time are in columns instead of rows? And can we establish a period of time after the event start instead of having an end time row or column?

[@arengarabet1801]

Great video but how do i make the event delete off of the spreadsheet when the event has passed

[@cookjeremiah]

How do we get access to source code? if we become patreon do we get source code for example? Great work on videos.

[@adamrobus5994]

How would you alter the script to get events from multiple calendars?

[@fittolast2647]

Hi, I love your videos and your explanations, but this one I'm having trouble with. I'm at the logger.log part and I receive the following error: TypeError: Cannot read property 'createEvent' of null ...any advice?

[@jhonnroh]

Hey man, this was awesome. really helpful. I am trying to set events on different calendars according to the information set into a cell. Is this possible? I've tried getValue and then if then, but it didn't work, Could you help me please?

[@Facey7367]

Script works great. Thank you. Is there a way to set the start date by a cell value?

[@wimino367]

yes

[@RosiTerrab]

Thanks!

[@A_Corte]

I'm trying to do this through Apps Script, since it appears people can't access Script Editor anymore (I can't), and this is not working. Do you plan to do an updated version of this through Apps Script?

[@ExcelGoogleSheets]

Under Extensions-Apps Script. The rest should be the same.

[@learningstuff5679]

How would you create a script for total hours of a Calendar Event? Would you need a script to subtract start date from end date?

[@ExcelGoogleSheets]

Yes. webapps.stackexchange.com/questions/13561/calculating-total-hours-of-an-event-in-google-calendar

[@ayushm871]

Sir. Is it possible to update time in each second in google sheet

[@jieyang1717]

Hello, is there a way to write app script to a team Gmail acct which I have been granted access to. Thank you!

[@jacobd8004]

This is very good. How to write the data in a specified sheet instead of an active sheet???

[@sevaricofrathe5733]

var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet2"); var calId = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet1").getRange("D4").getValue(); var cal = CalendarApp.getCalendarById("[e-mail]"); var events = cal.getEvents(new Date("4/15/2020 12:00 AM") , new Date("4/16/2020 12:00 PM"));

[@xeata6590]

@@sevaricofrathe5733 Здравствуйте. Увидел Ваш ответ и понял пару вещей. Тут есть активный пользователь и у него в в гуглодоках русская локаль. Может быть Вы сможете помочь с моим вопросом. Если делать как автор видео и запускать скрипт на странице редактора то все работает. Но если использовать это как функцию на листе, то выдает " Exception: The script does not have permission to perform that action. Required permissions: (www.googleapis.com/auth/calendar || www.googleapis.com/auth/calendar.readonly || www.google.com/calendar/feeds) " с указанием на строку где объявляется cal .

[@luiszuniga5815]

Very nice! Any way to identify which events are recurring?

[@ExcelGoogleSheets]

isRecurringEvent() method on event object will return true for recurring events.

[@Anzeljaeg]

ty so much sensei

[@Zinberry]

When I call the getLastRow method on the active sheet, it lists "1000" in the Log (which is the max rows on the sheet), not the 200 rows of data that are in the sheet. getLastColumn functions properly. There aren't any formulas or formatting that extend past the data.

[@ExcelGoogleSheets]

There could be an array formula or a space some place. Try other methods of getting the last row kzbin.info/www/bejne/sIjGf62Cl6-jmJI

[@apocalypticbean]

thank you legend

[@chrisparky]

Is there a reverse of this Video? I have a staff roster where the shifts are called D, N, E, Names are in the rows, dates in the columns, each sheet is a month. Pointers would be appreciated.

[@ExcelGoogleSheets]

kzbin.info/www/bejne/p4mqXpyVqKxreas kzbin.info/www/bejne/rWXShp16eJ5_bKM

[@husnizaimzaifuddin1539]

How to get attachment (url) from google calendar to google sheets

[@SBENTERPRISESPUNE]

Dear , Can you Please make WhatsApp with instigated google sheet

[@Jfresh55]

Can you do it in reverse, sheets to calendar?

[@ExcelGoogleSheets]

Yes, I believe I have a video on that as well.

[@ManojGuptahome]

I have been learning a lot from your videos. However when accessing calendar events in my time zone and format, a null array is returned. Kindly provide a solution. I am based in India.

[@wellingtonsantos92311]

would anyone bother to share where or how I could get this full script?

[@Zinberry]

When you say Apple has confusing method names, do you mean Swift language?

[@ExcelGoogleSheets]

I honestly don't remember at this point what I said, but, yea, Swift does have confusing method names, at least for me.

[@pichit.raetai]

thank you very much

[@lanhoyc4435]

can i pull event from several calendar account to one sheet?

[@ExcelGoogleSheets]

Yes.

[@lanhoyc4435]

@@ExcelGoogleSheets can you help me note how to do it? Also, i'm struggling to create unique ID for new items pasted in sheet as a range. Can you give me some guidance? Greatful for your help

[@wimino367]

Hello ​ @Lan Anh Nguyen Thi, do you still need help with this?

[@AG-go1eo]

How do i do it so i can input todays date? But great video man

[@ExcelGoogleSheets]

new Date() in JavaScript will get you the current date & time

[@AG-go1eo]

Thanks for the reply your amazing!

[@TheBinaryAcademy]

It appears it does not work in English time dude. In both G Calendar and G Sheets I have swapped my settings to the UK way. When ever I try to run the command it says "Event start time must before event end time. When I use the USA way it works. "OH, SAY CAN YOU SEE By the dawn's early light What so proudly we hailed At the twilight's last gleaming...." Another top video. P.S your WebApp being part of my Uni project scored me 90% Top Banana. A greatful sub :-)

[@ExcelGoogleSheets]

I'm not sure. You'll have to log the dates in your script side and see what's going on. Maybe try changing your project properties.

[@TheBinaryAcademy]

@@ExcelGoogleSheets Thanks for the speedy reply. In my project settings the Timezone isUK. Is OK once I got to here: ss.getRange(i+2, 2).setNumberFormat("dd/mm/yyyy hh:mm:ss AM/PM") Swaping out MM for DD did the trick. Cheers buddy

[@sseemm]

Thanks

[@phoenixempire8886]

🙏🏻

[@obfg2]

This would have been SOOOOO much easier if you had just returned an array.

[@TheBinaryAcademy]

If you are going to propose better then perhaps you should have put the 'improved code' in your reply for us 'non-coders' and to see if it is actually better? SASS from the UK