You can use Awesome Table Connectors to export data from Xero to Google Sheets by logging in with the Xero connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the Xero connector.
On the Connect to Xero screen, click Sign in with Xero.
On the Xero login page, enter your email address and password then click Log in.
Xero prompts you to grant access to Awesome Table. Click Allow access.Awesome Table informs you if your connection is successful.