Тёмный

Get Calendar Events into your Sheet using the Calendar API and Google Apps Script | Aryan Irani 

Aryan Irani
Подписаться 3,5 тыс.
Просмотров 22 тыс.
50% 1

Опубликовано:

 

22 окт 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 45   
@panjiip6017
@panjiip6017 Год назад
Nice tutorial!!! Can u do the reverse version of this with adding a guests?
@peaceofpaper1
@peaceofpaper1 Год назад
Great Video. Is there a way to Filter the Events by name? Maybe a “must-contain” keyword? Thanks!
@duncantalbott9463
@duncantalbott9463 2 года назад
Really great tutorial! Question: Is there a way to also pull the google meet links for events that have them?
@LizCitron
@LizCitron Год назад
Thank you! This is exactly what I needed. It has saved me a ton of time!
@jamiedarlison
@jamiedarlison Год назад
Hi thanks so much for this video. Is it possible to only add events with a location attached to them? Thank you
@diegodelfino9409
@diegodelfino9409 2 месяца назад
Thank you! I have a question: If i run the AppScript and then one of the events in the Calendar get cancelled, how I can automatically remove it from the Google Sheet as well?
@XXLAUTAROXX
@XXLAUTAROXX Год назад
Excellent! When I bring new events to my Sheet, lateral columns with manual complementary input don’t follow events vertical position. Is there a way to link cells position ?
@ayre_mgm
@ayre_mgm Год назад
Thanks a lot for this video, how can I get the information of the different mails on a meeting? How is the var function? Thanks!
@connectsavin
@connectsavin Год назад
Thank you! Aryan for this tutorial. I tried this and everything works for me expect on the sheets I only see the start and end dates but no start and end time. Does these two commands are only able to get you the date? var start_time = events[i].getStartTime(); var end_time = events[i].getEndTime(); Is there any other event I get command for time ?
@ChrisParsons-u3f
@ChrisParsons-u3f 11 месяцев назад
This is a really useful example, yet I don't seem to have access to any of the CalendarEvent methods. They do not Auto-complete and are not recognised as functions if typed out. Do I need to do something else to get access to the CalendarEvent Class?
@bisinellamattia
@bisinellamattia Год назад
Is it possible to import guests to the event?
@ianjackson8506
@ianjackson8506 Год назад
Hi, thank you for the video, would you happen to know how to also pull event colors from the calendar to fill individual cells? if that is at all possible.
@julianruben3199
@julianruben3199 3 года назад
Thank u so much!! I realy need this for my job agend and you help me at all. Thanks!
@AryanIrani123
@AryanIrani123 3 года назад
You are so welcome!
@GeogenesisMacana
@GeogenesisMacana Год назад
Need help how to fetch/get the guest or specific guest
@bagusirawan3890
@bagusirawan3890 2 года назад
Nice tutorial! Got a question though. What if I want the schedule to be added automatically when I create new events? Do you have a video on that? Thank you!
@brcleaningcompany2566
@brcleaningcompany2566 2 года назад
Hello Friend, any luck? i see that no one has responded as of yet,,, i am also working really hard trying to figure a way to get it to auto update rather than ahving to run the script everytime,,,
@agustinbeccaria6173
@agustinbeccaria6173 Год назад
@@brcleaningcompany2566 Did you found the answer??
@EryIrmansyah
@EryIrmansyah Год назад
Thank you so much for the Tutorial Aryan Irani, however is it possible to get calendar from multiple calendarID?
@AryanIrani123
@AryanIrani123 Год назад
Yes, you can store a list of different calendar ID's and then iterate through them.
@EryIrmansyah
@EryIrmansyah Год назад
@@AryanIrani123 perhaps a video tutorial showing step by step on how to do it. 🙂thanks
@AryanIrani123
@AryanIrani123 Год назад
Sure, will schedule a recording for this topic :)
@pharmlord
@pharmlord Год назад
@@AryanIrani123 Loved the easy and simple tutorial, thank you! I am a 100 levels below novice. What would the script look like if we wanted to populate a google sheet based on the title of the event in google calendar?
@rameshkvaw542
@rameshkvaw542 2 года назад
Thanks Alot for the tutorial
@AryanIrani123
@AryanIrani123 2 года назад
You're welcome!
@extremebright3714
@extremebright3714 2 года назад
Hi Arjani. My description got a lot of these characters : how to remove this? Thanks for your help.
@preethirani2394
@preethirani2394 3 года назад
Great video!
@AryanIrani123
@AryanIrani123 3 года назад
Glad you enjoyed it
@HisBlueEyedBlondie
@HisBlueEyedBlondie 2 года назад
Not sure what I did wrong but my spreadsheet is empty. Any ideas?
@dohyeongkwon2541
@dohyeongkwon2541 2 года назад
Thank you very very very very very*1000000000000000000000000000 much. ^^
@AryanIrani123
@AryanIrani123 2 года назад
You're welcome!
@ryneevansiii8663
@ryneevansiii8663 2 года назад
My events are showing up with the wrong times (I have it set to be both date/time for start and stop). Nothing is set in the appscript for time zone
@AryanIrani123
@AryanIrani123 2 года назад
Check your Google Calendar Time and change the timings accordingly to the Google Sheet.
@speedforcex
@speedforcex 2 года назад
Is there any way to make it filter by specific event name?
@ammarafzal9296
@ammarafzal9296 2 года назад
Yes, you can.
@peaceofpaper1
@peaceofpaper1 Год назад
@@ammarafzal9296How?
@extremebright8924
@extremebright8924 2 года назад
I am having hard time to access permission. I don't know why.
@AryanIrani123
@AryanIrani123 2 года назад
Did you get the access ?
@teodoratorres4301
@teodoratorres4301 Год назад
@@AryanIrani123 I am also having problems to access permission. Some ideas how to solve this?
@Tangle-wood
@Tangle-wood 5 месяцев назад
Hi Aryan how to connect to you
@AryanIrani123
@AryanIrani123 5 месяцев назад
You can contact me on my email: aryanirani123@gmail.com
@rexated5148
@rexated5148 10 месяцев назад
Thank you! Drop your donation link.
@AryanIrani123
@AryanIrani123 9 месяцев назад
www.buymeacoffee.com/aryanirani Thanks :)
@shellyarora3750
@shellyarora3750 2 года назад
TypeError: Cannot read property 'getEvents' of null getEvents @ Code.gs:6 pls help aryan sir
@ammarafzal9296
@ammarafzal9296 2 года назад
Either the google id you are fetching is not right, or you don't have access to that calendar.
Далее
Кольцо Всевластия от Samsung
01:00
Просмотров 528 тыс.
Google Sheet Calendar Integration
12:29
Просмотров 1,4 тыс.