Journal article Open Access

Managing Institutional Bibliographies with the ADS API: A new workflow using Google Sheets

Damon, James; Henneken, Edwin; Accomazzi, Alberto

Citation Style Language JSON Export

  "publisher": "Zenodo", 
  "DOI": "10.5281/zenodo.803347", 
  "title": "Managing Institutional Bibliographies with the ADS API: A new workflow using Google Sheets", 
  "issued": {
    "date-parts": [
  "abstract": "<p>Curating institutional bibliographies with the ADS web interface is currently a manual process that scales with the number of search terms. Long author lists and institutions with multiple sub-organizations or name variations increase the workload. Review work is monotonous and can take significant time depending on the size of the institution and the frequency of reviews. Consequently, bibliographies generated in this way are costly and may suffer from human error. We propose a semi-automated workflow that uses an iterative approach to discovery with ADS\u2019s new search engine and a recently developed Google Sheets add on. First, affiliation strings from a user created spreadsheet are searched with the ADS API and for each result the matched affiliation and the paired author are retrieved. Next, each author name string is searched and items where that author is paired with an empty affiliation field are retrieved. The results from both queries are then compiled into output sheets with pertinent information for manual review. Finally, the selected items can be added to an ADS library from the Google Sheets interface. The tool can also use previously rejected affiliation strings to flag false positives in subsequent queries. Curators do not need to have extensive technical skills in order to use the workflow and they can help improve the ADS by opting to share ORCIDs, author synonyms, and affiliation synonyms.</p>", 
  "author": [
      "family": "Damon, James"
      "family": "Henneken, Edwin"
      "family": "Accomazzi, Alberto"
  "note": "NASA ADS is operated by the Smithsonian Astrophysical Observatory under NASA Cooperative Agreement NNX16AC86A", 
  "type": "article-journal", 
  "id": "803347"
All versions This version
Views 163163
Downloads 6565
Data volume 12.0 MB12.0 MB
Unique views 155155
Unique downloads 6363


Cite as