# Data Warehouses & Spreadsheets

Some of your figures live outside any accounting or operational system — in a data warehouse, or in spreadsheets your team maintains. **Peliqan** and **Google Sheets** bring those tables into the **Data** page, where you build your own metrics on them. You find both under the **Data Warehouse** tab on the **Integrations** page.

Neither comes with built-in metrics: what you measure is up to you. You build your own from their tables on the **Data** page — see [Metrics](/doc/metrics-gXNet88OrA).

The general flow is on [Connecting an Integration](/doc/connecting-integrations-XTfOCgvGYz). When your company has more than one legal entity, connect from the **Integrations** page of the entity that should own the data.

| Integration | How you connect | What Peaky keeps |
|-------------|-----------------|------------------|
| [Peliqan](#peliqan) | Region, then sign in or API token | The structure of your warehouse; rows are read live |
| [Google Sheets](#google-sheets) | Sign in with Google, then pick spreadsheets | A copy of the rows of the tabs you choose |


---

## Peliqan


1. Find **Peliqan** under the **Data Warehouse** tab and click **Connect**.
2. In **Connect Peliqan**, choose your **Region** — **EU** or **US**, matching your Peliqan account.
3. Under **Authentication**, choose **OAuth (recommended)** or **API token**.
4. With OAuth, click **Connect** and sign in to Peliqan to approve access. With an API token, paste your personal Peliqan token into **API token** and click **Connect**.
5. You return to Peaky; the card is marked **Connected** and the first sync starts.

**What syncs:** the **structure** of your warehouse — its databases, schemas and tables, with each table's columns — so the tables are there to browse on the **Data** page. Peaky does **not** copy the rows. When you preview a metric, or when Peaky recalculates saved metrics after a sync, it queries Peliqan **live** for the rows it needs, so figures reflect what is in your warehouse today.

* Tables, schemas or databases that no longer exist in Peliqan are removed from Peaky on the next sync.
* With OAuth, Peaky renews access in the background, so daily syncs and live queries keep working.
* A Peliqan sync's log reports how much structure it found, not a row count — rows are not copied.


---

## Google Sheets

Google Sheets works differently from every other connection: signing in with Google gives Peaky **no access to any file**. You grant access one spreadsheet at a time, in Google's own file picker, and Peaky can never see a spreadsheet you have not picked — or anything else in your Drive.

### Connect Google Sheets


1. Find **Google Sheets** under the **Data Warehouse** tab and click **Connect**.
2. Sign in with Google and approve access. Google's consent screen asks for access only to the Drive files you use with Peaky.
3. You return to Peaky on **Choose your spreadsheets**.
4. Click **Choose spreadsheets**. Google's file picker opens, showing your My Drive and shared drives, filtered to spreadsheets. Select one or more.
5. Each spreadsheet appears with its tabs. Tabs with data are ticked; hidden tabs and tabs without a data grid start unticked. Untick any you do not want.
6. Click a tab to check how Peaky reads it (below).
7. Click **Connect spreadsheets**. The card is marked **Connected** and the first sync starts.

To add or remove spreadsheets and tabs later, use the card's **Settings** — see [Integration Settings](/doc/integration-settings-H4x38V0Hgg#google-sheets-spreadsheets).

### Checking how a tab is read

Expanding a tab shows exactly what Peaky will store: which row it treated as the **header**, the **columns** it found and the type of each (`string`, `number`, `boolean`, `date` or `currency`), and the first few rows of data.

Two settings let you correct it:

| Setting | What it does |
|---------|--------------|
| **Header row** | Which row holds the column names. Leave it on **Auto** and Peaky detects it again on every sync, so a sheet that later gains a title row keeps working. Enter a row number to pin it. |
| **Range** | Limits Peaky to part of the tab, for example `A5:M`. Useful when a tab holds a table plus other content around it. |

Change either one and the preview refreshes, so you can confirm before saving.

### What gets synced

Each **spreadsheet** becomes a group on the **Data** page and each **tab** a table you can build metrics on. Peaky copies the rows on the daily schedule (and on a manual sync), so the numbers you plan against are the numbers in the sheet as of the last sync.

* **Dates** only come through as dates if the cells are **formatted as dates** in Google Sheets. A column of text like `31/01/2026` is stored as text and cannot be a metric's date column — format it as a date in the sheet and sync again.
* **Large tabs** are capped at **50,000 rows**; anything beyond that is not synced.

> **Who owns the connection.** The spreadsheet access belongs to the Google account that connected it. If that person leaves, or loses access to a spreadsheet, Peaky can no longer read it: the sheet and its synced rows are removed on the next sync, and metrics built on it stop producing values. Reconnect Google Sheets with an account that has access, and pick the spreadsheet again, to restore it.