{"_id":"57489b48e8c6a420000b7319","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"},"__v":1,"parentDoc":null,"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"},"updates":[],"next":{"pages":[],"description":""},"createdAt":"2016-05-27T19:08:56.564Z","link_external":false,"link_url":"","githubsync":"","sync_unique":"","hidden":false,"api":{"results":{"codes":[]},"settings":"","auth":"required","params":[],"url":""},"isReference":false,"order":5,"body":"A common use of Blockspring is to create reports that automatically update their data every hour, day, week, or month. \n\nBlockspring lets you create an automatically updating report by using blocks that get data, and then scheduling them to run at some frequency.\n\n<a href=\"https://blockspring-help.readme.io/docs/adding-a-block\">This guide</a> explains how to add a block to your spreadsheet.\n\n# Schedule a block to run automatically:\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. Choose a frequency \nWhen you open the Blockspring plugin, you will see a list of all blocks added to the spreadsheet. Click the dropdown under \"Schedule\" in a block's card.  Choose a frequency in this dropdown.  \n\nNo further action is needed. Your block will now run at that scheduled frequency.\n\n**Will my block run automatically if the sheet is closed?**\n\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**When will my block run?**\n- Your block does not run immediately after choosing a frequency.\n- Your block will run at some point within the chosen frequency. This is chosen randomly by Google Sheets.  For example if you chose the frequency \"hourly\", Google Sheets will pick some minute within every hour to run your block.\n- Your block will always run at that same point within the chosen frequency.  If Google Sheets chose minute \"46\" of the hour to run your block, then your block will always run at minute 46.  So it will run at 12:46, 1:46, 2:46, etc.","excerpt":"","slug":"schedule-automatic-updates","type":"basic","title":"Schedule automatic updates"}

Schedule automatic updates


A common use of Blockspring is to create reports that automatically update their data every hour, day, week, or month. Blockspring lets you create an automatically updating report by using blocks that get data, and then scheduling them to run at some frequency. <a href="https://blockspring-help.readme.io/docs/adding-a-block">This guide</a> explains how to add a block to your spreadsheet. # 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 When you open the Blockspring plugin, you will see a list of all blocks added to the spreadsheet. Click the dropdown under "Schedule" in a block's card. Choose a frequency in this dropdown. No further action is needed. Your block will now run at that scheduled frequency. **Will my block run automatically if the sheet is closed?** 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. **When will my block run?** - Your block does not run immediately after choosing a frequency. - Your block will run at some point within the chosen frequency. This is chosen randomly by Google Sheets. For example if you chose the frequency "hourly", Google Sheets will pick some minute within every hour to run your block. - Your block will always run at that same point within the chosen frequency. If Google Sheets chose minute "46" of the hour to run your block, then your block will always run at minute 46. So it will run at 12:46, 1:46, 2:46, etc.