How to add events to a Google Calendar and email guests all from a Google Sheet using Apps Script and a button.
⭐ Get the FREE sheet here - https://www.gotsheet.xyz/c/sheets-to-...
UPDATE: I made another video showing how to create All Day Events and also how to add some more options like descriptions to the invites. Check that out here after you watch this one: • Apps Script - All Day Calendar Events...
CalendarApp Class: https://developers.google.com/apps-sc...
We receive commission on purchases made through some links on this page
_______________________________________________
🎓Software Recommendations:
► Starting a Newsletter? Check out Beehiiv with a free trial and 20% off your first 3 months: https://www.beehiiv.com/?via=eamonn
► ConvertKit - creator marketing & newsletter platform - https://partners.convertkit.com/358pj...
► HubSpot free CRM software for sales, marketing, customer service, operations teams. https://hubspot.sjv.io/c/4186908/1001...
► Notion - productivity & note-taking app - https://affiliate.notion.so/p7771a8zwlsu
► Carrd - one page landing sites - https://try.carrd.co/s4x1c97b
► Coefficient - import data and sync with your business systems in Google Sheets - https://coefficient.io/?via=984f9f
_______________________________________________
🎓Data Course Suggestions: (coursera)
► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa
► Microsoft Power BI Data Analyst Certificate - https://imp.i384100.net/4PgjK3
►Microsoft Business Analyst Certificat - https://imp.i384100.net/anamAq
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM
► Google Cloud Data Analytics Certificate - https://imp.i384100.net/B0ZJb0
_______________________________________________
🎓AI Course Suggestions: (coursera)
► IBM AI Developer Certificate - https://imp.i384100.net/B0ZR9L
► Overview IBM AI Engineer Certificate - https://imp.i384100.net/KjnyA9
► Google AI Essentials - https://www.coursera.org/learn/google...
_______________________________________________
🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)
📲 Find me
on LinkedIn: / eamonncottrell
on Twitter: / eamonncottrell
_______________________________________________
⌚Chapter Time Markers:
00:00:00 - Intro
00:00:42 - I'm Eamonn. You're awesome
00:00:54 - Time in Google Sheets
00:01:07 - Dropdown Times
00:03:08 - Combine Date and Time
00:04:17 - Create a Calendar
00:04:44 - Apps Script
00:06:19 - For Each Loop
00:08:30 - Run Function with Button
00:09:44 - Optimize Columns
=============================
#googlesheets #spreadsheets #dataanalytics #googlecalendar #appsscript