Help with Google Books API
I want to start by clarifying that I am in over my head.
I work with a small, poor church in Africa that has just received some books for it's first library. This is incredibly exciting! However, our team would like to have a way to keep track of the books and we are using a google sheet to put in ISBN's and then auto-filling the rest of the data through Google's Book API.
The problem I'm having is that I am getting a 503 error almost every time I use it. Occasionally It'll pull 1 or 2 books, but then the error comes up. The code that I'm using is a few years old, so I assume that's where the issue is. I'm willing to share my sheet or the coding that is in it for help, but I'm also not sure if it's something on the API backend that I may not know about as well.
Here is a link to the form: https://docs.google.com/spreadsheets/d/1DqpU0ATnK4GTiV2RNzvBt5fAcE_VMcBt5Kqf65jzkAI/edit?usp=sharing
The 2nd tab has a spot to put in your Google API code, which I've deleted as I'm sure that shouldn't be shared wiley-niley.
I asked about this on the Google Sheets help forum, and had someone attempt to help me, but he wants me to input code into the code, and after trying to do that, it completely broke. I find Reddit to be friendlier than the Google forums, so I'm coming here hoping for some help.