Hi there, JohnnykT. Allow me to route you to our support team who can assist you with this matter.
I appreciate the efforts you've made to export your report to Google Sheets. Since you're encountering issues with selecting the sheet and it's only creating a new file, I suggest contacting our Customer Support team. They have the tools to verify the integration and review the exported data.
To reach them, follow the steps below:
1. Log in to your QuickBooks Online company.
2. Click on Help (?) and head to the Search tab.
3. Select Contact US, then pick Ask about something else.
3. Enter your concern in the designated box and hit Continue.
4. Choose how you would like to connect with an expert: Start a chat or Get a callback.
Please also note their support hours so you can connect with them accordingly. For more information, visit this page: QuickBooks Online Support.
Additionally, I've added these articles that'll help you in managing and personalizing your reports in the program:
If you have other questions while working with your data through Google Sheet or concerns with QuickBooks, let me know by leaving a comment below. I'm just a few clicks away to help.
