Sync Gusto payroll to Google Sheets every payday

Every payday at 6:00 PM, sync every processed Gusto payroll from the past 7 days into a Google Sheets ledger tab for the finance team. This is a deterministic node-based code workflow with no reasoning required. Trigger: cron, scheduled to match the company's pay cadence (default: every Friday at 18:00 in the org's timezone; adjust to biweekly or semimonthly as needed).

Step 1. Call gusto.List Payrolls with processed=true and a check_date range covering the last 7 days ending at the current run time. Paginate explicitly: increment the page parameter and keep reading until X-Total-Pages is reached (do not rely on the default cap). Collect the full array of payrolls returned across all pages.

Step 2. For each payroll in that list, call gusto.Get Payroll using the payroll UUID. This returns the full per-employee compensation breakdown (employee_compensations), pay period start and end, check date, and totals including employer taxes and employee taxes per employee.

Step 3. Flatten the results into one row per employee per payroll. For each employee_compensation on each payroll, build a row with these columns in order: check date, pay period start date, pay period end date, employee full name, department name, gross pay, net pay, employer taxes total, employee taxes total, payroll UUID.

Step 4. Call google-sheets.Append Values once with the full batch of rows against the configured spreadsheet ID and tab name (for example, 'Payroll Ledger!A:J'). Use USER_ENTERED as the value input option so Sheets keeps the values as-is.

Important nuances to bake in. Gusto returns money and hours as decimal strings such as "1234.56" to avoid floating-point precision loss. Do not convert these to numbers in code; pass the exact strings straight through into the Sheets row so precision is preserved. Include the payroll UUID column so finance can dedupe on the rare chance two runs overlap. If the List Payrolls call returns zero processed payrolls in the window, append nothing and finish cleanly. Spreadsheet ID, tab name, lookback days, and timezone should be configuration inputs on the workflow so finance can point it at their own ledger. Employee name should be concatenated from first and last name; department comes from the department object on each employee_compensation (fall back to an empty string if unassigned).

Output: an append-only Google Sheets ledger that finance can pivot however they want, updated automatically every pay cycle.