How to create a Calendar event from a Google Sheet

1. The user will first need to create and name column headers in the spreadsheet, since Event-o-Matic will use this information to create a calendar event.

  • Common header names might include What (Event Title and Event Description), When (Start and End Date, Start and End TIme), and Who (Guest List).
    • If guests are going to be included, there must be a designated column that includes valid email addresses. An example header could be labeled Guest List.
    • The spreadsheet must contain a minimum of two header entries (Note: This would be used for full day events).

2. Once the headers are labeled, it’s a good idea to fill out at least one row of data. Next, click on Add-ons, hover over Event-o-Matic and select Configure.

3. Once the add-on is displayed, you can follow the instructions on how to proceed.

  • In the first step, select the calendar in which events will be created. If the user is using a primary calendar, then the user’s email address should be selected from the list. Next, select the Sheet of data that contains all the calendar information
    • Click on Next to save the settings in each step.
  • In steps two and three, match the appropriate input with the column header designated in the spreadsheet. For example, if column header is named “Title of the event” then you would select that under the “Event Title” dropdown menu.
    • In the third step, the user is given the option to create full day events instead of events with a start and end time. If your date and time appear in the same column, then select the box Date and time are combined. If they are in separate columns, leave the box unchecked.
  • The fourth step will show a summary of all the selections made. The user can go back to any previous step and change the settings by clicking on the appropriate blue checkmark on the top timeline.  
  • The fifth and final step will include a preview screen, which shows the date and time of the event, description of the event, email addresses of who will be invited to the event, the organizer’s Calendar, and the time zone. Click the big blue checkmark, and the events will be created!

Additional column headers will have been created at this point: Event Status and Event Link. Event Status will let the user know if the event was successfully created, and the Event Link will provide a link to the calendar event that you can use to open the event directly from the spreadsheet.

Step 1 (Source & destination)

 

Step 2 (Selecting the event information)

Step 3 (Selecting the event type)

 

Step 4 (Summation)

Step 5 (Event preview)