{"_id":"5746675a5aa03c0e00fce9c2","project":"5746675a5aa03c0e00fce9bc","user":"5706caf0adbf4d1900caf110","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":"Google Sheets & Excel"},"version":{"_id":"5746675a5aa03c0e00fce9bf","__v":7,"project":"5746675a5aa03c0e00fce9bc","createdAt":"2016-05-26T03:02:50.849Z","releaseDate":"2016-05-26T03:02:50.849Z","categories":["5746675a5aa03c0e00fce9c0","574899e7e8c6a420000b7314","57489c11d929e919006ed4ae","57489c82d929e919006ed4b1","57489ce91b345d0e004e5231","5748a82e1b345d0e004e5256","59ce5c88e8c105001a4bedd7"],"is_deprecated":false,"is_hidden":false,"is_beta":false,"is_stable":true,"codename":"","version_clean":"1.0.0","version":"1.0"},"parentDoc":null,"__v":2,"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-26T03:02:50.908Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":2,"body":"# Install\n\nBlockspring is a plugin that must be installed before use. \n\n#### Install for Google Sheets\n1. [Download Blockspring for Google Sheets](https://chrome.google.com/webstore/detail/blockspring/aihldeahgcpbpmimkdpkafaedhbmfhoh?hl=en-US)\n2. Open a Google Sheet, then open Blockspring from \"Add-ons\" in the toolbar\n\n#### Install for Excel\n1. [Download Blockspring for Excel](https://s3.amazonaws.com/downloads.blockspring.com/Blockspring+for+Excel+AddIn.msi)\n2. Open the download, and double click to install it. Follow the setup instructions that open.\n3. Open Excel, then open Blockspring from \"Add-ons\" in the toolbar\n\n\n# Add a block\n\nBlockspring makes spreadsheets more powerful by adding \"blocks\" to them.  A block can do many things.  The typical things a block does is get data, do a calculation, or take an action (e.g. send an email). \n\n#### To add a block to a spreadsheet:\n\n**1. Open the Blockspring Plugin. **\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\n**2. Click the \"Add Block\" button**\nClick the green \"Add Block\" button near the top-right of the plugin. \n\n**3. Choose a block to add **\nYou can search or click a company to view their blocks.  When you have found a block 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\n**4. Fill out the form for a blocks inputs**\nOn a block'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 block will use the data in your spreadsheet as an input!\n\n**5. Insert the block to your sheet**\nClick the green \"Insert\" button. The block will run and the results will be added to your sheet.\n\n# Run or schedule a block\n\nAfter a block has been added to a spreadsheet, the block can be run again at any time.  The Blockspring plugin shows all blocks that have been added to a spreadsheet.\n\n#### To run a block manually:\n**1. Open the Blockspring Plugin**\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\n**2. Click the Run button**\nAfter opening the Blockspring plugin, you will see a list of all blocks in the sheet. Click the blue \"Run\" button in a block's card. \n\n#### To schedule a block to run automatically:\n**1. Open the Blockspring Plugin **\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\n**2. Choose a frequency**\nClick the dropdown under \"Schedule\" and choose a frequency for the block.\n\nThe block will run at the scheduled frequency.  \nIn Google Sheets, the block will run even if the spreadsheet is closed.  \nIn Excel, the block will **not** run if the spreadsheet is closed.\n\n# Share a spreadsheet\n\nThere are two ways to share a spreadsheet that uses Blockspring.  \n\n#### Option 1: Share access \nIf you want to give a person access to your spreadsheet, you can share access.  If they have Blockspring, they will see all of the spreadsheet's blocks and be able to run them.  All scheduled blocks will continue to run according to their schedule. \n\n**Google Sheets:**\nOpen a sheet that you want to share, then click the blue \"Share\" button in the top-right corner.  \n\n**Excel:**\nYou can use any method that lets another person work with the Excel file.  One method is to place the file on Dropbox or another file sharing service.\n\n#### Option 2: Copy\nIf you want a person to have access to your sheet's functionality, but their own data, then they should make a copy of your spreadsheet.\n\n**Google Sheets:**\nIn the top toolbar, go to \"File\" > \"Make a copy\".\n\n**Excel:**\nLocate the spreadsheet file on your computer.  Right-click on the file, and then choose \"copy\". \n\n# More resources\n\nWe've covered the basics: installing the plugin, adding a block, and running a block.  You are ready to use Blockspring.\n\n#### Get ideas\nOur <a href=\"https://blockspring.blockspring.com/templates\">Google Sheet templates</a> do some neat things.  They are already setup and ready to use.\n\n#### Use a particular API\nCheckout our list of <a href=\"https://open.blockspring.com/browse\">API's</a>. We have over 100 API's that can be used in a spreadsheet.","excerpt":"This page will help you get started with blockspring-help. You'll be up and running in a jiffy!","slug":"getting-started","type":"basic","title":"Getting Started with Blockspring"}

