All Questions
2 questions
1
vote
1
answer
218
views
How to read data using Google query language and update using sheets api, when query doesn't return row numbers?
What I want is to search one row in Google Spreadsheet and Update the value of one column. (When we have a large number of rows)
By looking at the main requirement, it seems easy. Yes of course. There ...
- 53
6
votes
3
answers
6k
views
Fastest way to search for a row in a large Google Sheet using/in Google Apps Script
GAS is quite powerful and you could write a full fledged web-app using a Google Sheet as the DB back-end. There are many reasons not to do this but I figure in some cases it is okay.
I think the ...
- 5,893