This is the gatsby-styled-blog-starter demo site. To download the code and get some instructions visit the Github repository . To be informed about updates follow @greglobinski

The Goodreads API in a Custom Function

Using the Goodreads API in a custom function to curate classroom book lists

September 16, 2017

Do you ever keep lists of books for your students on Goodreads? In this video I am showing how we can write a custom function to get data straight from the Goodreads API into a spreadsheet.

There are tons of things you can do with custom functions. I have made several videos demonstrating some of those things.

function GETAUTHOR(book) {
  book = encodeURIComponent(book);
  var url = '' + book;

  var response = UrlFetchApp.fetch(url).getContentText();

  var xml = XmlService.parse(response);

  var root = xml.getRootElement();

  var author = root

  return author;

Check out my video about how you can use autocompleting to make your custom functions more accessible to collaborators.


jordan rhea I started as a teacher and taught myself to code with Python and JavaScript. Now I am passionate about sharing code and strategies to make teachers (and other G Suite users) as effective as possible with technology.

© jordan rhea 2018