How to add Google Sheets as a DataSource for OptiSync

Using our new OptiSync feature in Designer, you can add your Google Sheets to your DataSources and apply them to your designs or our prebuilt Repeater Templates or Components.

For a breakdown of OptiSync, please visit our guide here.

Note: OptiSync is only available on Pro Plus and above plans. 

Adding Your Google Sheets as a DataSource

There are two different methods for adding Google Sheets to your DataSources:

Method 1: Through Designer

  • On the Files/Assets page, select Designer from the Apps
  • Select DataSource on the side menu, then Add DataSource
  • Click Google Sheets
  • Copy and Paste your Google Sheets URL into the provided text box, then Import the Data
    • Note: You will be prompted to sign into your Google
  • Once your Google Sheets is imported into a table in our portal, click Save
  • Name your DataSource something easily recognizable
  • Select your Synchronization and Update Interval
  • Click Done

Method 2: Through Account Settings

  • In our portal, select your account name, then More, then DataSources
  • Select Google Sheets from the list of options
  • Copy and Paste your Google Sheets URL into the provided text box, then Import Data
    • Note: You will be prompted to sign into your Google
  • Once your Google Sheets is imported into a table in our portal, click Update
  • Name your DataSource something easily recognizable
  • Select your Synchronization and Update Interval
  • Click Done
  • Your DataSource will now be listed within your Advanced Account Settings

Synchronization

  • Only once import: This option imports the data only once when you add the DataSource. After the initial import, the data will not be updated automatically.
  • Periodic direct access: This option regularly fetches the latest data directly from the device through your gateway, providing "live access" to the data and ensuring you have the most up-to-date information available directly from the device.
    • This is better for real-time updates but could cause performance issues.
  • Periodic background sync: This option periodically syncs data to your server in the background at regular intervals, reducing the need for direct queries to the device.

Update Interval

The duration of time between updates if you chose "Periodic direct access" or "Periodic background sync"

  • None
  • 30 minutes
  • 1 hour
  • 8 hours

If you'd like to learn more about OptiSync and how to use this DataSource for Data Mapping, please visit the following guide: How to Set Up Dynamic Data Mapping with OptiSync

That's it!

Now you've successfully added your Excel spreadsheet as a DataSource to be used for data mapping with OptiSync!