Unpaywall is a delight to use and I highly recommend it. You can submit a list of DOIs on their page and it will e-mail you a detailed csv with the status of each. Very quick. 

-----Original Message-----
From: Code for Libraries <[log in to unmask]> On Behalf Of Rachel Smart
Sent: Monday, January 10, 2022 11:21 AM
To: [log in to unmask]
Subject: [EXT] [CODE4LIB] Sherpa Romeo API google apps script

APL external email warning: Verify sender [log in to unmask] before clicking links or attachments 

Hello,
I've been using a google apps script to check against the Sherpa Romeo database for publisher policy info for a large sets of publication data. It was published in an article for the code{4}lib journal in 2013, and Sherpa has since updated their API and the script no longer functions. Does anyone know of a newer Google Apps Script(specifically) that connects to the Sherpa Romeo API for the purpose of parsing publisher information regarding the OA status of a journal?

I believe I saw earlier posts here regarding a method of using Unpaywall and Openrefine to do something similar.

Referenced article: https://journal.code4lib.org/articles/7825
Referenced script: http://pastebin.com/sXknBHDq

Thanks,
Rachel