Unable to export to Google Sheet

I appreciate all the steps you've performed to resolve the issue. 

Since the issue persists, I recommend contacting our QuickBooks Online Support Team. It allows them to look into your account and confirm the problem.

To speak with one of our experts from QuickBooks Online Support. Please follow the steps below to contact support:

1. Sign in to your QuickBooks Online company. Click Help (?).

2. Select either tab: Assistant or Talk to a Human.

3. Search or select Contact Us.

4. Start a chat with a support expert.

You can contact us from Mondays to Fridays, 6 AM to 6 PM PT, and Saturdays, 6 AM to 3 PM PT.

You can utilize this article for future reference: Common custom reports in QuickBooks Online.

For additional QuickBooks-related concerns, don't hesitate to post them here in the Community. We're always available and willing to lend a hand to your queries. Have a great day ahead.

Hi James, 

I've spoken with two members of the QB online support team and they were not able to provide a solution. So I was hoping that someone in the QB community would have a solution. 

Is there someone that from your product or engineering team that could review the issue with me?

I have spoken with 2 reps from the online support team and they were not able to provide a solution. Hoping that posting to the QB community will help find the solution. 

I know this hasn't been an easy process for you, cmorrison. I appreciate you for performing all the possible steps to resolve this.

Let me make it up to you by ensuring this error gets fixed so that you'll be able to export your report.

Since you're exporting data for the first time in this QuickBooks Online company, let's ensure you have a Google account already created. After that, let's adjust your web browser settings to allow pop-up windows from QuickBooks Online. It could be the cause of the issue.

If you're using Google Chrome, please follow these steps:

1. Open Chrome, select More, then select Settings.
2. Select Advanced.
3. Under Privacy and security, select Content settings.
4. Select Pop-ups and redirects.
5. Switch the setting to Allowed or Blocked.
6. Add QuickBooks Online:
   1. To the right of Allow, select Add.
   2. Enter qbo.intuit.com.
   3. Select Add.

Also, I've added the list below of the things that need to be considered:

• Various toolbars also have their pop-up blockers. The menu options or icons for the blocker will vary between different toolbars.
• Try hovering your mouse pointer over each icon; text should appear describing what the icon does. Normally, when you're hovering over the blocker icon, it'll list the number of pop-ups blocked or current on/off status.
• If your QuickBooks Online pop-ups are still blocked, you can use the Windows hotkey by holding down the CTRL key before clicking the button or link that brings up the pop-up window.

Once done, we can now export QuickBooks reports to Google Sheets. This is a UK article but works in US versions.

If the issue persists, I suggest using other supported browsers. Then, make sure to check for pop-up blockers. We can also try using other devices to ensure this gets sorted out.

Aside from checking the popups and using other browsers and devices, are you using any ad blockers? We'll want to check those ad blocker plugins within your browsers and disable them on QuickBooks-related pages. 

Additionally, I've added these articles that'll help you in managing and personalizing your reports in the program:

• Run reports in QuickBooks Online
• Customize reports in QuickBooks Online

You can always reply here if you have more concerns about managing reports. If you need to take care of your entries, tax forms, and lists, let us know and we'll get back to you as soon as possible. 

I am still unable to export reports to sheets. I tried the following steps:

1. I have a google account

2. Added qbo.intuit.com to the allowed sites per your instructions

3. Used an incognito session 

4. Used Edge browser

I've had two members of my team try to export to sheets and they are experiencing the same issue. We work remotely, so everyone is using a different internet connection. 

Any ideas what next steps to try?

Thanks for getting back to the thread, cmorrison-rvshar. I appreciate your troubleshooting steps to solve your concern.

Thank you for trying the steps provided by my colleagues. If you're able to export through Excel and not through Google Sheet, we suggest contacting Google for further investigation and help. There may be browser settings and extensions that interfere with the connection to Google Sheets, resulting in the error appearing. If anything else comes up, I recommend reaching out back to us.

The following articles will help you manage reports in QuickBooks Online:

• Run reports in QuickBooks Online
• Customize reports in QuickBooks Online

I'm always here to help you. Just click the Reply button below if you need further assistance with any QuickBooks-related concerns. Have a nice day!

I was able to resolve this issue. I was looking through the apps module for a separate reporting app and noticed that there was an app there called "google sheets integration". (see attached screenshot)  I was not able to launch, disconnect or edit the app and neither did the primary admin (which is also strange-->why would the primary admin not have access to edit ALL apps connected to the company QB account??). 

The other company admin did have access to edit the app. This person was not the original person to connect the app. That person has left the company and the account was deleted. The other company admin disconnected the app. At which point we both were able to successfully allow QB to export to google sheets. 

Replying with our resolution in case you have another user with similar issues. 

I have been trying to figure this out for months with no luck from QB support. Thank you for posting this, we figured out the admin with the connection and fixed it in 5 minutes! 

After your Admin disconnected the app, did they reconnect it?

Yes, an admin will have to reconnect. This can be accomplished by running the report you want to export to google sheets (ie Profit and Loss report). At the top right of the report select the export button (between the print and gear icons). Select "Export to Google sheets" and follow the prompts.