node-google-spreadsheet issues

row.Delete() is sometime not deleting the row as expected

6

Hello! Im using the row API with the `delete()` method : https://theoephraim.github.io/node-google-spreadsheet/#/classes/google-spreadsheet-row?id=fn-delete ```js async deleteAllRow(sheet){ try { if(!sheet){ throw Error("sheet is null") } const rows = await sheet.getRows(); console.info(`🗑️🗑️🗑️ Deletion...

romain130492

Change permissions of a google sheet / newly created sheet.

2

Permissions are scope of google drive in googleapis and not sheets but it would be cool to have that integrated with this implementation of spreadsheet. My usecase : I would...

vaibhavgeek

enhancement

Error when trying to save an empty row.

Error when trying to save an empty row. Note, saving an empty row is not the same as deleting one. sending an array of empty strings such as ["", ""]...

GabbyPly

Prepend rows

2

Hello! Is it possible to prepend new rows with values to an existing sheet? I can't seem to find out how unless adding a totally new spreadsheet which I don't...

marcianosr

enhancement

Edit an existing row by sending the row number

1

I have been searching about editing fields of an existing row by sending the row number. I know this can be done with cells by sending the specific cell but...

JoakoV3

Not able to add dropdown to Spreadsheet Cell using dataValidation property

1

Hi Folks, I'm trying to display dropdown for a cell in Google Sheet using Nodejs code. I have added the DataValidationRule as mentioned in https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/cells#DataValidationRule as below. But this is...

karthi-keyan-n

Authentication using Application Default Credentials

3

Hello. Trying to authenticate GoogleSpreadsheet with an application default credentials as described here: https://github.com/googleapis/google-auth-library-nodejs#application-default-credentials Here is my code: ``` const auth = await google.auth.getClient({ scopes: ["https://www.googleapis.com/auth/spreadsheets"] }); const doc =...

anantakrishna

Separate auth from library

2

The idea is to create another package (or just use something that already exist) and separate the auth from this module. Since this package is fully Javascript (browser) and nodejs...

LeGmask