Google Sheets Setup Guide

Prerequisites

• Google account with access to Google Sheets
• Read / Write access to the Google Sheet you wish to connect

Setup Guide

Selecting a Named Range

1. Open your Google Sheet.
2. Select a range to be synchronized. You can do this by manually highlighting the desired cells or by specifying the range in the format Sheet1!A1:D10. This example would select columns A to D and rows 1 to 10.
3. Keep in mind that the first row of the selected range will become the column headers in your destination table. Make sure that your data has appropriate column headers. - Excluding data: Columns with a header that is empty or contains only spaces are ignored. This can be utilized to exclude specific columns.

Creating a Named Range

1. In your Google Sheet, navigate to Data > Named ranges.
2. In the sidebar, click on Add a range.
3. Enter a name for your new named range.
4. Click Done.

Finding Your Spreadsheet Link

Copy the URL of your Google Sheet from your browser's address bar. The URL uniquely identifies your Google Sheet.

Configuring Your Connector

1. Choose how to allow access to your Google Sheet:
   • Authenticate your Google account with OAuth by clicking on Sign In With Google.
   • Authenticate by sharing your Google Sheet with a dedicated Google Service Account.
2. Enter the Spreadsheet Link you found in Google Sheets.
3. In the Named Range dropdown menu, select a named range.
4. Enter a Name for the connector.
5. (Optional) Enter a Description for the connector.
6. Select the Owner of the connector.
7. (Optional) Verify that your Google account is successfully connected by clicking on Test Connection.
8. Click Connect.