node-google-spreadsheet issues

Adds new auth mode to use the default google auth client

3

Works out of the box when deployed on GCP, or using GOOGLE_APPLICATION_CREDENTIALS env var for local dev.

How to check whether headers are present in the sheet or not ?

4

This im using to check headers `await sheet.loadHeaderRow(1)` but giving error - `Error: No values in the header row - fill the first row with header values before trying to...

sskanishk

add setHeaderRow method to readme

3

The **setHeaderRow** method is not documented in the basics, but it's an important one to be able to work with rows of an existing sheet.

anyk17

Create developer metadata on Sheets, Rows and Columns

2

Adds a base method to `GoogleSpreadsheet` for fetching metadata by Id and then also for creating metadata The child classes (Worksheet, Rows, Cells) then call these with the right values...

darraghmckay

Error 'This cell has not been loaded yet' - with Named Range

4

``` await sheet.loadCells('A1:A200'); let a1 = sheet.getCell(0, 0); ``` works !! but.. ``` await sheet.loadCells('MyRange'); let a1 = sheet.getCell(0, 0);

pravynandas

needs investigation

Please add query option for update and delete

1

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

setDataValidation data validation

2

Hi, can I use this package to set data validation rules for a range of cells? I've tried sheet._makeSingleUpdateRequest and sheet.setDataValidation without success. Thanks! ``` values =[ {userEnteredValue: 'Emeli Studs...

josephchan91

enhancement

Retry logic when rate-limited

7

This PR adds optional logic that will retry every request that returns in a 429 response. A `429` means you have been rate-limited according to these [usage-limits](https://developers.google.com/sheets/api/reference/limits) This is **off**...

darraghmckay