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.
The general flow is on Connecting an Integration. 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 |
|---|---|---|
Region, then sign in or API token | The structure of your warehouse; rows are read live | |
Sign in with Google, then pick spreadsheets | A copy of the rows of the tabs you choose |
Peliqan
Find Peliqan under the Data Warehouse tab and click Connect.
In Connect Peliqan, choose your Region — EU or US, matching your Peliqan account.
Under Authentication, choose OAuth (recommended) or API token.
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.
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
Find Google Sheets under the Data Warehouse tab and click Connect.
Sign in with Google and approve access. Google's consent screen asks for access only to the Drive files you use with Peaky.
You return to Peaky on Choose your spreadsheets.
Click Choose spreadsheets. Google's file picker opens, showing your My Drive and shared drives, filtered to spreadsheets. Select one or more.
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.
Click a tab to check how Peaky reads it (below).
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.
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 |
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/2026is 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.