Skip to content

A collection of drop-in scripts that can be used with Google Sheets to perform one-off or recurring tasks in Snipe-IT from spreadsheets without a dedicated API integration

License

Notifications You must be signed in to change notification settings

grokability/google-apps-scripts-for-snipe-it

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Google Apps Scripts for Snipe-IT

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.

Using Google Apps Scripts

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.

Screenshot 2023-12-13 at 4 52 28 PM

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.

Important!

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.

Using these Scripts

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.

About

A collection of drop-in scripts that can be used with Google Sheets to perform one-off or recurring tasks in Snipe-IT from spreadsheets without a dedicated API integration

Topics

Resources

License

Stars

Watchers

Forks

Releases

No releases published