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.

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....

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!

@stewardship1 

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

https://automate.io?ref=quickbooks

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

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.

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. 

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.

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:

• Run reports in QuickBooks Online
• Customize reports in QuickBooks Online
• Memorize reports in QuickBooks Online
• Export your reports to Excel from QuickBooks Online

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!

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.

I value your insights about this feature, Haroldas.

I acknowledge the significance of using QuickBooks add-on services for Google Sheets to enhance your data management capabilities compared to Excel. Rest assured that our team is working nonstop to enhance the product and deliver the best experiences for all QuickBooks users.

Although it's not supported yet, I suggest sending a feature request directly to our product developers. It'll enable them to evaluate the possibility of incorporating this idea in the upcoming updates.

To start: 

1. Go to the Gear icon, then Feedback.
2. Enter your comments or product suggestions.
3. Tap Next to submit.

Once done, your valuable suggestion goes to our Product Development team to help improve your QBO experience. You can track feature requests through the QuickBooks Online Feature Requests website.

On the other hand, you may consider checking the resources from these links for more tips as you continue working with your reports and other entries:

• Run reports in QuickBooks Online
• Create enhanced custom reports in QuickBooks Online

Keep me posted if you still have questions or concerns while working with your QuickBooks data. I am here to assist you in any way I can. 

@Haroldas Ben 

You can use this app as the connector.

https://www.make.com/en/register?pc=quickbooks

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!

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.