Kyle, thanks for the gret work. I am able to run the script in Google sheets but I get an error message saying "You have not configured your rest API credentials" I am guessing this is from the isConfigured() function validation that you do on line 112 of the code. I have checked the API credentials and they look fine. Moreover, I am able to retrieve data via the REST client on postman as well as via the browser. So the credentials look fine. Only difference is that I am providing the token in postman while you pull it dynamically and cache it. Any specific areas that you think I should look at to troubleshoot this?
I just tried this. At first, I ran into the same issues. Here are a couple of tips:
Isn't it easier to just push the registrations to a Sheet in real-time? You can also leave the Sheet read-only for users this way, as they don't need to update it themselves.
Were you able to pull any other fields other than the 3 originally outlined. I have been trying to figure that out, wanted to see if you have tried/had any luck.