- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Connecting a Google Sheets
CONTENTS
Home
- Overview
- Getting Started
- Managing Tenants and Spaces
- Using Development Mode
- Using Datasources
- Connecting Databases
- MySQL
- Postgres
- Amazon RedShift
- Microsoft SQL Server
- BigQuery
- Snowflake
- MongoDB
- ClickHouse
- Hive
- ETable
- Impala
- Oracle
- Teradata
- Google Sheets
- Google Analytics
- Public Dataset
- Using Projects
- Using Datasets and Reports
- Using Visualizations
- Using Dashboards
Connect to Google Sheets
bipp brings the power of queries and visualizations to your Google Sheets files. Here are the requirements for the Google Sheets file:

Here’s what you need to connect:
- GoogleSheetID

bipp supports:
- Maximum 256MB file size
- Maximum 1 million rows
- Maximum 1000 columns
Create a Google Sheets Datasource in bipp
-
Select Datasources from the Home Navigation pane to open the Datasources page.
-
Click New Datasource on the Datasources page.
-
Enter a Name. For example, TestGoogleSheets.
-
Select GoogleSheets for SQL Dialect for your database. bipp creates and enforces the rules for the selected dialect.
-
Enter the information for your Google Sheets file:
- Header: This is optional. By default first row is considered as the header
- Oauth: Click Authorize using Google to open the Google OAuth screen where you have to add/select the Google Sheet account. If you Allow drive access, GoogleSheetID is auto-added based on the sheet selection.
- GoogleSheetID: the ID follows gid= in the sheet URL.
-
Click Create to add the datasource.
Congratulations! You have successfully created a Google Sheets datasource in bipp.
IN THIS PAGE
Sign up for a forever free account!
Connect to leading SQL databases
Build visual data models without learning a new language
Create two dashboards and ten reports for free