Create a Calendar Event From a Google Sheet

Event-o-Matic is a Google Sheets Add-on that lets you merge spreadsheet data into calendar events. Let's look at how to create a Calendar event from a Google Sheet. In this article, we’ll cover how to produce events on one calendar. If you want to produce events on more than one calendar, you can do that too.

Before You Begin

Because you are using a Google Sheet to create Calendar events, you’ll first need to set up your Sheet. Add a column header to the sheet for each piece of information your calendar event will have. The what, when, and who of the event. Here are some column header examples:

  • Event Title or Event Description
  • Start Date and End Date
  • Start Time and End Time
  • Guest List
    • If you will include guests, a designated column must include their valid email addresses. An example header could be labeled Guest List.

Note: The spreadsheet must contain a minimum of two header entries. Calendar events meeting this minimum will be full-day events in the Calendar.

Now that you've setup your Sheet, you can fill out the rows for your Calendar events and then open Event-o-Matic.

Creating Events In Event-o-Matic

  1. In Google Sheets, open the Sheet with your Calendar event information.
  2. Navigate to Extensions > Event-o-Matic > Setup. The Welcome popup opens.
  3. Check the Advanced Mode checkbox to use the Merge on form submit, Conditional event creation, or Merge events every hour features.
  4. Click Setup. The Event-o-Matic Setup stepper opens.
  5. Using the Calendar drop-down, select the calendar in which events will be created.
  6. Using the Sheet of Event Information drop-down, select the Sheet that contains your event information.
    calendarEvent1.png
  7. Click Next.
  8. In this step, you’ll match Calendar event fields to the columns in your Sheet. Select the appropriate column for the Event Title, Event Description, Guest List, and Location drop-downs.
    calendarEvent2.png
  9. Click Next.
  10. In this step, select the duration of events by matching the event start and end date/time to the columns in your Sheet. By default, the Date & time in one column box is checked. Leave this box checked if your date and time appear in the same column. If Date and Time have separate columns, check Create full-day events.
  11. Select the appropriate column for the Event Start Date and Time/Date of first day in all-day event and Event End Date and Time/Date of last day in all-day event drop-downs.
    calendarEvent3.png
  12. Click Next.
  13. You will see the Advanced Options step here if you check the Advanced Mode at the event setup Welcome. See Merge on form submit and Conditional event creation for how to use those features.
  14. The last step will show a summary of all the selections made. If you need to change any settings, click the appropriate blue checkmark on the top timeline. 
    calendarEvent4.png
  15. Click Preview. You will see the Advanced Options step here if you check the Advanced Mode at the event setup Welcome.
  16. Click the blue checkmark at the bottom right of the popup, and Event-o-Matic creates the events.
    calendarEvent5PreviewCheck.png

Additional column headers will have been created at this point: 

  • Event Status: Lets the user know if the event was successfully created.
  • Event Link: Provides a link to the calendar event that you can use to open the event directly from the spreadsheet. 

 

Document Version Date Description of Change
1.0 7/16/2024 Updated images, reverified
1.1 1/27/2025 Added advanced options steps

 

Articles in this section