You need to be logged in into Xero organization to be able to get project time.
Select from the menu Add-ons -> G-Accon for XERO -> Get Projects Data
Select Time and the fields you want to be pulled into Google Spreadsheet. The list of all time fields and descriptions can be found at Xero API documentation page.
The date range filter will be applied against the time date. Addition filters can be added for contact name, description, project name, task name, time status, and user name.
By default, the time list is sorted by time date. The time list can be sorted by contact name, description, project name, task name, time status, and user name.
Xero time list example:
Was it helpful ? Please let us know if you still have questions. Our contact email is email@example.com