take inventory of your books in a google sheet!
this is my second and successful attempt at making a add-book-to-sheets thing (first one)
- make a netlify account. https://app.netlify.com/signup
- create a repository using this template. (MAKE SURE TO MAKE IT PRIVATE)
- go to google sheets and create a new empty sheet.
- create four columns: ISBN, Name, Author, Pages
- in your sheet, go to Extensions -> Apps Script
- you should now have reached a code editor. paste the stuff in AppsScript.gs there
- Deploy -> New deployment, Select type -> Web app, Description -> anything you want, Execute as -> ME (important), Who has access -> ANYONE (important)
- then Deploy, give permissions, things like that, don't mind the warning, it's because you're not certified
- now it should give you a URL. copy that URL and paste it in the SHEETS_WEBHOOK variable in script.js
- now deploy it to netlify! i'm not explaining how to do that go figure it out yourself
- in netlify, Project Configuration -> Environment variables
- set APP_PASSWORD to whatever you want for ALL contexts, don't set it to secret, doesn't work
- and it should be done! i think. if you encounter any issues please open an issue