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
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
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
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.
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.
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.
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.
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?
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?
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?
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 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
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?
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet2"); var calId = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet1").getRange("D4").getValue(); var cal = CalendarApp.getCalendarById("epicuser@gmail.com"); var events = cal.getEvents(new Date("4/15/2020 12:00 AM") , new Date("4/16/2020 12:00 PM"));
@@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 .
@@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
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
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!!
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.
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.
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?
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.
Applying for a position using App Scripts and this is the clearest example of basic API integration I have found. Thank you!
you should make a video on how to embed google sheets on a website and make it look nice, Your videos amazing!
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
The same here, thank him so much
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
You are a great tutor!
Thnk you!
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
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!
Thank you so much! Excelent video!
Glad you enjoyed it!
Thanks!
Very good tutoring, understandable and workable
Your videos are so great! Thanks for sharing.
ty so much sensei
thank you legend
Oh nice, have been looking for this stuff! Cheers guys!
Nice work
Thanks
Thanks
Man !! You the man !!! YOU THE MAN !!!
Excelente Script, Thank you Master!
Great video, thank you.
Thanks for such a great video! Any chance we can edit the Video Link in the Calendar Events created from Sheets?
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.
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.
This is so cool :)
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.
What have you tried?
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.
@@sevaricofrathe5733 try getGuestList().map(function(g){ return g.getName() }).join(",");
thank you very much
Thanks you bro, very useful video ;)
Great video but how do i make the event delete off of the spreadsheet when the event has passed
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?
Yes. webapps.stackexchange.com/questions/13561/calculating-total-hours-of-an-event-in-google-calendar
How would you alter the script to get events from multiple calendars?
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.
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?
Under Extensions-Apps Script. The rest should be the same.
This is for an online spreadsheet with an online calendar. Do you have any lesson for anything off line, i.e. iCal with Numbers?
How do we get access to source code? if we become patreon do we get source code for example? Great work on videos.
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?
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?
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 :-)
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.
@@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
Script works great. Thank you. Is there a way to set the start date by a cell value?
yes
🙏🏻
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?
this could work for you:
sites.google.com/a/newvisions.org/scripts_resources/scripts/formmule
How to get attachment (url) from google calendar to google sheets
Sir. Is it possible to update time in each second in google sheet
This is very good. How to write the data in a specified sheet instead of an active sheet???
var ss = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet2");
var calId = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sheet1").getRange("D4").getValue();
var cal = CalendarApp.getCalendarById("epicuser@gmail.com");
var events = cal.getEvents(new Date("4/15/2020 12:00 AM") , new Date("4/16/2020 12:00 PM"));
@@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 .
Hello, is there a way to write app script to a team Gmail acct which I have been granted access to. Thank you!
When you say Apple has confusing method names, do you mean Swift language?
I honestly don't remember at this point what I said, but, yea, Swift does have confusing method names, at least for me.
would anyone bother to share where or how I could get this full script?
Very nice! Any way to identify which events are recurring?
isRecurringEvent() method on event object will return true for recurring events.
Can you do it in reverse, sheets to calendar?
Yes, I believe I have a video on that as well.
How do i do it so i can input todays date? But great video man
new Date()
in JavaScript will get you the current date & time
Thanks for the reply your amazing!
can i pull event from several calendar account to one sheet?
Yes.
@@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
Hello @Lan Anh Nguyen Thi, do you still need help with this?
This would have been SOOOOO much easier if you had just returned an array.
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
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!!
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.
ruclips.net/video/qXG-i_sG8CI/видео.html
ruclips.net/video/w4oUjDC9L6A/видео.html
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.
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?
Dear ,
Can you Please make WhatsApp with instigated google sheet
Great video. Thanks for sharing!
Very clear and straight to the point!
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.
There could be an array formula or a space some place.
Try other methods of getting the last row ruclips.net/video/zWcNzLbJpb0/видео.html
Your videos are great. Congrats