(100% FREE) - Auto (Bulk) Update Google Calendar from Google Sheet
As sync large number of events to Google Calendar could be painful especially your events might updated from many collaborators at the same time.
In this video, I will show you using Google Sheet allow you to let collaborators to insert event by themselves, and using addons "Sheets2GCal" will auto update to the specific calendar.
👋 Resources called out in this video:
1) Google Calendar - https://ss88.my/g-calendar
2) Google Add-ons "Sheets2GCal" - https://ss88.my/gsheet-to-calendar
3) Google Sheet - https://ss88.my/g-sheet
⌚ Timestamps:
0:00 Introduction
1:30 Prepare event list at Excel
2:00 Create new calendar (optional)
2:55 Sign Up for "Sheets2GCal"
4:20 Create a blank spreadsheet
5:00 Get add-ons "Sheets2GCal"
6:18 Link sheet (to specific Google Calendar)
7:45 Copy data from Excel to Google Sheet
9:10 Update sheet data to Google Calendar
9:55 Done, check result
10:35 Wrap Up
🚩 Connect with me on social:
ss88 (Social Bio Link) : https://ss88.my/u/technologysimplicity
Facebook: / technologysimplicity
Instagram: / technologysimplicity
LinkedIN: / technology-simplicity
🔔 Subscribe to my YouTube channel
https://ss88.my/BVCg
🎬 Want to watch again? Navigate back to my YouTube channel quickly
https://ss88.my/ts-youtube
💝 Support me with your Google Play Book purchase https://ss88.my/pshX. (Purchasing through this link gives me a small commission to support videos on this channel -- the price to you is the same)
🤝Special thanks to the people who assisted me along the journey:
1) Transition Animation Powered by KenFX Studio