The sheet2api JS library can be installed through npm.
npm install sheet2api-js --save
To get started you need to provide your sheet2api Spreadsheet API URL. You can find it on the sheet2api Dashboard.
Try it out with the codepen https://codepen.io/sheet2api/pen/MWKZrqW
Importing the library
<!-- Server import -->
// Or, Require importconst Sheet2API = ;// Or, ES6 import;
Read rows matching a search query
Create new rows
Update existing rows matching a search query
Update partially, existing rows matching a search query
Note, If you don’t include values for all columns (Name, Favourite Thing, Image) in the request body, then missing column values will not be updated, just the ones which were present in the request body.
If you have enabled Basic Authentication on your sheet2api API.
const options =auth: 'username' 'password';Sheet2API;</script>
Something missing you'd like to see? Please create an issue.