Issue exporting reports to Google Sheets

Mike Gough · ‎September 12, 2023

Hi there,

I am having issues exporting report data to Google Sheets from QBO. So when I am in a report, I click the Export to Google Sheets and when I get through to the Allow connection screen, I get a connecting error message - see image below. I have tried updating the settings in Chrome to allow pop ups from websites, as I had read that could be the issue. I have even added QBO to the allowed sites to have pop ups - see image below. Someone in my company who has admin rights (as do I) is not having any issues with the export. We have tried disconnecting the Google Sheets app and reconnecting it but no joy. Very frustrating. Is anyone else experiencing this or solved the issue? Be grateful for any tips or advice. Oh, I should also mention that I have tried Safari and that didn't work. I also tried the QBO Help and it was escalated to Tier 2 but then the new online agent disconnected without helping after I'd be on for over an hour!.

Thanks

Mike

Ashleigh1 · ‎September 12, 2023

Hello Mike, Thanks for reaching out to us on the Community page, having had a look at your account, we can see your case of yesterday has been escalated to our tier 2 team, so going forward, any updates you will be informed by email from our tier 2 team.

Mike Gough · ‎September 13, 2023

Thanks for the response. I wanted to see if the community had any experience of this issue.

Mike

Shivaniiitbhf · ‎August 10, 2024

I am having the same issue. Were you able to find the solution? Thx

IrishNinoJ · ‎August 10, 2024

Hello there, Shivaniiitbhf. We can do some troubleshooting steps to export your report to Google Sheets successfully in QuickBooks Online (QBO).

If you haven't troubleshoot your browser yet you can open your account in a private browsing window. This step can help identify if the issue is related to a cache-related problem. You can activate private mode using the following shortcuts:

Google Chrome: Ctrl + Shift + N
Safari 11 or newer: ⌘ + Shift + N
Mozilla Firefox: Shift + Ctrl + P
Microsoft Edge: Ctrl + Shift + N

If this resolves the problem, you can clear your browser's cache to refresh it. If the issue persists, I'd suggest switching to another supported browsing application.

On the other hand, if you've already performed the troubleshooting steps, I recommend contacting our customer support team so that they can investigate the root cause of the issue.

Here's how:

Select Help at the top.
Click the Search tab, then choose Contact Us.
Select a topic or enter a brief description of your concern.
Hit Continue, then select Start a chat and Get a callback.

Additionally, if you want to download the data you entered in QBO to your local hard drive, feel free to check out this article to learn how: Export data, reports, lists, and more.

Let me know if you have further questions about reports in QBO. Feel free to circle back and I'm always here to help.

Topics

Training

Community

Resources

Issue exporting reports to Google Sheets