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)