QuickBooks Online employees in a live spreadsheet
Add the Employees table to a sheet as a data source named employees and its 8 columns become names your formulas, pivot tables and charts use. Sheets reads it from your QuickBooks Online company each time the sheet opens or refreshes.
Formulas on this table
=list.employees(name) Every name, once. Spills the distinct name values down the column: the row labels for the formula above.
=data.employees.count(id, name, "<>") Rows with a name. Counts the rows whose Name is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Name | name | Text |
e_mail | Text | |
| Phone | phone | Text |
| Hired | hired | Date |
| Active | active | Yes / no |
| Created at | created_at | Date and time |
| Updated at | updated_at | Date and time |
Other lists tables
Your employees, live
Invoices, bills, customers and the chart of accounts become tables that formulas, pivot tables and charts read directly. Your numbers stay current without exporting.