Hi I'm interested. Since it's a Google spreadsheet therefore we need Google App script instead of excel vba. I work as a data analyst for client Google for 4+ yrs; additionally, my job role involves significant use of Google sheets for reporting and dashboarding, yes I do use app script for automating sheets and creating custom forms and many more. Also I'm a python programmer, so I am sure I can solve the problem you are facing with the API.
I don't charge upfront fee since I'm new to freelancer.com and trying to establish my consulting business. You can check my profile. Pay me only when you are satisfied with the project outcome.
I hope you will consider giving chance to a new Freelancer. The project will be done as per your timeline. I'll wait for your response.
Regards
Priyankita