Smart Sync, sync up, and sync down

You can modify Events created by Event-o-Matic in either the source Sheet or in Google Calendar, and you can bulk update via Event-o-Matic. Powerful stuff!

Once you have created some events using Event-o-Matic, changes made to an event in either the Calendar or the Sheet will cause your data to be out of sync. You'll need to run a sync to mesh the events. Smart Sync, Sync up, and Sync down options let you decide what is used for the source of truth, the last-edited time, the Calendar, or the Sheet. 

To synchronize data: 

  1. In Google Sheets, open the Sheet with your Calendar event information.
  2. Navigate to Add-ons > Event-o-Matic > Sync already-created events. A popup appears summarizing the number of events in the sheet.
  3. In the Select sync mode drop-down, select the sync direction.
    EventSyncHL.png
    Setting Description
    Smart sync: Sheet <-> Calendar

    Compares the last-edited times of the Google Calendar event and the Google Sheet row to determine which should take precedence. 


    If the Google Calendar event has been edited more recently than the Sheet, any differences detected in the calendar event information will be written to the Sheet.


    If the event data in the Sheet has been edited more recently than the Calendar, any differences will be written to the calendar event.

    Sync up: Sheet -> Calendar

    Assumes the Sheet data to be the source of truth. Any detected differences between the event data in the Sheet and the calendar event will be resolved by writing the Sheet values to the calendar event. 

    Sync down: Calendar -> Sheet

    Assumes the Calendar data to be the source of truth. Any detected differences between the event data in the Sheet and the calendar event will be resolved by writing the Calendar values to the sheet row containing the event. 


  4. Click Detect & Preview Changes.

Excluding events from the sync process

By default, syncs run on all events with an Event ID value. To exclude events from the sync by entering a Y or y in the Exclude from sync (Y) column.

EventExcludeHL.png