Blockspring, a service that connects to spreadsheets like Excel and Google Spreadsheets to easier import data.Instead of having to write specific code to import and sort data in a spreadsheet, Blockspring has several connections to services like Google Search that will automatically populate spreadsheets with data. The company plans to release several integrations for tools like Tableau and Slack.
For example, a Blockspring user can quickly pull in PDF files from the web and analyze them in a spreadsheet. That would originally including searching for those articles, downloading each one, and then analyzing them — such as searching for specific words. That data can be manipulated in as many ways as there are APIs that are plugged into Blockspring.
This is great - I've been waiting for something like this. For the business version - what kind of security do you employ if we're connecting Blockspring to our internal database?
As a dev, I built a mobile backend on blockspring and firebase - its basically a nicer version of AWS Lambda.
My API's logic is secured by blockspring, the code is in a container that spins up every time my API is hit and my data is stored in Firebase (but I could've also done it in sqlite).
As a non dev, it feels awesome to be able to import large data sets from APIs like meetup.com in excel so I can do some text and trend analysis without having to set up anything!
@orliesaurus Any tips of what recipes to use with Meetup.com? I have attended quite bit of events, and would like to get some statistics and data about them.
@autiomaa sure: analyse what are the most meetups around your area, analyse what venue a meetup is mostly held at, analyse which day of the month yields most signups, dump a list of attendees, given a meetup group - grab all the ratings for every event...for example are some cool ones :)
Or chain some functions together to get the criminality rate of the neighborhood in which a certain meetup is hosted
Looks quite useful. Just spent 30 minutes testing how to use it.
There are much of potential use cases for people doing research, or wanting to automate various things.
It will take some time to learn the full potential of the service, but it’s more dependent on what you want to do with it.
Hey everyone - co-founder of Blockspring here to answer any questions :)
Spreadsheets aren't powerful until you have data in it! So we're here to help you get that done.
Blockspring goes beyond just getting data though. It also has a lot of powerful functions that were previously only available to people that knew how to program - so now you can do crazy things like determine whether text has a "positive" or "negative" sentiment, just by using a spreadsheet function.
We've seen regular Excel users combine the new functions to make some really crazy tools for their teams.
Really well done - @whatsdonisdon, are you planning to create a Zapier integration to improve the existing ability Zapier has to interact with Google Sheets?
Mysuper.fan