Google Sheets
A package that wraps around the google-spreadsheet package to easily interface with google sheets. The client secret json file was created using the google developer console. More in depth documentation can be found at google-spreadsheet. Make sure there is a file called client_secret.json in order to authenticate with google sheets in the root of the project.
Installing
git clone git@github.com:JacobRichardson/GoogleSheets.git
npm install
Basic Usage
//Require in the package.const googleSheet = ; //Retrieve the sheet using the spreadsheet id.const sheet = await googleSheet; //Retrieve all the rows of the sheet using get rows.let rows = await googleSheet; //Create a new row with the name Jacob. (Spread sheet must have a column with the title of name)await googleSheet; //Retrieve a specific row using get queried rows and name equaling Jacob.rows = await googleSheet; //Delete a row using delete row and the first row we found.googleSheets;
Testing
npm run test