I’ve developed a Google Spreadsheet script to help libraries gather information to tackle their greatest challenge regarding institutional repositories: recruiting scholarly content.
Publishers vary in their copyright policies. Some grant no public re-use rights to the published PDF, while others permit authors to upload the published PDF to an institutional repository. Mashing up a list of those publishers against articles written by your faculty would normally be time intensive.
Grab the code at http://pastebin.com/sXknBHDq. Detailed implementation instructions are included in the comments. You can also watch this short installation screencast below.
#ACRL2013 poster session materials
The Code4Lib Journal - "Using XSLT and Google Scripts to Streamline Populating an Institutional Repository" (2013) - by Stephen X. Flynn, Catalina Oyler, Marsha Miles