YouTube Comment Upvote & Reply Counter

I'm looking for a skilled developer to create a small, web-based script that will help me count upvotes and replies to a comment on YouTube comment urls. The script should interface with the free YouTube API and be implemented in Google Sheets using Apps Script option of Google sheet.

Key Requirements:
- The script must run on Google Sheets
- Data should be displayed in tables
- The script should be able to retrieve and update data as soon as run the script in Google sheet.
- We can enter 500 to 1000 urls in sheet and click on run and it displays the upvotes and replies data for those comment urls in sheet

Examples -
Comment url 1 - https://www.youtube.com/watch?v=l-nMKJ5J3Uc&lc=UgzZ_aanYy7pEzOl_B14AaABAg
This comment url has around 184 upvotes and 2 replies. (data you need to fetch)

Comment url 2 https://www.youtube.com/watch?v=4SNThp0YiU4&lc=Ugyv4vywhilDuUESxWN4AaABAg
This comment url has around 10K upvotes and 25 replies. (data you need to fetch)

Ideal Skills:
- Proficient in Google Apps Script
- Experience with YouTube API
- Strong understanding of Google Sheets
- Data visualization skills, specifically creating tables
- Ability to implement real-time data retrieval.