Skip to main content
Gusto is payroll and HR software. SourceMedium connects to Gusto with Gusto sign-in and reads one Gusto company’s payroll, employee and contractor records into BigQuery.
Connecting requires Gusto to approve SourceMedium as an app partner, and that approval is pending. Until then the Gusto connector cannot be authorized; this page describes how it will work.
Gusto is raw data only, without modeled labor cost dashboards or Uni metrics.For delivery to a dedicated warehouse, see Choose raw tables. Choose from the tables offered under Warehouse → Raw data once data arrives.
Sign in to SourceMedium, open your store, then choose Data sources → Connect data source and select the platform. You need an Admin or Editor workspace role.After you connect explains the first sync and connection statuses.

Vendor documentation

What you need

  • A Gusto sign-in with admin access to the company this store reports on.

How to connect

1

Start in SourceMedium

Choose Gusto in the connector picker and click Authorize with Gusto.
2

Approve access in Gusto

Sign in to Gusto, choose the company and approve access. SourceMedium only reads records; it never changes payroll or people data.
Each Gusto authorization covers one company. If you run several companies in Gusto, connect each one separately. SourceMedium keeps the authorization current, and the connection asks you to reconnect if Gusto ends it.

What data syncs

Each daily sync reads a complete copy of these records for the connected company:
  • The company, its locations, departments and pay schedules
  • Employees, including terminated employees, with their jobs and pay rates
  • Contractors
  • Processed payrolls (regular, off-cycle and imported history) with their totals
  • Each employee’s pay on each payroll: gross and net pay, hours, paid time off, taxes and deductions
  • Contractor payments
A record deleted in Gusto disappears from the tables after the next sync. SourceMedium does not store Social Security numbers, EINs, garnishments, bank details, benefit enrollments or contractors’ home addresses. Employee dates of birth are stored but never included in raw data delivered to your warehouse.