Hello, I can do this project for you.
I have completed this type of project recently.
So , It will be easy for me to complete this task.
I have more than 2 years of experience in google sheets, google apps script and API.
You can check my reviews so that You will have overall idea about how I am able to do tasks in Google apps script.
$1 per hour is too cheap so I want $5 per hour, Due to my quality work.
If you really want quality work then you can contact me , else you can choose any other freelancer.
waiting for your response.
Thanks in advance.