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

# Google Sheets

> Sync a Google Sheet into your warehouse as a table.

## Prerequisites

* A Google Sheet you want to sync.
* A [datasource](/datasources/overview) already configured in Mora.

## Required fields

| Field           | Description                                                                    | Example                                        |
| --------------- | ------------------------------------------------------------------------------ | ---------------------------------------------- |
| **Name**        | A display name for this connection.                                            | `Marketing budget sheet`                       |
| **Schema**      | The schema name where the table will be created. Letters and underscores only. | `google_sheets`                                |
| **Table**       | The table name for the synced data. Letters and underscores only.              | `budget`                                       |
| **Sheet ID**    | The ID of your Google Sheet (from the URL).                                    | `1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms` |
| **Named range** | The named range within the sheet to sync.                                      | `BudgetData`                                   |

## Steps

1. Open **Settings → Connections → New**.
2. Select **Google Sheets**.
3. Fill in the fields above.
4. **Share your Google Sheet** with the service account email displayed in the form. Click the email to copy it, then go to your Google Sheet, click **Share**, and paste the email as a viewer.
5. Click **Authenticate**.

<Info>
  The service account email is shown in the connection form. You must share the sheet with this email address before the sync can access your data.
</Info>

## Finding your Sheet ID

The Sheet ID is the long string in your Google Sheets URL between `/d/` and `/edit`:

```
https://docs.google.com/spreadsheets/d/1BxiMVs0XRA5nFMdKvBdBZjgmUUqptlbs74OgVE2upms/edit
                                       ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
                                       This is the Sheet ID
```

## Creating a named range

1. In Google Sheets, select the cells you want to sync.
2. Go to **Data → Named ranges**.
3. Give it a name (e.g. `BudgetData`) and click **Done**.

## Related

* [Managing connections](/connections/manage)
* [Connections overview](/connections/overview)