Hey @eric4,
Glad that this got you going in the right direction!
In regards to populating your google sheet with the API response, I might recommend checking out StackOverflow or Google for some quick help. For instance:
Hope this helps!
Best,
Will