[Feat]: Google Sheets batchUpdate

[superlaser97]

trafficstars

Is your feature request related to a problem? Please describe. When updating multiple rows using Google Sheets Datasource (update), the app quickly reaches the API limit, making this operation impossible unless user update a few rows at a time.

Describe the solution you'd like Implement batchUpdate method so updating multiple rows is possible

Describe alternatives you've considered Create a queue mechanism to queue updates to Google Sheets to keep within the API limit, however as lowcoder only executes on client end, it can be interrupted when user leaves the site.

Additional context Google Sheets API limits https://developers.google.com/sheets/api/limits Batch Update method https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/batchUpdate

[FalkWolsky]

We will look into it. It is a meaningful feature enhancement! Hopefully, we will find a way.