Event-o-Matic is a Google Sheets Add-on that lets you merge spreadsheet data into calendar events. Let's take a 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 using 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. The Multiple choice drop-down should change to Short answer.
- Click Add Question from the menu at the right.
- It’s recommended to label it Event Date. The Multiple choice drop-down should change to Date.
- Click Settings in the top right to see who can respond to the form.
- Changes settings as necessary.
- Click Save. The user is now set to send the form to the recipients.
- 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 Create Spreadsheet icon to open 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 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.