> ## Documentation Index
> Fetch the complete documentation index at: https://docs.summation.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Google Sheets

> Connect a Google Sheets workbook and materialize each selected worksheet as a typed Summation table.

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.

<Tip>
  Summation requests read-only Google Sheets access. It cannot edit the
  workbook.
</Tip>

## Connect the workbook

1. In Summation, open **Data** and select **Add connector**.
2. Choose **Google Sheets**.
3. Enter a connector name and the workbook's **Spreadsheet URL or ID**.
4. Select **Connect Google** and authorize Summation with a Google account that can view the workbook.
5. Select **Test connection**, then continue.
6. 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

| Error or symptom                 | Likely cause                                                                             |
| -------------------------------- | ---------------------------------------------------------------------------------------- |
| Access was denied                | The Google account used to connect Summation cannot view the workbook.                   |
| Spreadsheet was not found        | The URL or ID is incorrect, or the connected Google account cannot see the workbook.     |
| Google authorization expired     | Reconnect with Google, then retry the refresh.                                           |
| No worksheets appear             | The workbook contains no visible grid worksheets. Hidden tabs are not listed.            |
| Worksheet must have a header row | The selected worksheet is blank or its first row contains no column names.               |
| A refreshed column changed type  | Values in the worksheet changed from a consistent numeric or boolean type to mixed text. |