Need a Google Sheet integration to pull YouTube Channel Stats

Job ID: 34032521

Budget: $10 – $30 USD

I need a Google Sheet that will run a script to query the YouTube API and return 5 columns of data for any channel ID entered into column A. I'm open to how the script is run. Please provide the details of how it would update the data in your bid.

Input: YouTube channel ID

Output: Channel Title, Channel Publish Date, # of Videos Published, Total Channel Views, Channel Subscriber Count

See attached picture for example of spreadsheet structure.
Related categories: Google Sheets Google APIs