Event-o-Matic is a Google Sheets Add-on that lets you merge spreadsheet data into calendar events. Let's look at two ways to create a Calendar event from a Google Form. The first way is using a blank Google Form. The second way is to use a Google Sheet to create the Google Form.
Creating a Calendar Event Form From a Blank Google Form
- Open a blank Google Form.
- Give the form a Title.
- On the Questions tab, include an Event Title.
- Click on the default question. We recommend labeling it Event Date. The Multiple choice drop-down changes to Date.
- Click the Settings tab at the top to see how responses are collected and the defaults for email addresses and questions.
- Changes settings as necessary.
- Click Send at the upper right corner to email the event form to recipients. The option to include the form in the email is included.
Viewing Responses
Once the email has been sent, you can check the responses by selecting the Responses tab in the Google Form. Click the Link to sheets link to link to a new or existing a spreadsheet to view the responses to the form in real-time.
Creating a Google Form From a Google Sheet
When you create a Google Form from a Google Sheet, you are creating a blank new form that’s automatically linked to that spreadsheet.
- Open a Google Sheet.
- Create column headers and set parameters.
- Click Tools.
- Click Create a new form.
Note: Event-o-Matic can be installed on Spreadsheets with existing Form Responses when the required information is already in the Sheet. Learn more
Visit Merge on Form submit to learn how to perform a merge to your Sheet every time the form is submitted.
Document Version | Date | Description of Change |
1.0 | 7/16/2024 | revised text and screenshots, reverified |
1.1 | 1/27/2025 | Reverified |