BambooHR reporting in a live spreadsheet (planned)

Planned reports

What you will build on BambooHR

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

=data.payroll.sum(gross_pay, department, A2)

Labour cost by department. Gross pay and employer costs per department and month.

=data.pay_items.sum(hours, type, "overtime")

Overtime watch. Overtime hours per team against the budget in your sheet.

=data.employees.count(id, status, "active")

Headcount trend. Active employees per month, hires and leavers.

The data

Tables from BambooHR

Employees · Payroll runs · Pay items · Departments · Time off

How it will run

Your data stays in BambooHR

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

Want it?

Vote for Sheets for BambooHR

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

HR and payroll: also planned

Paychex Flexplanned

employees and payroll runs

ADP Workforce Nowplanned

employees and payroll runs

Deelplanned

employees and payroll runs

Gustoplanned

employees and payroll runs

Ripplingplanned

employees and payroll runs

Workdayplanned

employees and payroll runs

FAQ

Questions

Is Sheets for BambooHR available?

Not yet. BambooHR 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 BambooHR?

Your employees and payroll runs, as tables: Employees, Payroll runs, Pay items, Departments, and Time off. Each table becomes a data source that formulas, pivot tables and charts read live.

Will Sheets change anything in BambooHR?

It is planned read-only: Sheets reads your BambooHR 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 BambooHR?

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

Tell me when it's ready

85 tools on the integrations page