API 0:54 video
How to run API batch requests
Run SpreadsheetWeb API requests as a batch to process multiple input sets efficiently and retrieve the corresponding calculation results.
- Navigate to the "API Toolkit" and click on "Batch Calculation" at the top of the page.
- Select a relevant named range in the "Inputs" menu and click on the top of your selection.
- Hit the "Load Defaults."
- Select an output.
- Remember, a batch calculation will execute the same request consecutively a variable number of times. This is not a performance-oriented operation, which would alternatively occur either through multi-threading or via the multi-calculation endpoint.
- Lastly, click on "Calculate".