search

lowcoder-org / lowcoder

🔥 🔥 🔥 The Open Source Retool, Tooljet and Appsmith Alternative
https://www.lowcoder.cloud/
GNU Affero General Public License v3.0
879 stars 181 forks source link

[Feat]: Google Sheets batchUpdate #661

Open superlaser97 opened 9 months ago

superlaser97 commented 9 months ago

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 commented 9 months ago

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