Hi,
I'm IIT CSE student,
I've excellent skills in python.
Did many automations in Google sheets.
I understand that you've you want a app script which calls the API at particular times and fill the google sheet.
I'm not an expert in app script, But I made two three mini projects with app script.
If you describe your requirements more clearly I can help you in your project and make it finish.
If you want I can create a script in Python, which will automatically which data into Google sheets.
let me know, If you're interested.
you can award me the project only after I show you some progress.
I'm trust worthy, you can check my reviews too.
thanks. waiting for your text