Apps Script - Create Calendar Event From a Form
Join my free tech newsletter:
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:
Here's the live copy of the form I used:
️Don't forget to create a trigger.
=============================
Find me
on LinkedIn:
on Twitter:
on website:
️ Office items I can't live without:
(amazon)
Course Suggestions:
► Advanced Data Analytics Certificate by Google: (coursera)
► Cybersecurity by Google: (coursera)
►Need a powerful automation tool for Google Sheets? Try Coefficient to automatically import data and sync with your business systems:
=============================
⌚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
=============================
