This guide is for the official TubeSheet add-on. Install it to keep track of YouTube video & channel metrics directly inside Google Sheets.
You can fetch the playlists belonging to a channel using TubeSheet. From a channel tracker sheet, focus a channel ID in the first column and select Extensions → TubeSheet → Playlists → Fetch playlists.
TubeSheet will create a new sheet to list the playlists of that channel. If the channel doesn't have any playlists, you will get an alert in the bottom right corner.

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