URL Scrape Script - BHH 20211019F

In spreadsheet https://docs.google.com/spreadsheets/d/1GmYRNUvKt_i80B_fxsP09Ajau-cQ7iaHvRkHNMGiDi8/edit?usp=sharing , Column F (Field2) are a list of Youtube channels. For each channel, we want the scraper script to find the Youtube URL of the channel. For example, in Row 2, the URL for 滾石唱片 ROCK RECORDS is https://www.youtube.com/@RockRecordsTaipei .

Candidates should state on which platform they plan to use, such as Google App Script, VBA, etc. Thank you