While we cannot integrate with Xero directly, we can create a custom sales by product report which you can schedule to Google Sheets to enable your Xero integration. If you have different line item account codes, we can discuss how to create custom fields for this in Better Reports as well.
In addition to custom reporting, Better Reports offers more than 80 built-in reports that cover your most common reporting needs including sales, current inventory, refunds, payouts, and more. We can also help create custom reports to automate much of your daily workflows. Reports can be exported to CSV, Excel, HTML, PDF or scheduled to send to email in the same format or to Google Sheets.
I encourage you to install Better Reports and start your free 14-day trial and I'll be happy to set this up for you.