The Google Sheets connector discovers visible worksheets in one workbook and materializes each selected worksheet as a normal Summation table. It is read-only and supports manual or scheduled full refreshes.
What you’ll need
- The Google Sheets workbook URL or spreadsheet ID.
- A Google account with Viewer access or greater to that workbook.
Summation requests read-only Google Sheets access. It cannot edit the
workbook.
Connect the workbook
- In Summation, open Data and select Add connector.
- Choose Google Sheets.
- Enter a connector name and the workbook’s Spreadsheet URL or ID.
- Select Connect Google and authorize Summation with a Google account that can view the workbook.
- Select Test connection, then continue.
- Select the worksheet tabs to import and create the connector.
The first import starts automatically. Each selected worksheet appears as a separate Summation table when that import completes.
Worksheet behavior
- Each visible grid worksheet is selectable as a separate dataset.
- The first row is treated as the table header and must contain at least one column name.
- Blank header cells receive generated names such as
column_3.
- Duplicate header names receive stable numeric suffixes.
- Empty trailing rows are ignored.
- Scalar numbers and booleans retain typed columns. Other values are stored as text.
- Nested JSON staging tables and follow-up calculation tables are not required.
Summation tracks worksheets by Google sheet ID. Renaming a worksheet does not break its existing refresh configuration.
Refresh behavior
Google Sheets uses full refreshes. A successful refresh atomically replaces the table with the current worksheet contents. If a refresh fails, the previously materialized table remains available.
Use Refresh now for an immediate update, or enable automatic refresh and choose a schedule in the connector settings.
Common problems