{"_id":"57489a0a919ad20e00b6c754","category":{"_id":"574899e7e8c6a420000b7314","__v":0,"project":"5746675a5aa03c0e00fce9bc","version":"5746675a5aa03c0e00fce9bf","sync":{"url":"","isSync":false},"reference":false,"createdAt":"2016-05-27T19:03:03.123Z","from_sync":false,"order":2,"slug":"google-sheets","title":"Spreadsheet Plugins"},"user":"5706caf0adbf4d1900caf110","project":"5746675a5aa03c0e00fce9bc","version":{"_id":"5746675a5aa03c0e00fce9bf","__v":8,"project":"5746675a5aa03c0e00fce9bc","createdAt":"2016-05-26T03:02:50.849Z","releaseDate":"2016-05-26T03:02:50.849Z","categories":["5746675a5aa03c0e00fce9c0","574899e7e8c6a420000b7314","57489c11d929e919006ed4ae","57489c82d929e919006ed4b1","57489ce91b345d0e004e5231","5748a82e1b345d0e004e5256","59ce5c88e8c105001a4bedd7","59f96cd129b4d600246c2899"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"__v":4,"parentDoc":null,"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-27T19:03:38.757Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":8,"body":"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 <a href=\"#\">Adding a block</a>.  In some special cases you may want to use a formula in a cell instead.  We created the formula =BLOCKSPRING(...) for these situations.\n\nDetails on using =BLOCKSPRING() are given below:\n<a href=\"https://www.blockspring.com/help/google_sheets\">=BLOCKSPRING() in Google Sheets</a>. \n<a href=\"https://www.blockspring.com/help/excel\">=BLOCKSPRING() in Excel</a>\n\n## Other helpful functions\n\n### =BGetKey(result, key)\nUse this to get a particular value from a connector that returns multiple values or columns.\n\nParameters:\nResult - this is the cell where the connector outputs the result OR it can just be the BLOCKSPRING(...) function. \nkey - this is the name of the \"key\" or column that you want to keep.\n\nExample:\n`=BGetKey(BLOCKSPRING(\"my-block\"), \"first_name\")`\n\n### =BGetItem(result, row_number)\nUse this to get a particular row from a connector that returns multiple rows.\n\nParameters:\nResult - this is the cell where the connector outputs the result OR it can just be the BLOCKSPRING(...) function. \nRow_number - this is the row number in the result that you would like to keep.\n\nExample:\n`=BGETITEM(BLOCKSPRING(\"company-search-linkedin\", \"keywords\", A1, \"maximum_results\", 1),1)`","excerpt":"","slug":"using-blockspring","type":"basic","title":"Using =BLOCKSPRING()"}

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 <a href="#">Adding a block</a>. 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: <a href="https://www.blockspring.com/help/google_sheets">=BLOCKSPRING() in Google Sheets</a>. <a href="https://www.blockspring.com/help/excel">=BLOCKSPRING() in Excel</a> ## 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)`