{"_id":"57489b48e8c6a420000b7319","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":2,"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":"Spreadsheet Plugins"},"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":6,"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 connectors 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 connector to your spreadsheet.\n\n# Schedule a connector 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 connectors added to the spreadsheet. Click the dropdown under \"Schedule\" in a connector's card.  Choose a frequency in this dropdown.  \n\nNo further action is needed. Your connector will now run at that scheduled frequency.\n\n**Will my connector run automatically if the sheet is closed?**\n\nIn Google Sheets, the connector will run even if the spreadsheet is closed.  \nIn Excel, the connector will **not** run if the spreadsheet is closed.\n\n**When will my connector run?**\n- Your connector does not run immediately after choosing a frequency.\n- Your connector 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 connector.\n- Your connector will always run at that same point within the chosen frequency.  If Google Sheets chose minute \"46\" of the hour to run your connector, then your connector 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 connectors 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 connector to your spreadsheet. # Schedule a connector 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 connectors added to the spreadsheet. Click the dropdown under "Schedule" in a connector's card. Choose a frequency in this dropdown. No further action is needed. Your connector will now run at that scheduled frequency. **Will my connector run automatically if the sheet is closed?** In Google Sheets, the connector will run even if the spreadsheet is closed. In Excel, the connector will **not** run if the spreadsheet is closed. **When will my connector run?** - Your connector does not run immediately after choosing a frequency. - Your connector 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 connector. - Your connector will always run at that same point within the chosen frequency. If Google Sheets chose minute "46" of the hour to run your connector, then your connector will always run at minute 46. So it will run at 12:46, 1:46, 2:46, etc.