Перейти к содержимому

How to Create a Calendar Event from a Form with Apps Script [Step-by-Step]

Eamonn Cottrell

0:00 / 0:00

How to Create a Calendar Event from a Form with Apps Script [Step-by-Step]

10 808 просмотров · 2 г. назад
Eamonn Cottrell
13,4 тыс. подписчиков
10 808 просмотров · 2 г. назад
🚀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