Skip to main content
S
stewardship1
December 19, 2020
Question

Can I link such that my Quickbooks will automatically feed data into a Google sheet? It will dynamically auto update the Google sheet with the latest data.

  • December 19, 2020
  • 5 replies
  • 0 views
Original commenter did not share additional details

5 replies

AlcaeusF
AlcaeusF
December 19, 2020

Welcome and thanks for visiting the Community, @stewardship1.

 

Exporting to Google Sheets is a new feature included with QuickBooks Online (QBO) Advanced. The option to automatically feed data from your QBO to Google Sheets is currently unavailable. You need to manually export them as a workaround.

 

Here's how:

 

  1. Open the report you wish to export. 
  2. From the Export drop-down, select Google Sheets. 

     

    3. Enter the code sent to you by Intuit to verify it's you. 

     

     

    4. Agree to the permission by hitting Allow. 

     

 

 

Once you click Allow, your Google account will open for you to sign in to link the account. For more information about the Google sheets integration in QBO, check out this link: https://www.firmofthefuture.com/content/3-ways-to-use-google-sheets-integration-in-quickbooks-online-advanced/.

 

I can see how being able to do this would be helpful for you, and I'll take note of this. Our Product Engineers are always looking for ideas to consider how to improve QBO.

 

In the meantime, I recommend visiting our Blog site. This is where we share recent happenings and future developments, such as updates to newly added features. Here's the link: https://quickbooks.intuit.com/blog/.

 

Please click the Reply button below if you have any other questions or concerns. I'll be here to help. Have a good one!

Fiat Lux - ASIA
Fiat Lux - ASIA
December 20, 2020

@stewardship1 

Explore these apps to automate your data from QBO to GSheets.

https://automate.io?ref=quickbooks

https://www.integromat.com/?pc=quickbooks

 

A
AndreyK
April 16, 2021

Check out G-Accon for automatically synching Google Sheets with QuickBooks. You can schedule hourly data refreshes and uploads back to QBO. It also sends an email notification when the data is updated.

    C
    Chris_tina
    April 26, 2023

    We use Coupler.io data integration tool to export data from Quickbooks to Google Sheets. We tried other alternative tools but decided to proceed with Coupler since it is very easy to use, can refresh our data on a schedule and has a very affordable pricing. You can learn more about Quickbooks to Google Sheets integration here. 

    N
    Ntianu Oyakhire
    September 15, 2023

    It would be very beneficial (not to add a game changer) if Quickbooks could figure out how to add on to google sheets. I am having to manually run a report and populate my reporting template. We could save a ton of time by having the template automatically populate instead.

    S
    SirielJeaB
    September 15, 2023

    We are thrilled to have you join the Community thread, Ntianu. Thank you for getting in touch with us. We understand the relevance of utilizing QuickBooks efficiently. 

     

    We always strive to ensure that using our program is a smooth experience for you. The option to automatically populate the reporting template is not currently available in QuickBooks. Nevertheless, we would be grateful if you could share your feedback and feature requests with our software engineers. They will take your input into consideration when planning future product updates.

     

    1. Click the Gear icon, then select Feedback.
    2. Type in your feature request.
    3. Click Next to submit.

     

    As you move forward, we want to make sure that you have all the necessary resources to handle reports. Feel free to visit these articles:

     

     

    The Community is always here to help if you have other QuickBooks-related concerns. We will be pleased to have you back by clicking the Reply button or posting in our forum. Wishing you a great business adventure, Ntianu!

     

    H
    Haroldas Ben
    December 12, 2023

    I am also waiting for this feature, it just came out as add-in for excel. Only problem we don't use excel due to it's limitations compared with google sheets. Hopefully Quickbooks will soon release the same add-in for google sheets. It makes sense since Quickbooks is a cloud software and so is google sheets, I wish they did it for google sheets before the excel and not the other way round.

    Y
    ytret
    December 12, 2023

    Hi there, the best and the most affordable option in the market now is G-Accon. G-Accon for QuickBooks add-on allows you to automatically download raw data and reports into Google Sheets, schedule automatic refresh, and set up any types of alerts and notifications for your team members and/or customers. You can check the documentation and videos here. https://wiki.accon.services/quickbooks/ and

     https://www.youtube.com/@g-acconintegrations3987/videos.

    You can also use this add-on for bulk upload and automate this process as well. As of today - this is the best integration between QBO and Google sheets. Enjoy!

     

    H
    Haroldas Ben
    December 12, 2023

    I have tried the connectors with various levels of success, not as good as Quickbooks own spreadsheet sync and it doesn't expand to quickbooks payroll, only accounts.

    Terms & ConditionsAccessibility statement