Google Sheets

An online spreadsheet editor from Google.

πŸ•β€πŸ¦Ί Setup guide

This guide will help you set up Google Sheets as a data source for Zenskar.

πŸ“–

Information

Zenskar's Google Sheets data-source connector pulls data from a single Google Sheets spreadsheet. To replicate multiple spreadsheets, set up multiple Google Sheets data sources.

βš™οΈ Set up data source and type

  1. Log into your Zenskar account.
  2. In the left navigation bar, click Metering > Data Sources. In the top-right corner, click + ADD DATA SOURCE.
  3. In the Set Up Source section of the Add New Data Source page, enter a name for the Google Sheets data source connection.
  4. Select Google Sheets from the Source Type dropdown.

βš™οΈ Configure data source

  1. In the Source Config section of the Add New Data Source page, select the Service Account Key Authentication option.
  2. Enter the phrase Service for auth_type.
  3. To authenticate your Google account via Service Account Key Authentication, enter your Google Cloud service account key in JSON format. If your spreadsheet is viewable by anyone with its link, no further action is needed. If not, give your Service account access to your spreadsheet.

🚧

Permissions

Please make sure the Service Account has the Project Viewer permission.

πŸ‘

Security

Zenskar only accesses the spreadsheet you want to replicate. We do not access any other file in your Google Drive.

  1. For Row Batch Size, define the number of records you want the Google API to fetch at a time. The default value is 200.
  2. For Spreadsheet Link, enter the link to the Google spreadsheet. To get the link, go to the Google spreadsheet you want to sync, click Share in the top right corner, and click Copy Link.

🚧

Naming restrictions

Google Sheet names and column headers must contain only alphanumeric characters or _. For example, if your sheet or column header is named the data, rename it to the_data. This restriction does not apply to non-header cell values.

πŸš€ Performance consideration

The Google API rate limit is 100 requests per 100 seconds per user and 500 requests per 100 seconds per project. Zenskar respects these rate limits and batches requests to the API in order to efficiently pull data.