Automatically Create Google Calendar Events from Google Sheets / Google Forms

แชร์
ฝัง
  • เผยแพร่เมื่อ 6 ม.ค. 2025

ความคิดเห็น • 64

  • @technologiate
    @technologiate  14 ชั่วโมงที่ผ่านมา +1

    *Import Events from Excel to Google and Outlook Calendar:* th-cam.com/video/2idZwEJ0ppc/w-d-xo.html

  • @kensioson1644
    @kensioson1644 ปีที่แล้ว +3

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

  • @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

  • @KHYPYUMAL
    @KHYPYUMAL ปีที่แล้ว +2

    Superb bro 🎉

  • @KDCreates_
    @KDCreates_ 5 หลายเดือนก่อน

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

  • @dfwprissy
    @dfwprissy 2 หลายเดือนก่อน

    do you think that you can help me? I am doing everything you were saying but view event never shows up. I must be doing something wrong.

  • @iouliaiaroch6174
    @iouliaiaroch6174 ปีที่แล้ว +3

    Thanks a lot! Very helpful.

    • @technologiate
      @technologiate  ปีที่แล้ว

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

  • @jigsoza1
    @jigsoza1 10 หลายเดือนก่อน

    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

  • @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?

  • @konsultanedu
    @konsultanedu 3 หลายเดือนก่อน

    how to add/invite multiple people to each calendar event?

  • @healyourhorse
    @healyourhorse 11 หลายเดือนก่อน

    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  11 หลายเดือนก่อน +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.

  • @EroWinandaS
    @EroWinandaS 9 หลายเดือนก่อน

    Can I add multiple guest email at one time input?

  • @yogiyolanda_5167
    @yogiyolanda_5167 วันที่ผ่านมา

    How to make the google calender can have acces to everyone?

    • @technologiate
      @technologiate  วันที่ผ่านมา

      Hi,
      You can make the calendar with certain people, and also you can make it public.
      1. Share it with certain people: i.imgur.com/I1zZSn0.png
      2. Make the Google Calendar public: i.imgur.com/9arDNdb.png
      Thanks.

  • @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 ปีที่แล้ว

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

    • @technologiate
      @technologiate  ปีที่แล้ว

      It only works with the columns

  • @razakhan380
    @razakhan380 ปีที่แล้ว

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

  • @estudiovarianza
    @estudiovarianza ปีที่แล้ว

    Thank u so much for this video!

  • @atty.rexlynanneevora1314
    @atty.rexlynanneevora1314 ปีที่แล้ว

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

  • @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.

  • @kylewilliams4721
    @kylewilliams4721 2 ปีที่แล้ว +1

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

    • @technologiate
      @technologiate  2 ปีที่แล้ว

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

  • @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?

  • @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.

  • @sarrycky
    @sarrycky 10 หลายเดือนก่อน +3

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

    • @ITGrandWisata
      @ITGrandWisata 8 หลายเดือนก่อน +1

      yea sadly

    • @EnricoGarciaDrums
      @EnricoGarciaDrums 3 หลายเดือนก่อน

      Is there any alternatives?

    • @sarrycky
      @sarrycky 3 หลายเดือนก่อน

      @@EnricoGarciaDrumshandmade by google appscript😅

  • @mentis72
    @mentis72 2 หลายเดือนก่อน

    😅create the event only after an approver had authorise it?

  • @bensteyn1974
    @bensteyn1974 2 ปีที่แล้ว +1

    Thank you!

  • @amadoucisse2692
    @amadoucisse2692 10 หลายเดือนก่อน

    Why no template?

  • @HajarElAmraniElIdrissi-w8k
    @HajarElAmraniElIdrissi-w8k 10 หลายเดือนก่อน

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

    • @technologiate
      @technologiate  10 หลายเดือนก่อน +1

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

  • @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?

  • @technologiate
    @technologiate  หลายเดือนก่อน

    *Sync Outlook Calendar with Google Calendar using Power Automate:* th-cam.com/video/33SWmcCFXNs/w-d-xo.html

  • @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.
      🙂🙂🙂

  • @hajarelam
    @hajarelam 10 หลายเดือนก่อน

    Can we add the link of the meeting ?

    • @technologiate
      @technologiate  10 หลายเดือนก่อน

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

  • @phantazzor
    @phantazzor 10 หลายเดือนก่อน

    what if the time is already taken ?

    • @technologiate
      @technologiate  10 หลายเดือนก่อน

      Still, it will create the event.

  • @pakiatanonlinecoachingcenter
    @pakiatanonlinecoachingcenter 8 หลายเดือนก่อน

    Not working

  • @Torq123
    @Torq123 ปีที่แล้ว

    the Add on app has 2.5 rating

  • @reaper8f
    @reaper8f ปีที่แล้ว

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

  • @tvcasa8217
    @tvcasa8217 ปีที่แล้ว +2

    Thank you!

    • @technologiate
      @technologiate  ปีที่แล้ว

      Thank you🙂
      Please like, share & subscribe.