Google Sheets

Google Sheets is generally available in the DataSquares connection wizard. Share the sheet with a service account, then import every tab.

1. In DataSquares, open Data Sources and choose Add data source.

2. Pick Google Sheets in the connector picker (search or browse by category).

3. Fill in the connection details below, then test the connection and save.

Connection details

Field	What to enter
Sheet	The URL (or ID) of the Google Sheet to import.
Service account	Share the sheet with your service account’s email address, then paste its JSON key.

Every tab in the sheet is imported as its own table.

The one step everyone misses

The service account is its own identity — the sheet must be shared with the service account’s email address (the …@…iam.gserviceaccount.com one), exactly like sharing with a person. Viewer access is enough.

Setup

1. In Google Cloud Console, create a service account and a JSON key for it; enable the Google Sheets API for the project.
2. Share your sheet with the service account’s email.
3. In the connection form, provide the sheet (URL or ID) and paste the JSON key.

Every tab in the sheet imports as its own table; the first row of each tab is treated as headers.

Common errors

Error	Cause / fix
The caller does not have permission	sheet not shared with the service-account email
API has not been used / is disabled	enable the Google Sheets API in the key’s project
empty tables	data doesn’t start at the top of the tab, or the header row is missing

Related

• Connector catalog — everything DataSquares connects to.
• Quickstart — from connection to shared dashboard.