Skip to content

[Feat]: Google Sheets batchUpdate #661

New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Open
superlaser97 opened this issue Jan 27, 2024 · 1 comment
Open

[Feat]: Google Sheets batchUpdate #661

superlaser97 opened this issue Jan 27, 2024 · 1 comment
Assignees
Labels
Enhancement New feature or request

Comments

@superlaser97
Copy link

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

@superlaser97 superlaser97 added the Enhancement New feature or request label Jan 27, 2024
@FalkWolsky FalkWolsky moved this to 🆕 New in Lowcoder Jan 31, 2024
@FalkWolsky FalkWolsky moved this from 🆕 New to 📋 Backlog in Lowcoder Jan 31, 2024
@FalkWolsky
Copy link
Contributor

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

# for free to join this conversation on GitHub. Already have an account? # to comment
Labels
Enhancement New feature or request
Projects
Status: 📋 Backlog
Development

No branches or pull requests

3 participants