We are super excited to announce that Blockspring have just released an integration with us to let you automatically pull data from the web into a spreadsheet. They’ve created an awesome solution that lets you use a range of great APIs using only a spreadsheet. Their Excel and Google Sheets plugin enables you to bring data into your spreadsheet, run text-analysis and much more.
So today we want to show you how you can use live web data from a spreadsheet to do a bunch of cool things in just a few minutes. Currently Blockspring is using our Magic API, which automatically generates a table of data from a URL. You just have to provide the Blockspring integration a URL and it pulls the data from that site into a nice, orderly table – all without leaving your spreadsheet.
Pulling live data into a spreadsheet
In this example we’ll use Magic and Blockspring to pull in data from Ikea’s rugs.
What you’ll need:
- Free Blockspring account
- Import.io account
- Your Import.io API Key
- A Google spreadsheet with the Blockspring Add-on installed (You can also use Excel)
- A URL you want to pull data from (or you can use our example)
Step 1: Set-up the spreadsheet
Open a Google spreadsheet and sign into Blockspring, which is found under Add-ons.
Step 2: Choose Import.io
Once you’re logged in, the Blockspring console will open on the right. Scroll down until you find Import.io.
The first time you do this, you’ll need to put in your Import.io API Key (which you can find on your account page).
Step 3: Extract data from a URL
Click on “Extract Data from URL” and then click “Insert into selected cell”. Blockspring will insert this formula into that cell: =BLOCKSPRING(“extract-data-from-url-importio”, “url”, “http://www.ikea.com/us/en/search/?query=chair“)
And you should see data on Ikea chairs brought straight from the website into the sheet!
Step 4: Change the URL
The URL Blockspring inserts is just a placeholder. To change it, simply replace it with whatever URL you want and hit Enter.
You can also change the URL in the formula to be a cell reference to make it easier to change the URL.
Manipulating your data
Live data in Google Sheets is pretty exciting, but where the Blockspring integration gets really cool, is how you can use the data you’ve pulled in with other API integrations. Here are three quick examples to get your wheels turning.
Get Product Color Trends
Let’s say you’re in product development and you want to know what the hot colors of the season are.
If we take the Ikea data set we created earlier, we can apply the Blockspring Color integration to pull out the primary color from each image. Everyday you could have a fresh data output of all the products on the website and colors for each product.
Compare Product Prices Across Sites
Whether you’re doing competitor pricing analysis or just a little comparison shopping, it’s helpful to know which sites have the best prices.
Using the Import.io integration with the Amazon Products integration, you can pull in the Ikea products and look them up on Amazon and pull in the corresponding prices. Voila! Simple price comparison, all without leaving your workbook.
Identify Core Company Team
Before you approach a new company – whether you’re selling something, asking for a job, offering a partnership, etc – it’s a good idea to know who the major players are.
Using the Import.io and Bing integrations, you can easily pull in the core team from a company’s Crunchbase page. The Bing integration will allow you to search for a company’s page and the Import.io integration will take that URL and extract all the relevant information from it.