Enter your search

Use the power of the GoSquared API without code

Blockspring – slice and dice your analytics data in Google Sheets

GoSquared + Blockspring Integration

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.

Christoph Janz Point Nine Capital SaaS Metrics

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?

GoSquared integrates with Google Sheets via Blockspring

Here’s what you need to do:

  1. Open a Google Spreadsheet document and navigate to the “Add-ons” menu > Get Add-ons > search for “blockspring” add!
  2. Then you’ll need to signup to Blockspring and log-in through the app.
  3. Once you’re set up simply type in the panel on the right hand side: “Get Historical Traffic with GoSquared”
  4. Hit “Insert into selected Cell”
  5. 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!
  6. 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?

Check out the GoSquared integration on Blockspring now

Got a cool use case for using GoSquared with Blockspring? We’d love to hear! Shoot us an email or tweet us – we’d love to share any ideas you have with the community!

Written by
James is CEO and one of the co-founders of GoSquared. He also likes to talk about design.

You May Also Like

Group 5 Created with Sketch. Group 11 Created with Sketch. CLOSE ICON Created with Sketch. icon-microphone Group 9 Created with Sketch. CLOSE ICON Created with Sketch. SEARCH ICON Created with Sketch. Group 4 Created with Sketch. Path Created with Sketch. Group 5 Created with Sketch.