Getting Started with Blockspring

This page will help you get started with blockspring-help. You'll be up and running in a jiffy!

# Install Blockspring is a plugin that must be installed before use. #### Install for Google Sheets 1. [Download Blockspring for Google Sheets](https://chrome.google.com/webstore/detail/blockspring/aihldeahgcpbpmimkdpkafaedhbmfhoh?hl=en-US) 2. Open a Google Sheet, then open Blockspring from "Add-ons" in the toolbar #### Install for Excel 1. [Download Blockspring for Excel](https://s3.amazonaws.com/downloads.blockspring.com/Blockspring+for+Excel+AddIn.msi) 2. Open the download, and double click to install it. Follow the setup instructions that open. 3. Open Excel, then open Blockspring from "Add-ons" in the toolbar # Add a block Blockspring makes spreadsheets more powerful by adding "blocks" to them. A block can do many things. The typical things a block does is get data, do a calculation, or take an action (e.g. send an email). #### To add a block to a spreadsheet: **1. Open the Blockspring Plugin. ** 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. **2. Click the "Add Block" button** Click the green "Add Block" button near the top-right of the plugin. **3. Choose a block to add ** You can search or click a company to view their blocks. When you have found a block 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. **4. Fill out the form for a blocks inputs** On a block'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 block will use the data in your spreadsheet as an input! **5. Insert the block to your sheet** Click the green "Insert" button. The block will run and the results will be added to your sheet. # Run or schedule a block After a block has been added to a spreadsheet, the block can be run again at any time. The Blockspring plugin shows all blocks that have been added to a spreadsheet. #### To run a block manually: **1. Open the Blockspring Plugin** 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. **2. Click the Run button** After opening the Blockspring plugin, you will see a list of all blocks in the sheet. Click the blue "Run" button in a block's card. #### To schedule a block to run automatically: **1. Open the Blockspring Plugin ** 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. **2. Choose a frequency** Click the dropdown under "Schedule" and choose a frequency for the block. The block will run at the scheduled frequency. In Google Sheets, the block will run even if the spreadsheet is closed. In Excel, the block will **not** run if the spreadsheet is closed. # Share a spreadsheet There are two ways to share a spreadsheet that uses Blockspring. #### Option 1: Share access If you want to give a person access to your spreadsheet, you can share access. If they have Blockspring, they will see all of the spreadsheet's blocks and be able to run them. All scheduled blocks will continue to run according to their schedule. **Google Sheets:** Open a sheet that you want to share, then click the blue "Share" button in the top-right corner. **Excel:** You can use any method that lets another person work with the Excel file. One method is to place the file on Dropbox or another file sharing service. #### Option 2: Copy If you want a person to have access to your sheet's functionality, but their own data, then they should make a copy of your spreadsheet. **Google Sheets:** In the top toolbar, go to "File" > "Make a copy". **Excel:** Locate the spreadsheet file on your computer. Right-click on the file, and then choose "copy". # More resources We've covered the basics: installing the plugin, adding a block, and running a block. You are ready to use Blockspring. #### Get ideas Our <a href="https://blockspring.blockspring.com/templates">Google Sheet templates</a> do some neat things. They are already setup and ready to use. #### Use a particular API Checkout our list of <a href="https://open.blockspring.com/browse">API's</a>. We have over 100 API's that can be used in a spreadsheet.