{"_id":"57489a1de8c6a420000b7316","project":"5746675a5aa03c0e00fce9bc","__v":1,"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"},"parentDoc":null,"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","updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-27T19:03:57.892Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":4,"body":"lockspring makes spreadsheets more powerful by adding connectors to them.  A connector can do many things.  The typical things a connector does is get data, do a calculation, or take an action (e.g. send an email). \n \nHere is how you add a connector to a spreadsheet:\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"1. Open the Blockspring plugin\"\n}\n[/block]\nIn Google Sheets, this is in the top toolbar under \"Add-ons\".  In Excel, this is in the top toolbar under \"Blockspring\". Log-in to Blockspring if needed.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"2. Click the \\\"Add Block\\\" button\"\n}\n[/block]\nThere is a green \"Add Block\" button near the top-right of the Blockspring plugin.  Click this.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"3. Choose a connector to add\"\n}\n[/block]\nYou can search or click a company to view their blocks.  When you have found a connector to add, click on it and you will see a page with its title, description, a form for filling out its inputs, and an insert button.\n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"4. Fill out the form inputs\"\n}\n[/block]\nOn a connector's page, there is a form for the block's inputs.  Fill out each input or have the input reference a cell in your spreadsheet.  \n\nWhen an input references a cell, the connector will use the data in your spreadsheet as an input.  If the data in the referenced cell changes, then next time the connector runs it will use the new data.\n\nChanging a referenced cell will **not** cause the connector to run again.  The block will only run again if \"run\" is clicked, or if the block is scheduled to run automatically. \n[block:api-header]\n{\n  \"type\": \"basic\",\n  \"title\": \"5. Click the \\\"Insert\\\" button\"\n}\n[/block]\nClick the green \"Insert\" button. The connector will run and the results will be added to your sheet.\n\nThe results will be inserted in the currently selected cell.","excerpt":"","slug":"adding-a-block","type":"basic","title":"Adding a Connector"}

Adding a Connector


lockspring makes spreadsheets more powerful by adding connectors to them. A connector can do many things. The typical things a connector does is get data, do a calculation, or take an action (e.g. send an email). Here is how you add a connector to a spreadsheet: [block:api-header] { "type": "basic", "title": "1. Open the Blockspring plugin" } [/block] In Google Sheets, this is in the top toolbar under "Add-ons". In Excel, this is in the top toolbar under "Blockspring". Log-in to Blockspring if needed. [block:api-header] { "type": "basic", "title": "2. Click the \"Add Block\" button" } [/block] There is a green "Add Block" button near the top-right of the Blockspring plugin. Click this. [block:api-header] { "type": "basic", "title": "3. Choose a connector to add" } [/block] You can search or click a company to view their blocks. When you have found a connector to add, click on it and you will see a page with its title, description, a form for filling out its inputs, and an insert button. [block:api-header] { "type": "basic", "title": "4. Fill out the form inputs" } [/block] On a connector's page, there is a form for the block's inputs. Fill out each input or have the input reference a cell in your spreadsheet. When an input references a cell, the connector will use the data in your spreadsheet as an input. If the data in the referenced cell changes, then next time the connector runs it will use the new data. Changing a referenced cell will **not** cause the connector to run again. The block will only run again if "run" is clicked, or if the block is scheduled to run automatically. [block:api-header] { "type": "basic", "title": "5. Click the \"Insert\" button" } [/block] Click the green "Insert" button. The connector will run and the results will be added to your sheet. The results will be inserted in the currently selected cell.