What You’ll Learn
In this article, you will learn:
How to Create an Event from a Google Sheet
How to Create an Event from a Google Form Submission
What Is Event-o-Matic?
Event-o-Matic lets you create calendar events or have calendar events created off of the back of a Google Form without having to create them one by one.
Installing the Add-on
In a blank Google Sheet, you can install Event-o-Matic by navigating to Extensions > Add-ons > Get add-ons. Once the Google Workspace Marketplace window launches, search for Event-o-Matic, then select Individual Install.
How to Create an Event From a Google Sheet
To create events manually in a Sheet, start with a blank sheet and create a header row. Common headers are What (Event Title and Event Description), When (Start and End Date, Start and End Time), and Who (Guest List). Once you have those headers, fill in your event details in their respective columns. When you’re ready, go to Extensions > Event-o-Matic > Setup and follow the stepper to create the settings for your sheet.
How to Create an Event From a Google Form Submission
To create events off the back of a Forms Submissions sheet, you’ll first need to create the form. The form can have additional questions, but make sure it has at least the Event Title, Event Date, and Event Time in it. Once you start getting responses, you can open the responses in a Google Sheet and then go to Extensions > Event-o-Matic > Setup and follow the stepper to create the settings for your sheet.
Syncing Options
Once you have run through the initial setup for the sheet, you have a couple of options to sync events. These options are all found under Extensions > Event-o-Matic:
- Preview & create new events
- Scans the sheet to create any newly added events.
- Sync already created events
- Smart Sync
- It detects the differences between the calendar and sheet, and whichever source has the most recent change will be what gets made and written on the calendar/sheet.
- Smart Sync
- Sync up
- Syncs any changes from the sheet to the calendar.
- Sync down
- Syncs any changes from the calendar to the sheet.
Bulk Deleting Events
To bulk delete events, a column will be added to the sheet where you can put a Y in the column to have that event deleted. Once ready, you’ll go to Extensions > Event-o-Matic > Delete selected events.
Advanced Features
There are a couple of advanced features you can choose to use when creating events:
- Merge to multiple calendars
- You must add a Calendar ID column to your sheet to enter the calendar ID for the respective events. If you create events on calendars other than your own, ensure you have full calendar rights to prevent errors.
- Conditional merge
- You can use this if an event needs to be checked or given permission before being created. Use cases for this are time off, field trips, etc.
- Conditional Merge is also useful tool when merging events to multiple calendars.
- Merge on form submit
- You can set this feature so that any time a form submission comes it, the event will automatically get created.
Support
The best way to reach support is to enter a support ticket through the Help Center. The direct Submit a ticket link, is available at the top of every Help Center page. You can also connect with our support team by emailing support@amplifiedit.cdw.com.
If you want to obtain a support contract or have questions, reach out to a Google Customer Support Specialist.
Learn more about the various ways we can help your team.
Comments
Article is closed for comments.