Apps Script - Create Calendar Event From a Form
🚀Join my free tech newsletter: https://got-sheet.beehiiv.com/
How to create Google Calendar events and email guests when you submit the information on a Google Form. I walk through each step in detail. Beginner friendly! Don't be scared.
So, I did not realize before filming this tutorial that there’s no way to share a Google Form with others to copy without giving everyone editing rights.
Check out the script and instructions on this doc: https://docs.google.com/document/d/1f...
Here's the live copy of the form I used: https://docs.google.com/forms/d/e/1FA...
⚠️Don't forget to create a trigger.
=============================
📲 Find me
on LinkedIn: / eamonncottrell
on Twitter: / eamonncottrell
on website: https://www.eamonncottrell.com/
🖥️ Office items I can't live without:
https://amzn.to/3uqSO7Q (amazon)
🎓Course Suggestions:
► Advanced Data Analytics Certificate by Google: https://imp.i384100.net/21dWGa (coursera)
► Cybersecurity by Google: https://imp.i384100.net/VmN6oM (coursera)
►Need a powerful automation tool for Google Sheets? Try Coefficient to automatically import data and sync with your business systems: https://coefficient.io/?via=984f9f
=============================
⌚Chapter Time Markers:
00:00:00 - What we're doing
00:00:43 - The Form
00:01:29 - The Apps Script
00:02:02 - The Trigger
00:03:18 - The Code
00:04:58 - The Date Time
00:07:16 - The Calendar ID
00:08:09 - The Test
=============================
#exceltips #googlesheets #spreadsheets #dataanalytics #excel #productivity #googleforms #googleappsscript #appsscript
