This guide is for the official TubeSheet add-on. Install it to keep track of YouTube video & channel metrics directly inside Google Sheets.
To list the videos of a channel, first you must have added the channel to the channel tracking sheet.
In the channel sheet, select the channel ID cell in the first column. For that channel TubeSheet is going to list the video details. Fetched video data will resemble the video tracking sheet. After highlighting the cell in the first column, select Extensions → TubeSheet → Fetch Channel Videos.
If the selected cell doesn't have a proper channel ID, you will see an error alert in the bottom right corner of the sheet. Else, a new sheet tab is created and the videos of the channel is listed in descending order of upload time.

Install TubeSheet from the Google Workspace Marketplace today and start automating YouTube video and channel analytics tracking directly inside Google Sheets.