Connecting a Google Sheet

CONTENTS

Home

bipp brings the power of queries and visualizations to your Google Sheets files. Here are the requirements for the Google Sheets file:

  • Maximum 256MB file size
  • Maximum 1 million rows
  • Maximum 1000 columns
  • One or more sheets

Create a Google Sheets Datasource in bipp

  1. Select Datasources from the Home Navigation pane to open the Datasources page.

    Datasource Page

  2. Click New Datasource on the Datasources page.

    New Datasource

  3. Enter a Name. For example, TestGoogleSheets.

  4. Select GoogleSheets for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.

    Datasource ClickHouse

  5. Enter the information for your Google Sheets file:

    • GoogleSheetID: the ID follows gid= in the sheet URL.
    • SheetName: is the name on the tab in the sheet.
    • HeaderRange: the rows and columns containing the header information. For example, A1:Z1
    • DataRange: the rows and columns containing the data. For example, A2:Z1000
    • MajorDimension: select Rows or Columns for the dimension to use during visualizations.
    • Credentials: click Choose File and navigate to the credentials file for the sheet. The credentials file must be set up through the Google API. Refer to Datasource Google Sheets Authorizing Access to Google Sheets.
  6. Click Create to add the datasource.

Congratulations! You have successfully created a Google Sheets datasource in bipp.