Skip to main content
July 8, 2024
Question

QBO to Google sheets sync

  • July 8, 2024
  • 2 replies
  • 0 views

Im getting conflicting internet repsponses that state you can and cant connect google sheets to QBO through the new spreadsheet syncing function... I would like to update a dashboard in google sheets with a QBO report..

Thanks

2 replies

July 8, 2024

It seems that you're facing an issue with connecting your google sheets to QuickBooks Online (QBO)  through the new spreadsheet syncing function, @Grimayoj. Know that I'm here to educate you more about this feature.

Currently, the feature Spreadsheet Sync is exclusively available in QuickBooks Online Advanced or QuickBooks Online Accountant. If you're using QBO Simple Start, Essential, or Plus. You'll want to consider upgrading your subscription to achieve your goal.

Please note Spreadsheet Sync is compatible with the Office 365 version of Excel and Google Sheets.

 

For frequently asked questions about Spreadsheet Sync, feel free to check this article: Frequently Asked Questions about Spreadsheet Sync in QuickBooks Online Advanced or Accountant.

 

Moreover, you'll want to secure a copy of all your financial data out of QuickBooks before canceling them: Export reports, lists, and other data from QuickBooks Online.

 

I'm just one post away if you need assistance with any QuickBooks-related concerns. You can click the reply button below to enter your queries. You have a good one.

GrimayojAuthor
July 9, 2024

I pay for advanced but I cannot see how it works with Google sheets.. Please explain,

THanks

Candice C
July 9, 2024

Good morning, @Grimayoj

 

I appreciate you asking additional questions about using the Spreadsheet sync feature within your QuickBooks Online. 

 

Have you used the steps listed in this guide? Get started with Spreadsheet Sync for QuickBooks Online Advanced or Accountant

 

The guide provides details on how to get started with the feature, create spreadsheet report, add or edit data to your QBO Advanced company, and more. 

 

I'll be waiting for your response! 

February 2, 2025

It is totally crazy that after seven months no one can answer this simple question.  The funniest thing is that there was even a blog article about the fact that Spreadsheet Sync now works with Google Sheets.  But the blog article neglected the little detail about how to do it. 

 

In The Know: Spreadsheet Sync for Google Sheets - article

GrimayojAuthor
February 2, 2025

Ya its crazy the article title sales google sheets and then you go into the article it talks about the sync with google sheets then you click on that link and its all about Excel... And they havent fixed the article yet... 

jm