Planned · on the roadmap

Live spreadsheets for Ramp

Sheets is coming to Ramp: your transactions, bills and reimbursements as live tables that formulas, pivot tables and charts read directly, without exports.

  • Spreadsheet formulas
  • Pivot tables and charts
  • Scheduled e-mail reports
Planned reports

What you will build on Ramp

Each is one formula on live data. These are examples of the syntax: the column names will follow Ramp's own fields once the integration ships.

=data.transactions.sum(amount, department, A2)
Spend by department. Monthly spend per department against the budget in your sheet.
=data.transactions.count(id, receipt, "missing")
Missing receipts. Transactions still without a receipt, per cardholder.
=data.transactions.sum(amount, merchant, A2)
Top merchants. Where the money goes, ranked.
The data

Tables from Ramp

Card transactions · Bills · Reimbursements · Departments · Merchants

How it will run

Your data stays in Ramp

You will sign in with your Ramp account and give Sheets read access. Sheets runs on our servers in the EU and reads your data through Ramp's API when a sheet opens or refreshes.

Want it?

Vote for Sheets for Ramp

A thumbs up moves Ramp up the roadmap. Leave your e-mail address too and we write once, when it ships.

We use your details only to answer you. Privacy policy

FAQ

Questions

Is Sheets for Ramp available?

Not yet. Ramp is on the Sheets roadmap. Give it a thumbs up and leave your e-mail address on this page: we tell you when it is ready, and the votes decide what we build next.

What will Sheets read from Ramp?

Your transactions, bills and reimbursements, as tables: Card transactions, Bills, Reimbursements, Departments, and Merchants. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in Ramp?

It is planned read-only: Sheets reads your Ramp data and does not change it.

What works today?

Sheets works today with QuickBooks Online, Xero, Shopify, WooCommerce, BigCommerce, HubSpot, FreshBooks, monday.com, and Asana.

Want Sheets for Ramp?

Requests decide what we build next. We write once, when it is ready.

85 tools on the integrations page