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) =data.transactions.count(id, receipt, "missing") =data.transactions.sum(amount, merchant, A2) Tables from Ramp
Card transactions · Bills · Reimbursements · Departments · Merchants
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.
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.
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