Skip to content
Support barcode scanning inventory process using data from the Sierra Integrated Library System - Google Apps Script
Branch: master
Clone or download
Latest commit 16a8372 Apr 5, 2017
Type Name Latest commit message Commit time
Failed to load latest commit information.
gs-addon Handle missing dup column Nov 10, 2016
gs deprecate old code Dec 2, 2016
PITCHME.yaml Update PITCHME.yaml Jan 3, 2017 Update Dec 2, 2016



Support barcode scanning inventory process using data from Sierra.

Results are exported to Google Sheets using a service provided in the following project:

Demonstration Video

This video demonstrates a barcode scanning inventory workflow developed by the Georgetown University Library.

Demonstration Video


  • Access Services student works will scan a shelf of books into a web page.
  • The response from the PHP Service returns a status: PASS, FAIL, PULL that indicates the action the student worker will take with the item that was scanned.
  • The call number of the scanned item is compared to the previously scanned item. Items out of sort order will be color coded.
  • Student validates the Call Number, Title, and Volume on the book. The student marks items with incorrect information.
  • Items in error are pulled from shelves
  • Scanning results are exported to Google Sheets. Corrections are made into Sierra using these results.
  • The table is cleared an a new scanning session is started.

BarcodeInventory Analysis Using Google Sheets

A Google Sheet Add-On has been developed to process the results of this inventory process. That process is described in Post Inventory Analysis - Google Sheets Add-On.

Scanning Tool Using Google Sheets (Oboslete Code)

Intially, the barcode inventory tool was develoepd to run inside Google Sheets. This version of the process was abandoned due to poor performance. The Code is available here: GoogleSheets Code


This project was inspired by a project from the University of Dayton Library:

This code uses a LC Call Number Sort module developed by Ray Voelker from the University of Dayton Library:

Georgetown University Library IT Code RepositoriesGeorgetown University Library IT Code Repositories

You can’t perform that action at this time.