In Sheets API - BatchUpdateValues should be able to update multiple ranges at a time.

[simplyvijay]

Summary

The implementation of BatchUpdateValues for the 'sheets' can be modified to exhibit the capability to update multiple ranges in a single call.

Sample Name

Sheets Quickstart

Expected Behavior

Multiple ranges can be updated.
public static BatchUpdateValuesResponse batchUpdateValues(String spreadsheetId, String range, String valueInputOption, List<List<Object>> values)
The above can be replaced with the below signature for better understanding along with the implementation where multiple ranges can be updated in a single call.
public static BatchUpdateValuesResponse batchUpdateValues(String spreadsheetId, List<String> range, String valueInputOption, List<List<List<Object>>> values)

Actual Behavior

Single range is being updated.

Specifications

• Java 11 / Window