Google Script files to use Google Sheets as a bulk checkout/checkin/edit tool for Snipe-it.
- Create a new Google Sheet
- Within your sheet, create another sheet called "Errors".
- Under the Extensions menu choose Apps Script.
- Under the File menu for the apps script, create new script files and html files with the same names as the files in this repo.
- Copy the contents of the repo files to their corresponding google script/html files.
- Enter your Snipe-it server URL and API key on the Setup.gs script.
- Save, then close and reopen your sheet. You should now see a "Run Command" option in the menu bar.
- From the Run Command menu, choose "Sync Snipe Locations". This will pull in all your location names to make check-in/check-out more reliable.
- Go back to your main tab and scan or enter asset tags in any single column. I use the Barcode to PC app. https://barcodetopc.com/
- Highlight the tags you just entered and then choose an option from the Run Command menu.
NOTE: You may need to first run one of the test functions manually (in the script editor) so Google will have you authorize the script's permissions.