Skip to content
New issue

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

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

Already on GitHub? Sign in to your account

Batching updates with the Google Sheets API #3

Open
Skaft opened this issue Nov 2, 2020 · 0 comments
Open

Batching updates with the Google Sheets API #3

Skaft opened this issue Nov 2, 2020 · 0 comments

Comments

@Skaft
Copy link
Owner

Skaft commented Nov 2, 2020

To better handle channels with high traffic and many applicants, it would be useful to bundle applications and update the sheet with multiple users in one API call.

The sheets API does have a batchUpdate endpoint, and gspread has an interface to it. What I have not found is a flexible way to create the payload. Perhaps a module is needed that generates dicts matching the Sheets API's Request object structure, for each common sheet operation done here. It seems trivial then to bundle any collection of such Requests and batch_update them in one go.

This could also be used to dodge some other redundant API calls, for example in refresh_headers.

@Skaft Skaft mentioned this issue Nov 2, 2020
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant