FreshBooks clients in a live spreadsheet
Add the Clients table to a sheet as a data source named clients and its 15 columns become names your formulas, pivot tables and charts use. Sheets reads it from your FreshBooks business each time the sheet opens or refreshes.
Formulas on this table
=list.clients(country) Every country, once. Spills the distinct country values down the column: the row labels for the formula above.
=data.clients.count(id, country, "<>") Rows with a country. Counts the rows whose Country is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| ID | id | Text |
| Name | name | Text |
| Organisation | organisation | Text |
| First name | first_name | Text |
| Last name | last_name | Text |
e_mail | Text | |
| Phone | phone | Text |
| City | city | Text |
| Region | region | Text |
| Country | country | Text |
| Currency | currency | Text |
| VAT number | vat_number | Text |
| Client since | client_since | Date |
| Archived | archived | Yes / no |
| Updated at | updated_at | Date and time |
Other lists tables
Your clients, live
Invoices, payments, expenses and time entries become tables that formulas, pivot tables and charts read directly. Your numbers stay current without exporting.