Gusto reporting in a live spreadsheet (planned)

Planned reports

What you will build on Gusto

Each is one formula on live data. These are examples of the syntax: the column names will follow Gusto'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 Gusto

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

How it will run

Your data stays in Gusto

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

Want it?

Vote for Sheets for Gusto

A thumbs up moves Gusto 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

Ripplingplanned

employees and payroll runs

Workdayplanned

employees and payroll runs

BambooHRplanned

employees and payroll runs

FAQ

Questions

Is Sheets for Gusto available?

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

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 Gusto?

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

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