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