This guide is for the official TubeSheet add-on. Install it to keep track of YouTube video & channel metrics directly inside Google Sheets.
By default, the figures in the sheet are raw numbers and you may find it difficult to interpret it especially when there are more than 7 digits. Select Extensions → TubeSheet → Settings → Customization, check Abbreviate counts and Save to enable this config.
This configuration abbreviates the numbers for you. For example, you will see 100K instead of 100,000,000.

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