Developing Library Applications in Google Sheets with Google Apps Script

Google Apps script is a server-side implementation of JavaScript which supports API calls to Google Services. This can provide an excellent platform for developing simple library applications. The libraries at Georgetown University and the University of Dayton have successfully deployed applications built with Google App Script. In this workshop, we will step through the various types of applications that can be built with Google Apps Script. (1) Custom cell formulas (2) Spreadsheet Add On Functions (menu items, time based triggers) (3) Google Apps Script as a Web Service (4) Google Apps Script Add-Ons that can be shared globally or by domain In this workshop, we will build sample instances of each of these types of applications (wifi-permitting) and spend some time brainstorming additional applications that would be useful for the library community. Sample Applications: http://georgetown-university-libraries.github.io/#google-sheets

1:30-4:30
Room: Powell Library (3rd Floor) CLICC Classroom B
https://2017.code4lib.org/workshops/Developing-Library-Applications-in-Google-Sheets-with-Google-Apps-Script
2017.code4lib.org
crawl=CC-MAIN-2019-47
15040
application/http; msgtype=response
sha1:LKWBWF6ZLLLQE4SPSBB3Q373JWCZE7U2
<urn:uuid:10e60ddd-a583-4552-8b9d-2a4fd83a5852>
2019-11-19T14:14:36Z
185.199.110.153
text/html
sha1:DEYOPGZPARESI5JAGITLVYF57CHGXV7Z
<urn:uuid:3e4c7827-2737-44b8-9bea-d875cf04e46c>
https://2017.code4lib.org/workshops/Developing-Library-Applications-in-Google-Sheets-with-Google-Apps-Script
response
<urn:uuid:e559aa61-1bf2-4a0a-986d-42965c1fdf04>
isPartOf: CC-MAIN-2019-47
publisher: Common Crawl
description: Wide crawl of the web for November 2019
operator: Common Crawl Admin (info@commoncrawl.org)
hostname: ip-10-67-67-55.ec2.internal
software: Apache Nutch 1.16 (modified, https://github.com/commoncrawl/nutch/)
robots: checked via crawler-commons 1.1-SNAPSHOT (https://github.com/crawler-commons/crawler-commons)
format: WARC File Format 1.1
conformsTo: http://iipc.github.io/warc-specifications/specifications/warc-format/warc-1.1/