Hello, I can do your project.
This is so easy task that ,I can finish it within 5 minutes.
I have more than 2 years of experience in google sheets, google apps script and API.
If you are interested, Please contact me .
Waiting for your response.
Thanks in advance,.