Automatically Create Google Calendar Events from Google Sheets / Google Forms

Поділитися
Вставка

КОМЕНТАРІ • 57

  • @kensioson1644
    @kensioson1644 Рік тому +3

    Very helpful! Thank you so much for making this tutorial!

  • @sarrycky
    @sarrycky 6 місяців тому +3

    Nice method, unfortunally this add-on is in demo version and there is a limit of 10 schedules

  • @iouliaiaroch6174
    @iouliaiaroch6174 Рік тому +3

    Thanks a lot! Very helpful.

    • @technologiate
      @technologiate  Рік тому

      You are welcome🙂
      Please subscribe to the channel and share the video😊

  • @adailtonsantos910
    @adailtonsantos910 Рік тому +2

    Hey! It's possible to set multiple events of multiple date fields in one Form? For example, i have 3 date fields, when i submit the form, i want that 3 events been created

  • @apexbytes
    @apexbytes Рік тому +2

    man thanks its saved my project thank thank you

    • @apexbytes
      @apexbytes Рік тому

      when i check the Update Event Automatically it does not go to my google calendar pls help man how many hours i wait

    • @technologiate
      @technologiate  Рік тому

      @ramortega, if the connection is synchronized correctly, it should update in a few moments.
      Could you try it with a new Google Sheet?

  • @jorgengargaritano6647
    @jorgengargaritano6647 Рік тому +2

    This was very helpful though im having issues integrating a new calendar i created to separate the data from my actual calendar events. If you can reply to this would be much appreciated.

    • @technologiate
      @technologiate  Рік тому +1

      I got you.
      1. Create a new Calendar in Google Calendar (you already did).
      2. Select the calendar while setting up the Automator. Watch the video at 02:39 where I select the color; at the left side of that, you see the blurred section; select your newly created calendar there (I blurred it out for privacy).
      Don't forget to like the video and subscribe to the channel.
      And I am here to reply to your queries.
      🙂🙂🙂

  • @KDCreates_
    @KDCreates_ 2 місяці тому

    but you have to pay for this extension after creating calendar
    how many events can you dO A DAY?

  • @jigsoza1
    @jigsoza1 7 місяців тому

    It worked, but if i delete any event from the google sheet, it doesnt delete event from the calendar. Please help in that as well. Thank you

  • @estudiovarianza
    @estudiovarianza Рік тому

    Thank u so much for this video!

  • @KHYPYUMAL
    @KHYPYUMAL Рік тому +2

    Superb bro 🎉

  • @kylewilliams4721
    @kylewilliams4721 Рік тому +1

    So is there no column for color? I want to have different events have a different color

    • @technologiate
      @technologiate  Рік тому

      Unfortunately, I didn't found the color option too.

  • @tvcasa8217
    @tvcasa8217 Рік тому +2

    Thank you!

    • @technologiate
      @technologiate  Рік тому

      Thank you🙂
      Please like, share & subscribe.

  • @atty.rexlynanneevora1314
    @atty.rexlynanneevora1314 Рік тому

    Apparently, when the event is deleted from the Google Calendar the whole row inputs are deleted from the table :(

  • @razakhan380
    @razakhan380 Рік тому

    There is no option of google calender when I opened the Extension..

  • @EroWinandaS
    @EroWinandaS 6 місяців тому

    Can I add multiple guest email at one time input?

  • @manuelvita9708
    @manuelvita9708 2 роки тому +1

    When i click on set up , the new window that it opens is just blank. Am i missing something??

    • @technologiate
      @technologiate  2 роки тому

      Hi @Manuel
      Did you try the process again?
      Please disable any ad blocker if you have one on your browser.
      Or check if it conflicts with any other extension on the browser.
      Thank you.

    • @manuelvita9708
      @manuelvita9708 2 роки тому

      @@technologiate it worked now, thank you! I guess it was the add blockers i was having

    • @technologiate
      @technologiate  2 роки тому

      Wow! ✌️

  • @DikaArdiyanto
    @DikaArdiyanto Рік тому

    Is there a limit to filling out Google Forms?

  • @thomasjohansson6820
    @thomasjohansson6820 Рік тому

    This is really good. But how shall I do if I´ve a spreadsheet with events and with different teams to each. I would to automatically create events in the google calendar against different team calendars. Possible?

    • @technologiate
      @technologiate  Рік тому

      What do you mean by different team calendar?

    • @thomasjohansson6820
      @thomasjohansson6820 Рік тому

      @@technologiate Hi, in Google calendar you can create different calendars within the mail calendar.

    • @technologiate
      @technologiate  Рік тому

      @@thomasjohansson6820 Thank you for the clarification.
      In that case, you should use different Sheets for different teams, and after connecting the calendar account, you will see the list of calendars to choose one.

    • @thomasjohansson6820
      @thomasjohansson6820 Рік тому

      @@technologiate
      Hi again
      Sorry, but the list in the sheet include all different teams that has one calendar each in Google calendar.
      Possible?

  • @amadoucisse2692
    @amadoucisse2692 7 місяців тому

    Why no template?

  • @kensleylewis
    @kensleylewis Рік тому

    How do you modify the title for each calendar event from the Google Sheets Add-on settings?

    • @technologiate
      @technologiate  Рік тому

      Watch at 2:04, you need to put the column name for the meeting title instead of a static title.

  • @HiraRiaz-v5x
    @HiraRiaz-v5x 10 місяців тому

    hello,
    My google sheet has dates in rows so how i can sync that? Currently, only columns are selected.

  • @healyourhorse
    @healyourhorse 8 місяців тому

    Hey, I have followed this through - but the event isn't showing in my google calendar- do you now have to pay for automations?

    • @technologiate
      @technologiate  8 місяців тому +1

      Hi, it has paid plans. But the free plan works for the first few events. Currently, I do not remember the exact number they offer with the free version.
      If you set the date column correctly, it should create the events.

  • @pakiatanonlinecoachingcenter
    @pakiatanonlinecoachingcenter 5 місяців тому

    Not working

  • @Torq123
    @Torq123 Рік тому

    the Add on app has 2.5 rating

  • @instaphotobootharuba2945
    @instaphotobootharuba2945 Рік тому

    When you connected it with the form, how long did you have to wait for the event to pop up? I've been waiting a while and it's still not showing unless I copy paste the data back on the sheet. So it only seems to be working immediately with manual inputs.

    • @technologiate
      @technologiate  Рік тому

      It should work like the way it works when you enter manual inputs.

  • @reaper8f
    @reaper8f 10 місяців тому

    its say (!)Info: Invalid event date/time.

  • @phantazzor
    @phantazzor 7 місяців тому

    what if the time is already taken ?

    • @technologiate
      @technologiate  7 місяців тому

      Still, it will create the event.

  • @queenpushycat
    @queenpushycat Рік тому

    I tried using this add-ons, however, it only takes data along the column, but I want it to be rolls. Anyone has any tips?

    • @technologiate
      @technologiate  Рік тому

      Hi, did you set the columns for the new events? Like column for Event name, column for event date, etc.

  • @HajarElAmraniElIdrissi-w8k
    @HajarElAmraniElIdrissi-w8k 7 місяців тому

    can we add a link for the link for the google meet ?

    • @technologiate
      @technologiate  7 місяців тому +1

      Yes, you can add the Google Meet link to the 'Meeting Location' field.

  • @hajarelam
    @hajarelam 7 місяців тому

    Can we add the link of the meeting ?

    • @technologiate
      @technologiate  7 місяців тому

      Yes, you can add the Google Meet link to the 'Meeting Location' field.

  • @bensteyn1974
    @bensteyn1974 Рік тому +1

    Thank you!