You can use Awesome Table Connectors to export data from YouTube to Google Sheets by logging in with the YouTube connector.
In the Awesome Table add-on Home screen, click Create new request.
The list of available connectors is displayed.
Open the YouTube connector.
On the Connect to YouTube screen, click Sign in with YouTube.
On the Google sign-in page, select your Google account.
Click Allow to grant Awesome Table permissions.Awesome Table informs you if your connection is successful.