Connecting Google Sheets With Quickbooks

Google Sheets is a great tool to interactively work with an assortment of APIs to work as an intermediary database for experiments or small scale data processing. Here we’re going to look at how we can query our Quickbooks data and display it in a sheet to then merge with any other data set like analytics or time logs, etc.

First we’ll head to the “Tools” tab and select “Script Editor”. Once the new script editor window has opened, we’ll want to add the Oauth library that we’ll use to authenticate with Quickbooks. Go to “Resources” and select “Libraries…” and add Oauth1.

Next we’ll have to go ahead and create an app under the Quickbooks developer console.  You will be provided a consumer key and consumer secret token. Save those values along with your company id and we’ll store those values as variables for use in querying Quickbooks.

Next we’ll create a couple functions to interact with our Quickbooks app to authenticate with Oauth:

And lastly, we’ll go ahead and query payment data for a particular customer from our Quickbooks database and add it to our spreadsheet:

And there you have it. Now you can get any data available via Ituit Quickbooks API and store it however you like in Google Sheets and even run calculations with other data sets.

Related Posts

Using Node.js and OpenCV to Count Colonies on a Pe... If you're looking for a relatively simple way to automate routine tasks that involve extracting information from images, using computer vision librari...
Bitcoin Arbitrage Visualization with Google Sheets If you have access to international bitcoin exchanges, you might be able to take advantage of bitcoin arbitrage opportunities. Google Sheets has a gre...
Google Apps Script to Extract Emails If you have a generic email that is being sent to you regularly and you happen to be a gmail user, you can easily extract that data into a spreadsheet...
 

David Chun

I'm a full stack developer that builds tools for marketing and managing ecommerce shops. I occasionally consult for startups. If you've got an interesting project, reach out.

 

2 thoughts on “Connecting Google Sheets With Quickbooks

  1. Thanks so much for this! Since they don’t allow OAuth1 anymore I had to tweak it to work with OAuth2, which wasn’t too bad. I wish I saw Jonathan’s comment before because I was looking for a link like that, it would have helped!

    Any plans to write a similar post to help folks get set up for QBO to Sheets with OAuth2? Quickbooks API documentation is really tough for a newbie like me and the closest they get to Google Scripts is Node.JS, which doesn’t help me much…

    Oh, and thank you for your Quickbooks Connect Sheets add-on! It works perfectly, and opened my world for some automation possibilities.

Leave a Reply

Your email address will not be published. Required fields are marked *