How to automatically add a schedule from Google Sheets into Calendar

ArticlesBlog

Written by:


67 Replies to “How to automatically add a schedule from Google Sheets into Calendar”

  1. Ran Diamond Academy says:

    How to make video sharing android app

  2. karl409 says:

    thank you very much – this is a nice one… but how can you sync back and forth? I mean: …changing or deleting something in the sheet applies to the calendar… changing or deleting something in the calendar applies that to the sheet… you get the idea? …that would be awesome: a fully integration of a calendar in a google spreadsheet – do you have a solution for that?

  3. PearsonGroupChicago says:

    Very helpful! Is there ability to then sync with Maps for routing schedules?

  4. bkaberger says:

    Super helpful tip! Keep it up!

  5. Nari Mohan says:

    thank you very much for the info…

    Two (2) questions:

    1. With this script that you've modeled in the video, is it triggered by a specific event or do you have to manually run it every time you need it?
    2. Does this script take into consideration to automatically update a shift detail if you make any changes?

  6. Dave Parsons says:

    I wrote a free script that syncs back and forth between sheets and calendar if anybody wants something like that: https://github.com/Davepar/gcalendarsync

  7. Sai Vamsi Krishna says:

    Will this script when adding the events to google Calendar send the invites to the members added ?

  8. Shanmukarajan SV says:

    better you put this as an option in UI of Calendar or Google Sheets for ease of use. It will avoid coding in Google app scripts 😀

  9. Vlad Polianskii says:

    honestly it is all for geek, but i belive one day GCcalendar and GSheets come toghether and work as one

  10. Ryan Maynard says:

    Why is she using a Mac inside of a chrome book

  11. justin aquino says:

    i like this kinds of tutorials

  12. James Cavanagh says:

    Can we please get a copy of the whole script?

  13. Сиринан Уэйли says:

    Answer directly. Writing Google documents Experiencing a list of problems not in phone Or else already Personally, like writing documents, is a common matter. We understand this But the truth There are also shared drives. Which designed the standard of other telephone systems that are installed only by themselves Anyone who uses Google documents to perform daily tasks every day.

  14. Michael Rodriguez says:

    Nice

  15. Curb The Chaos says:

    Is there a link to the coding that she whizzes through? I feel so out of the loop with coding these days I'm a bit shy to ask! I've read the blog post that breaks down the directive for the APP SCRIPT and it's super helpful.

  16. Adrienne McCue says:

    Mind-blown! Totally doing this for our nonprofit volunteers! Thanks so much!

  17. SIDDHARTH RAJKUMAR MURARKA says:

    I need to digitalise my case management. So it will have last date case no. Court premises. Court room. Filer. Opposite party. Stage and next date. Can this excel be automated in such manager that once I feed next date it goes auto to calender

  18. Multani Investments says:

    I need help to create a button in google sheets which can show a click affect whenever i am clicking it for running an assigned script

  19. Jhairo Flores says:

    Actually is very handful but i want to put all my activity worksheet and some more add ons as email reminders do you have some more deep toturial?

  20. Frederic Biondi says:

    Brillant !

  21. Daniel Roper-Jones says:

    Not 100% (also not a coder). Can this function to create multiple events or do I still need to create an event manually? Clarification: We would like the bookings button on our website (which currently automatically fills a sheet with desired date and time) to automatically create a new event with the same info and contact details added to our Google calendar. If yes I will try to follow along and set this up. If not, how do I do that. Each time a new line is added to our sheet, a new event is created with the details pulled automatically.

  22. Rob van Kanten says:

    is it also possible to do it the other way around? To make a timesheet each week with the calendar as the source of the information?

  23. Isabella Scorza says:

    is it possible to input the event description?

  24. Nathaly Wheller says:

    Is there a way to create 1 event and then add those names & emails and guests in the event?
    Also, if the event changes in the sheet and the script runs, will it move all the old data to the new event, or will it just create a new event leaving the old one?

  25. lorenzo spinelli says:

    function scheduleshift2() {
    var Foglio = SpreadsheetApp.getActiveSheet();
    var IdCalendario = Foglio.getRange('A1').getValue();
    var eventCal = CalendarApp.getCalendarById(IdCalendario);
    var signups = Foglio.getRange("A2:C3").getValue();

    for (x=0;x<signups.lenght;x++) {
    var shift = signups[x];
    var volunteer = shift[0]
    var startTime = shift[1]
    var endTime = shift[2]

    eventCal.createEvent(volunteer,startTime,endTime);
    }
    }
    function onOpen(){
    var ui = SpreadsheetApp.getUi();
    ui.createMenu("Sync")
    .addItem( "Sincronizza ora","scheduleshift2")
    .addToUi();
    }

    Why is nothing created in the calendar? I don't understand where the error is

  26. AKSHAY SAKURE says:

    Hi Joanna and G-Suite team,
    Actually I wanted to use this feature to sync a Project plan in Google sheets to Calendar where I have multiple columns So,Can I add more than 3 columns (as shown in video) ? If yes, can I name them differently than the headers you have given?

  27. AKSHAY SAKURE says:

    I ran the whole thing as specified along with onOpen function. Both of them ran without error but the output didnt get reflected.. Neither the sheet got integrated with Calendar, nor their was a new Menu creation. Can you please help me at this at the earliest?

  28. Jorge del Campo says:

    Great!! How can i create a detailed event (with description, location and any other details)? I've using IFTTT service for this but now doesn't work correctly

  29. Davidov Michael says:

    i want to add description how it work ?

  30. Peiling Loerincz says:

    Thanks for sharing this very helpful tip! Anyways to have the tasks in google sheets automatically added on google tasks as well? Thanks!

  31. Yikuan Ho says:

    This format of video makes it so easy to understand. Thank you so much!

  32. Omar T says:

    Hi Joanna and G-Suite team

    great tutorial. I can create my events on Calendar, but i Have a problem every time I sync the Sheet with Calendar, using the UI option in the menu, the event in calendar Duplicates.. do yoy have another function that resolves this,?? maybe first delete the content of the calendar and then insert the events like if there were new. ???

  33. Brady Cox says:

    No discussion on permissions or issues with them. Sadface.

  34. Chris Fields says:

    i must have the concentration and brain power of a flea …. this has completely baffled me (never used coding by the way and learning is tough)
    could really use some help

  35. NSLAS Shore says:

    Wow thanks

  36. MumblingFumbler says:

    Thanks for the great video. The only thing that is missing is a link to the script in its entirety so that your viewers can copy and paste. Is there a reason that you haven't done that, as you promised to do in a comment below, where you said you'd put the script on GitHub? It is very inconvenient to type what's presented in the video when you could easily provide it. Actually you could probably provide the whole script in the description above. Thanks for your video and for your help.

  37. Rik van den Reijen says:

    Hey, Joanna first of all awesome video! I am currently however experiencing some trouble. Can the example be downloaded somewhere?

  38. Rasil Galeev says:

    her using Mac blows my mind more, published on Gsuite page XD

  39. Michael Walter says:

    So if my school follows a 7 day cycle instead of a weekly cycle, I should be able to use this as a base and make it easier to add info to my calendars? I hope so at least. This is a great place to start! Thanks!

  40. Vincent Marino says:

    Trying to modify this script so it can be used for lesson planning. Want to be able to type a module #, unit #, start date, end date, lesson description, lesson target into 6 columns on my spreadsheet then run the script to have it show up on my google calendar. Can someone contact me to help me with this or who could I contact for more direct help?
    Thanks!

  41. CON MENSAJE says:

    This is great. Thanks a lot. But I'd like to take it a step further. Is there a way to sync the events created this way? If the events in the spreadsheet change I'd like to update them in Google Calendar accordingly. Also, it'd be good to adapt the script to make sure that the events already in the calendar are not re-added to it. (I'm thinking of synchronising a marketing plan that lives into a spreadsheet with a calendar). Any hints on how to do it?

  42. jason avina says:

    "you definitely dont want to learn how dates work in programming"

    Dislike! Some of us are in school to learn exactly that and others may already know it. The video shouldn't be about that, but don't assume what we want to learn!

  43. DME - AIPL says:

    nice video

  44. DME - AIPL says:

    same thing i am using but show Error "Cannot find method createEvent(string,string,string). (line 17, file "oo")" Please resolve it

  45. Mark McCombs says:

    Is there a way I can reverse this process, i.e. populate a sheet with particular kinds of events in calendar?

  46. Designed Bliss says:

    hello, I saw your youtube that shows the App Scripts update from a spreadsheet to Google calendar. I’ve added this additional function but apparently when publishing “Deploy as web app” vs “Deploy as sheets addon” makes a difference. I’m guessing the sheets addon is what you would indicate as the choice but there are “User Managed Cloud Platform Required” limitations that aren’t explained. So it won’t autoload into the sheet as an addon. I’d loved to find the answer to make it work since this is very useful.

  47. Stacey Waldron Santoro says:

    Is it possible to have the event publish to the calendar of the individual that is assigned and not just a "general" calendar? Meaning if I have a task or event and want to create a calendar event or reminder for that individual automatically when the date is entered and the individual selected, is that possible? Also what about creating an email notification of the task.

  48. Sushanth Kodela says:

    Every time I run the script, the calendar events are getting duplicated!

  49. Rodolfo Carvalho says:

    function delete_events()

    {

    var fromdate = new Date('01/01/2018');

    var todate = new Date('01/01/2020');

    var calendarname = 'SPRINT';

    var calendar = CalendarApp.getCalendarsByName(calendarname)[0];

    var events = calendar.getEvents(fromdate, todate);

    for(var x = 0; x < events.length; x++){

    var ev = events[x]

    Logger.log(ev.getTitle())

    ev.deleteEvent()

    }

    }

  50. Matias Espinoza says:

    I've been having problems with this script. It worked fime for a couple of months, But now, It tells me that I have exceeded the number of events created or eliminated in a short time. I don't understand how is that possible if I'm creating or eliminating almost 250 events per month. Please, your help.

  51. FRANCISCO DE ASSIS DA SILVA JUNIOR says:

    Awesome. Thanks a lot 🙂

  52. Jamie MacNeil says:

    can you leave a copy of the sheet with apps script for us to view. Or leave the code so it can be copied?

  53. Karthik Acharya says:

    How to get reminders for the event scheduled ,

  54. Denise Bruce says:

    TYPE ERROR: I have copied this code exactly and only changed the CalendarId to my calendar. It doesn't matter which Calendar URL (public, ical, etc) I have put in the "C4" cell on the sheet, I get the same error, TypeError: Cannot call method "createEvent" of null. (line 25, file "Code"). What else am I supposed to do here?

  55. niswah hasinah says:

    Please show me how to automatically import data from google form to calendar. Last year i use third party extension which is free. but, early in this year i can't used that extension anymore because i had to paid..your's video only show for event created using spreadsheet itself. not from spreadsheet that im automatically created using google form. please show me how to do it

  56. Mauricio Salán says:

    I see all these questions but none have been answered. =(

  57. Phron2525 says:

    How to make a 24h event from Google Sheets to transfer it to Calendar?

  58. Alexsandr says:

    Hi Joanna!

    Can I access the user's calendar when he edits a cell by a trigger 'onEdit'?
    I added a menu with a simple script in 'onOpen' to cause an authorization request, but it does not apply to 'onEdit'.

    Thanks.

  59. Jaalataa Sabaa falmachisaa says:

    75017

  60. CHES WatchDOGS says:

    To coordinate volunteers I have them sign up for slots via Google Forms, The form writes to a sheet that runs THIS Code to populate a calendar with the volunteer dates. I have a Trigger set on "Form Submit" so the calendar updates every time someone completes a form.
    However, It seems like this gives up after a while and stops updating after a couple weeks.
    When I go in to debug, I run it to test before I make any changes and it starts right back up no issue.

    Is there some timeout or other issue with the triggers?

  61. Lee Arnold Montoya says:

    The audio is to low for my old ears!

  62. Rob Conley says:

    What a great video. Is there any way to add reminders into the events?

  63. German Torres says:

    Thanks this is very helpful but how can I do this starting from a Google form that serves to make appointments?

  64. Sharon Cheng says:

    how to make my every write in date and time on spreadsheet could able to auto import/sync to google calender?

  65. EvolveEarth says:

    https://zapier.com/apps/google-calendar/tutorials/how-to-create-calendar-events-from-spreadsheet-tutorial

  66. Gustavo Triani says:

    In my code, there's an error that says "Can't find method createEvent(object, string, object)"

  67. Gedalyah Reback says:

    Can you explain what is going on with the for loop here? I'm not sure how to apply it and you sort of skip over it in the video.

Leave a Reply

Your email address will not be published. Required fields are marked *