Google Sheets & Excel
Pull your live forecast into Google Sheets.
Mint a signed, scoped, expiring export link and paste it into =IMPORTDATA(). Your
Pipemetry forecast, pipeline, and accuracy grids land in a Google Sheet and refresh on
Google’s schedule — the same numbers you see in the app, in the tool your team already builds
board decks in. Excel works too, through Power Query.
14-day full-Pro trial, no card · Read-only, revocable export links
One formula
IMPORTDATA-ready — paste a link, the grid appears
Mint a signed export link in the app and drop it into a Google Sheets =IMPORTDATA() cell. Your Pipemetry forecast, pipeline, or accuracy grid lands in the sheet — the same numbers you see in the app, in the tool your team already builds board decks in. It refreshes on Google’s own schedule, so treat it as a regularly-updated pull, not a real-time stream.
- Paste one =IMPORTDATA() formula — no add-on, no script
- The grid populates and refreshes on Google’s cadence
- Same figures as the app, from the same reconstructed data
- CSV/TSV under the hood — exactly what IMPORTDATA expects
A credential you control
Signed, scoped, expiring, revocable
Each export link is HMAC-signed, scoped to a single grid, and time-limited — it is read-only and carries no broad OAuth access to your Google account. A workspace admin mints it, and can revoke it at any time. When a token expires the link simply stops returning data until you re-mint it, so a stale link never leaks.
- HMAC-signed, member-scoped, read-only export tokens
- Bound to one grid — a link can’t reach data it wasn’t minted for
- Time-limited: expires and is re-mintable, revocable any time
- No broad Google OAuth — the token lives in the link, nothing else
Every grid
Forecast, pipeline, and accuracy — exportable
The same grids you read in Pipemetry can flow into a sheet: the forecast roll-up, the pipeline, and the accuracy scorecards. Build the board deck, the QBR tab, or the ops model on top of live numbers instead of a copy-paste from last week.
- Forecast roll-up — commit, best case, projected total
- Pipeline and coverage grids
- Accuracy scorecards (MAPE / bias) per owner
- One link per grid — combine them in one workbook
Excel too
The same signed link feeds Excel
Prefer Excel? The same signed URL works through Excel’s “From Web” / Power Query, so a workbook can refresh the grid on demand. As with Google Sheets, the link stops refreshing once the token expires — re-mint it in the app to renew.
- Excel “From Web” / Power Query reads the same signed link
- Refresh the workbook on demand
- Re-mint the token when it expires to keep it live
- Read-only — Excel never writes back to Pipemetry
The other direction
No CRM? Forecast from a spreadsheet instead
This page is about pulling your forecast out into a sheet. If you don’t have a supported CRM and want to forecast from a spreadsheet, that’s a different flow — upload a CSV or Excel export and Pipemetry builds the forecast for you. See forecast from a spreadsheet.
- Data OUT: pull a live grid into Sheets or Excel (this page)
- Data IN: upload a CSV/Excel to forecast without a CRM
- Both keep your numbers transparent and inspectable
- Build on the API too — see the developer surface
Read-only, and no lock-in
Export links only ever read your own data, and they’re one part of Pipemetry’s wider data-out story. For programmatic access, a workspace admin can also mint a scoped, revocable key for the read API and HMAC-signed webhooks. Your numbers are yours — see how we secure the export tokens.
Google Sheets integration FAQ
How do I connect Pipemetry to Google Sheets?
A workspace admin mints a signed export link in the app, and you paste it into a Google Sheets =IMPORTDATA() cell. The forecast, pipeline, or accuracy grid appears in the sheet and refreshes on Google’s schedule. There is no add-on to install and no broad OAuth to your Google account.
Is the export link secure?
Yes. Each link is HMAC-signed, scoped to a single grid, read-only, and time-limited. An admin can revoke it at any time, and when the token expires the link stops returning data until it is re-minted — so a stale or shared link can’t keep pulling your numbers.
Does it work with Excel?
Yes. The same signed URL feeds Excel through “From Web” / Power Query, so a workbook can refresh the grid on demand. As with Google Sheets, the link stops refreshing once the token expires — re-mint it in the app to renew.
Does the data refresh automatically, in real time?
Not in real time. IMPORTDATA refreshes on Google’s own schedule, so the sheet updates periodically rather than the instant a number changes in Pipemetry. It is a live pull, not a streaming feed.
Which grids can I export?
The forecast roll-up, the pipeline and coverage grids, and the accuracy scorecards. Each is a separate signed link, so you can combine several grids in one workbook.
Put the forecast where your team already works.
Connect Salesforce or HubSpot, then pull the numbers into a Sheet with a signed link. No CRM yet? Forecast from a spreadsheet instead.