Our open source IT asset management system Snipe-IT prides itself on letting you move away from spreadsheets and Google Sheets, but there are times when you need to run a one-off script and you might not have the time (or programming resources) to create your on bespoke API integration solution for one-off data manipulation.
This repository contains a collection of Google App Scripts that can be used to manipulate data in your Snipe-IT instance quickly and easily.
When you have a Google Sheet with data in it and you'd like to run a Google Apps script on it, go to the sheet that contains the data in it and within the Sheets UI, go to Extensions, then Apps Script.
This will open the Apps Script editor. From there you can either copy and paste the code from the appropriate scripts in this repo, or add the script file using the left-side File menu in the Sheets UI.
These scripts are by design data destructive. Please always make sure you run a backup by going to Admin Settings > Backups before running them. That way if something gets messed up, you can easily restore to a known good point.
Each script lives in it's own directory within the repo. You will find a readme file within each directory that explains customizations (such as BREARER-TOKENS, your API endpoint, etc) that need to be made to the script before you can run it.