Hi greetings from Tushar!!
I am interested in taking up your project related to automating the API call nightly, using the API URL above and code in GIT HUB repository, so that the sheet is updated every night. I have hands on experience of working with google app script, google sheet, google API and google forms and have done few projects previously using google app scripts and google sheet functions. Let's connect over chat to discuss further on the requirements.
Looking forward to hear from you.
Thank you.