node-google-spreadsheet

node-google-spreadsheet copied to clipboard

wrong https://github.com/theoephraim/node-google-spreadsheet/blob/d4a649b90a3840751dd5251e1962f9b2f5fa6434/src/lib/GoogleSpreadsheet.ts#L342-L356 right ```ts async addNamedRange( name: string, range: GridRange, namedRangeId?: string ) { return this._makeSingleUpdateRequest('addNamedRange', { namedRange: { name, namedRangeId, range, } }); } ``` spec https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request?hl=en#AddNamedRangeRequest

s-wada-np

I see that `InsertRangeRequest ` is not implemented yet. But, is there any alternative to achieve same functionality using already existing implementations? I am inserting some data into sheets through...

trellrahul

ILG2021

After reinstalling my node modules I got this error: `Cannot use api key only to create a new spreadsheet - it is only usable for read-only access of public docs`...

Ivokato

Hi There Please update axios dependency to the latest version The latest as at this request is 1.7.3 Thank you very much

soongsta

Update the Service Account method with new steps.

maykbrito

Read headers in batch on getRows()

1

The current flow, when running getRows, checks if the headers are loaded. If they are not, we first load the headers and then we run the get. These 2 calls...

adrinr

createNewSpreadsheetDocument 400 bad request 4.1.2

2

After updating my dependencies I got an inexplicable `ERR_BAD_REQUEST` (400) response when trying to create new google spreadsheets through `createNewSpreadsheetDocument`. I tried doing the same from [RunKit](https://npm.runkit.com/google-spreadsheet) (where every npm...

Ivokato

Passing AbortController to the methods

1

It would be great to have ability to pass `AbortController/AbortSignal` to the API methods, so method would stop fetching once abort happens.

sergeyzwezdin

Fixes: https://github.com/theoephraim/node-google-spreadsheet/issues/418 Per the [usage limits docs](https://developers.google.com/sheets/api/reference/limits) 429s should be handled by retrying, ideally by following an exponential back-off algorithm. With this PR, you can provide the max retries &...

Niallfitzy1