Back to all

Google Sheets

  • Spreadsheet

The Google Sheets Synapse enables bidirectional data synchronization between Google Sheets and Syncari entities using the Google Sheets API.

A root folder in Google Drive is required in order to enable the Google Sheets Synapse configuration. All subfolders under this root folder are treated as entities in Syncari. And all Google Sheets in these folders are used for field mapping and syncing data.

How It Works

The Google Sheets Synapse enables Syncari to replicate the schema of your Google Sheets and make it available within the unified data model in Syncari. Subfolders from Google Sheets can be mapped to entities in Syncari using the powerful Sync Studio. Changes on the Google Sheets within these subfolders are periodically (near real time) synced into Syncari. Syncari provides a flexible conflict resolution strategy in cases where multiple updates are noticed for the same record. The data can be enriched, deduped and cleansed before storing it in Syncari. Data flowing from different systems into Syncari is synced to Google Sheets. Any schema changes like, addition of new field, field rename, etc in Google Sheets are auto detected and the user has the option of auto mapping.