Google Sheets

You connect Google Sheets from the DataSquares connection wizard. Share the sheet with a service account, then import every tab.

1. In DataSquares, open Data Sources and choose Connect Source. The Connect a data source page opens.

2. Pick Google Sheets on that page (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 with a header in row 1 imports as its own table; the first row of each tab is treated as headers.

Common errors

Error	Cause / fix
The service account has no access to this spreadsheet…	share the sheet with the service-account email (Viewer is enough), and enable the Google Sheets API in the key’s project
Google rejected the service-account key…	create a new JSON key for the service account and paste the whole file
Spreadsheet not found…	check the spreadsheet URL or ID
a tab is missing	its first row is blank — put the header row in row 1. If no tab has one, the import is refused with The spreadsheet has no non-empty tabs (each tab needs a header row).

Related

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