Step-by-Step Guide to Install "Byteline - Data Sync & Automation" Google Sheets Add-On

Updated by Devinder Singh

This document explains the steps to install Byteline’s Google Sheets add-on, which is required to use Byteline’s data sync and automation with Google Sheets. This add-on appends two new columns to your spreadsheet to manage row Id and last updated time.

Installation Instructions

  1. Open your spreadsheet.
  2. Navigate to the top menu and click on "Extensions," then select "Add-ons" and choose "Get add-on.”
  3. In the Search apps text box, type “Byteline” and click on the “Byteline - Data Sync & Automation” result.
  4. Click on the Byteline add-on in the search result.
  5. Then, click the "Install" button to initiate the integration.
  6. Grant permissions from the authentication dialog from Google.
  7. Click DONE on the confirmation dialog.
  8. Close the Google Workplace marketplace dialog.
  9. Click the “Add Columns” button at the bottom of the side panel to append the two required columns to your spreadsheet.
  10. Once the columns are added, proceed to configure your data sync or automation flow using the Byteline Console.

Adding your columns

In addition to Byteline's two columns, of course, you also need to add your columns. These columns can be integrated either prior to or following the installation of the add-on. In the above screenshot, the four user-defined columns were pre-existing in the spreadsheet before the add-on installation, resulting in the two Byteline columns being appended at the end.

If you started with the blank spreadsheet and subsequently installed Byteline's add-on, you can add your columns afterward. In this scenario, the spreadsheet layout would resemble the following.

Troubleshooting

"Add Columns" button doesn't work

If clicking the "Add Columns" button yields no response, consider utilizing your browser's Incognito mode.

This issue commonly arises when logged into multiple accounts at once. So, try using an incognito window to ensure that you're logged into a single account only.

After the Byteline columns are added, you can use the standard browser mode for editing your spreadsheet.

How did we do?