Datapipe
Sheet rows
A Google Sheets report of sheet rows.
Live
Google Sheets for agencies and in-house teams
Operators who already keep numbers in a sheet use Google Sheets in Datapipe to read those columns into the same reports as the other sources.
What connects
The same Google sign-in, with the spreadsheets scope, plus the spreadsheet link you paste. The first row of the sheet is treated as the column names. Values are read from A1:Z500.
What you can report on
- Column (dimension). Whatever header is in the first row of the sheet you paste.
- Amount (metric). Numeric cells in that sheet. The report does not invent metrics the sheet does not contain.
What you set up
- Sign in with Google first. Sheets is included in that consent so a report sheet can be created later.
- Paste the spreadsheet link or id on Connections.
- Create the sheet report. Only the first 500 rows and columns A to Z are read.
Limitations
This reads a sheet you already have. It does not pull a Google product by itself. Tabs other than the first range, and cells past column Z or row 500, are not read.
Last reviewed 2026-10-29. Owner: Datapipe.
Connection
Live
Live with Google sign-in plus the spreadsheet you paste. Testing mode covers up to 100 test users.
Fields
Google Sheets has no fixed marketing metric list. These are the Spreadsheet and Values resource fields. Numbers inside a sheet depend on the columns you put there. Source: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets. Read on 2026-10-27. 9 fields.
Synced today
- Date
date - Item
item - Amount
amount
Content
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| URL | spreadsheetUrl | The link to the spreadsheet. | dimension · string | Content |
Dimensions
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Spreadsheet id | spreadsheetId | The id of the spreadsheet. | dimension · string | Dimensions | |
| Title | properties.title | The spreadsheet title. | dimension · string | Dimensions | |
| Sheet id | sheets.properties.sheetId | The numeric sheet id. | dimension · integer | Dimensions | |
| Sheet name | sheets.properties.title | The tab name. | dimension · string | Dimensions | |
| Named range | namedRanges.name | A named range. | dimension · string | Dimensions | |
| Cell values | values | The cell values from spreadsheets.values.get. | dimension · string | Dimensions |
Metrics
| Name | API field | Description | Type | Group | Cross-channel |
|---|---|---|---|---|---|
| Rows | sheets.properties.gridProperties.rowCount | How many rows the tab has. | metric · integer | Metrics | |
| Columns | sheets.properties.gridProperties.columnCount | How many columns the tab has. | metric · integer | Metrics |
Cross-channel metrics
Spend, Impressions, Clicks, Conversions, and Revenue roll up on All channels when a field maps to them. ROAS is revenue divided by spend. CPA is spend divided by conversions. The Cross-channel column above shows the match.
Example reports
Destinations
Google Sheets to Google Sheets
A sheet you can open, share, and refresh.
Included on every plan.
Google Sheets to Looker Studio
Charts that read the Google Sheet this integration keeps up to date.
Included on every plan. Looker reads the sheet. There is no separate Looker install.
Google Sheets to BigQuery
A warehouse table for the same columns.
Pro and Agency plans.
Google Sheets to AI and MCP
Ask a question in plain English, or let another tool read the report through MCP.
Included on every plan. An AI key is optional.
Google Sheets to the API
Download the rows as CSV or JSON from the report.
Included on every plan.
Google Sheets to Google Drive
CSV, Excel, and an optional JSON file in a Drive folder you pick. Each client gets a Datapipe folder. The file can overwrite itself or keep the date in the name.
Included on every plan. Drive API v3 with the drive.file scope only. Enable the Google Drive API in the GCP project. Hourly, daily, or weekly.
How to connect
- Create a free account.
- Open Connections and find this source.
- Paste the key the page asks for. The steps next to the box say where to copy it.
- Open the sample report. It switches to your numbers after the key is accepted.
Refresh by plan
| Plan | Refresh | BigQuery | Price |
|---|---|---|---|
| Free | Daily | No | $0/mo |
| Starter | Daily | No | $15/mo |
| Pro | Hourly | Yes | $49/mo |
| Agency | 15 minutes | Yes | $149/mo |
FAQ
Is the Google Sheets connection live?
Live with Google sign-in plus the spreadsheet you paste. Testing mode covers up to 100 test users.
Do I have to talk to sales?
No. Create an account, connect the source, and the first report is on Home. Sample numbers stay available when a key is missing.
How often do the numbers refresh?
Free and Starter refresh daily. Pro refreshes hourly. Agency refreshes every 15 minutes on up to 50 accounts and hourly on the rest. We keep the history for you: 90 days on Free, and for as long as you subscribe on paid plans. No warehouse to set up.
Which fields are synced today?
The list marks Synced today on the fields the current connector pulls. The rest of the list is what the platform publishes, so you can see it before you sign up.