We’ve been working with Blockspring to bring the power of the GoSquared API to Google Sheets. You can now grab data from the GoSquared API (along with hundreds of other services, like MailChimp, Slack and Twitter) in Google Sheets through Blockspring.
Why would I want to use the GoSquared API with Google Sheets?
As you know, Google Sheets is a hugely versatile tool, and it’s where a lot of data ends up getting piped to for people to analyse and share with their coworkers.
We try to avoid spreadsheets whenever possible, but we have a Google Sheet shared with our investors that we keep updated with our high level key metrics, and the new Blockspring integration is making our lives easier.
At GoSquared, we use a custom version of Christoph Janz’s SaaS metrics template to report our key numbers with our investors. We automatically populate the sheet using the GoSquared API for key numbers like the total number of visitors to our marketing site.
It took one of our engineers a few hours to build a service to send our API data into the Google Sheet – a few hours he could have been working on building features for our customers.
Now, thanks to Blockspring, you can send your data from GoSquared into a Google Sheet in a couple of clicks without ever needing to bug one of your developers even for a second. We think that’s pretty neat, and our developers think it’s even neater.
What is Blockspring?
“Blockspring is the world’s library of functions, accessible from everywhere you do work”.
Essentially, Blockspring makes it easy to bring data from external APIs into one place – Google Sheets.
We think this is great for the thousands of customers who want to get more power out of GoSquared, but don’t have the time to use or learn the GoSquared API.
How does GoSquared and Blockspring integration work?
Here’s what you need to do:
- Open a Google Spreadsheet document and navigate to the “Add-ons” menu > Get Add-ons > search for “blockspring” add!
- Then you’ll need to signup to Blockspring and log-in through the app.
- Once you’re set up simply type in the panel on the right hand side: “Get Historical Traffic with GoSquared”
- Hit “Insert into selected Cell”
- You’ll see that the Blockspring add-on has generated a new function in the selected cell “=BLOCKSPRING(argument1, argument2…)” and once you hit “Return” on your keyboard the formula is executed as expected. A second later: Data appears!
- These are the default parameters that show you the data from the GoSquared API DEMO site. Obviously if you’re already using GoSquared you can get your own data, by click “Set Key” in Google Sheets and adding your own API tokens. Try to change the date to something more old, maybe try to grab the data from June!
So in roughly 2 minutes or less you consumed an API directly from Google Sheets without writing a single line of code (or asking a developer for help). Pretty cool, huh?