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

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

 

Leave a Reply

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