Merge to multiple calendars

With Event-o-Matic, you can produce events on a single calendar or more than one calendar. Let’s take a look at what you need to do differently to populate events to multiple calendars.

Sheet setup  

To populate multiple calendars, the Sheet you set up for the Event information needs a column to hold the Calendar ID.

  • Calendar IDs for primary calendars are simply the email address of the user.
  • Calendar IDs for secondary calendars can be retrieved from Calendar Settings.
    Settings menu > Settings > Settings for my calendars > [select calendar] > Integrate calendar.

Creating events to multiple calendars in Event-o-Matic

Once you have identified and populated the calendar IDs in your Sheet of Event Information you’ll open the Event-o-Matic Setup stepper. The difference between single and multiple calendars is that by checking Advanced Mode on the stepper Welcome popup, the Merge to Multiple Calendars checkbox to the first step of the stepper, and Advanced Options is added as a step in the stepper.

  1. In Google Sheets, open the Sheet with your Calendar event information.
  2. Navigate to Add-ons > Event-o-Matic
  3. Click Setup. The Welcome popup opens.
  4. Check the Advanced Mode checkbox.
  5. Click Setup again. The Event-o-Matic Setup stepper opens.
  6. Using the Sheet of Event Information drop-down, select the Sheet that contains your event information.
  7. Using the Calendar ID Column drop-down, select the column containing calendar IDs.
  8. Using the Sheet of Event Information drop-down, select the Sheet that contains your event information.
    MultipleStep1HL.png
  9. Click Next.
  10. 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.
    MultipleStep2HL.png
  11. Click Next.
  12. 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. If your date and time appear in the same column, leave this box checked. If Date and Time separate columns, check Create full day events.
  13. 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.
    MultipleStep3HL.png
  14. Click Next.
  15. The next step lets you create a conditional event. This is optional. Events are checked and created based on the time frame, content, operator, and text you enter. Check the Conditional Event Creation checkbox. 
  16. In the Conditional Content drop-down, choose the column that contains the value to be checked against your rule.
  17. In the Operator drop-down, select the type of comparison to perform; is, is not, contains, does not contain.
  18. In the Text field, enter the text to compare against.
  19. Check the Merge events every hour checkbox to check for events that match the condition each hour.
    MultipleStep4bHL.png
  20. Click Next.
    MultipleStep5SummaryHL.png
  21. The next step shows a summary of all the selections made. If you need to change any settings, click the appropriate blue checkmark on the top timeline. 
  22. Click Preview. The preview 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. 
  23. Click the blue checkmark at the bottom right of the popup, and the events will be created!

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.

Scroll down to...

 

Once you have identified and populated the calendar IDs in your Sheet of Event Information select the Merge to Multiple Calendars checkbox (available if advanced features are enabled) and select the calendar ID column.