Optimizing Integration Task usage

Want some tips to make your task limit go a bit further?

How to optimize your Integration Tasks

Try implementing the following tips in your spreadsheets so that you use your Integration Tasks efficiently:

  1. Use automation functions responsibly. Don’t overdo it with REFRESH(), REPEAT(), and SCHEDULE().

  2. Use IF() and action elements to execute functions only when required. Instead of having a function execute each time new data is entered, conditionalize it using checkboxes or buttons. This way the user needs to consciously click on the action element in order to execute the function.