You need to be logged in into Xero organization to be able to get projects.

Select from the menu Add-ons -> G-Accon for XERO -> Reports Designer -> Design Projects Reports

Select Projects and the fields you want to be pulled into Google Spreadsheet. The list of all project fields and descriptions can be found at Xero API documentation page.

The date range filter will be applied against the project deadline date. Additional filtering can be done by project name, contact name, and project status.

By default, the project list is sorted by project deadline date. The project list can be sorted by contact name, project name, and project status.

Xero project list example: