node-google-spreadsheet icon indicating copy to clipboard operation
node-google-spreadsheet copied to clipboard
verified publisher icon theoephraim

Please add query option for update and delete

Open subhra9326 opened this issue 3 years ago • 1 comments

await sheet.getRows() reading all the rows and then finding a specific row is very bulky work for the update & delete operation. Please add some query options for that.

subhra9326 avatar Jun 07 '22 09:06 subhra9326

If you mean bulky in that it fetches everything, google's api does not provide filtering capabilities :(

theoephraim avatar Jun 17 '22 16:06 theoephraim

The best workaround I have found is to add a formula cell in another sheet that does the lookup you need, and then use that information to do what you need.

theoephraim avatar Jun 26 '23 18:06 theoephraim