Create a Calendar Event From a Google Form Submission

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

  1. Open a blank Google Form
  2. Give the form a Title.
  3. On the Questions tab, include an Event Title.
  4. Click on the default question. We recommend labeling it Event Date. The Multiple choice drop-down changes to Date.
    QuestionsTabHL.png
  5. Click the Settings tab at the top to see how responses are collected and the defaults for email addresses and questions.
  6. Changes settings as necessary.
  7. 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.
LinkToSheets.png

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.

  1. Open a Google Sheet
  2. Create column headers and set parameters. 
  3. Click Tools.
  4. 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

 

Articles in this section