Synchronize Service

What is Synchronize service?

Synchronize service refers to keeping data across multiple systems consistently. In Sheet Director Synchronize service refers to keeping data consistent between Google Sheets and other applications.

Note: Currently synchronize service is employed in Google Calendar App in Sheet Director and this will get extended to all the integrated apps gradually.

How Synchronize services work?

Note: Synchronize is explained in the context of synchronization between Google Sheets and Google Calendar. It will be similar in other apps too.

  • Select the service as Synchronize Events.

  • Configure the service as shown below

  • Select the Calendar required so that the events from the calendar will be displayed in the selected spreadsheet.

  • Select the dates for Filters.

  • Select the start date required.

  • Select the End date required.

  • Click "+" to add more filters.

  • Select the Max results required.

Synchronize settings:

Synchronization Keys:

The keys will be used for matching rows in Google Sheet with data in Google Calendar.

Conflict Resolution:

  • When Synchronization happens, there could be a conflict of data between Google Sheets and App

  1. [App] Wins - where App is the currently selected App (e.g. Google Calendar)

  2. Sheet Wins

App Wins: Latest data from Google Calendar will be updated into Google Sheet.

Sheet Wins: Latest data from Google Sheet will be updated into Google Calendar.

Note: The major requirement in synchronization is the synchronize keys. If any of the keys is not having a value in the Google Sheet then Sheet Director will create it first and then the service will be executed.

  • Configure the services as required and then click Execute to execute the service.

  • Once execution is done the records will be assessed and ready for synchronization.

  • The number of data that will be updated in Google Sheet will be displayed.

  • The number of data that will be added to the Google Calendar will also be displayed.

  • Click Sync Now to carry out the update and add operations to synchronize the data.

A Sample output Sheet is shown below

  • The Status column in the Google Sheet shows the status of the data.

  • The newly updated data will be marked as Synced Successfully.

  • The old data that already exists will be marked as Already Synchronized.