blockspring-help

Blockspring Help

Welcome to the Blockspring support site. You'll find comprehensive guides and documentation to help you start working with Blockspring as quickly as possible, as well as support if you get stuck. Let's jump right in!

Get Started    

Using =BLOCKSPRING()

The Blockspring plugin comes with several ways of running a connector. The most common way to use a connector is by inserting it using the instructions in Adding a block. In some special cases you may want to use a formula in a cell instead. We created the formula =BLOCKSPRING(...) for these situations.

Details on using =BLOCKSPRING() are given below:
=BLOCKSPRING() in Google Sheets.
=BLOCKSPRING() in Excel

Other helpful functions

=BGetKey(result, key)

Use this to get a particular value from a connector that returns multiple values or columns.

Parameters:
Result - this is the cell where the connector outputs the result OR it can just be the BLOCKSPRING(...) function.
key - this is the name of the "key" or column that you want to keep.

Example:
=BGetKey(BLOCKSPRING("my-block"), "first_name")

=BGetItem(result, row_number)

Use this to get a particular row from a connector that returns multiple rows.

Parameters:
Result - this is the cell where the connector outputs the result OR it can just be the BLOCKSPRING(...) function.
Row_number - this is the row number in the result that you would like to keep.

Example:
=BGETITEM(BLOCKSPRING("company-search-linkedin", "keywords", A1, "maximum_results", 1),1)