Google Sheets Data Sync

Updated by Devinder Singh

This comprehensive document will walk you through the step-by-step configuration process for Google Sheet data sync and address specific use cases tailored to Google Sheet.

Standard Data Sync functionality

Please refer to Data Sync - Getting Started for the standard data sync functionality. The getting started document covers usages of data sync features valid for all integrations.

Prerequisites

  1. The spreadsheet must have a header row with a label for each column.
  2. Install the "Byteline - Data Sync & Automation" Google Sheets add-on on your spreadsheet by following the instructions outlined in the Step-by-Step Guide to Install "Byteline - Data Sync & Automation" Google Sheets Add-On.
  3. Before configuring the Google Sheets data sync, ensure your spreadsheet adheres to the format below. The first four columns provided are merely examples; naturally, you will have your own column names.

Configuring Google Sheet Data Sync

  1. Go to the Byteline Console.
  2. Click on the Create Sync button.
  3. In the "Select your first service" section, select Google Sheets.
  4. Click Sign in with Google if you are not already signed in.
  5. On the next page, click Sign in and complete the Google authorization steps.
  6. Click the Give permission button and select the spreadsheets you want to use for the data sync.
  7. The Byteline Google Sheets connection is now complete, and the data sync configuration page will update as shown below.
  8. Configure the second app you want to sync data to/from, and click Save & Proceed.
  9. Follow the steps explained in the Data Sync - Getting Started document to configure table and field mapping.

Real-time Updates

Byteline provides real-time updates from Google Sheets. Any time you create a row, update cells, or delete a row, the changes are instantly synchronized.

Note: Real-time updates are only available for manual changes to your Google Sheets.
Reauthorizing your Spreadsheet for Real-time Updates

If you have been using our Google Sheets add-on before real-time updates were supported, follow these steps to reauthorize the Byteline add-on:

  1. Open your Google spreadsheet, and click on Extensions -> Byteline - Data Sync & Automation -> Open
  2. Click OK on the below dialog presented by Google.
  3. Complete the Google authorization steps

After completing these steps, any manual changes to your Google Spreadsheet will be instantly available in a live sync.

How did we do?