FreshBooks vendors in a live spreadsheet
Add the Vendors table to a sheet as a data source named vendors and its 13 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.vendors(country) Every country, once. Spills the distinct country values down the column: the row labels for the formula above.
=data.vendors.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 |
| 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 |
| Account no. | account_no | Text |
| Currency | currency | Text |
| Archived | archived | Yes / no |
| Updated at | updated_at | Date and time |
Other expenses tables
Your vendors, live
Invoices, payments, expenses and time entries become tables that formulas, pivot tables and charts read directly. Your numbers stay current without exporting.