> ## 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)


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.