Appearance
All videos by channel ID
You can retrieve a list of all videos of a specific channel with this query. You only need to provide the channel ID.
Parameters
Channel ID
You can limit the search down to content of a specific channel. Here you can only enter one channel ID which consists of 24 characters. How can I find the channel ID of a channel?
- Example:
UCFKE7WVJfvaHW5q283SxchA
Keywords
You can further filter the results by searching for keywords. You can use Boolean operators such as NOT (-) and OR (|) to refine your search. For example, to find videos with either "cars" or "bicycles" in the title, you can write cars|bicycles. To exclude a term, you can write '-motorcycles'.
Order by
Determines the order of search results returned by the YouTube API. Note that this sorting is applied by YouTube before the results are received in this Add-on. Options include:
- Unspecified: This setting is not documented and not recommended.
- Date: The videos with the newest publishing date will be shown first.
- Rating: The rating is an aggregate value based on the likes and dislikes a video has received (descending).
- View count: Videos are sorted by views (descending).
- Relevance (default): Results are sorted by relevance to the search terms (descending). The exact algorithm is not publicly disclosed.
- Title: Results will be sorted alphabetically by title (descending A-Z).
Maximum Results
Specifies the maximum number of results to return. The API natively supports 50 results for this type of query.
Note: Pagination allows Tube2Sheet to retrieve more than the 50 results natively supported by the YouTube API for this query type. When you request more than 50 results, Tube2Sheet automatically makes multiple API calls, each retrieving up to 50 results, to fulfill your request. Each of these calls counts separately against your monthly request quota, so requesting 500 results would use 10 requests from your quota.
Search Type
Filter the search results by the type of resource:
ChannelPlaylistVideo
Note: Several parameters below require the Search Type to be set to 'Video' to take effect. If you set any of those parameters 'Search Type' will automatically be set to 'Video'.
Region Code
Filters results by region. The Region Code parameter restricts search results to a specific region, defined by an ISO 3166-1 alpha-2 country code. Use this parameter to tailor your search results to a particular geographical area. For example:
USfor the United StatesINfor IndiaDEfor GermanyTWfor Taiwan
The Region Code can be useful for obtaining video content more relevant to a specific country or region. For a complete list of country codes, refer to the Wikipedia country code list.
Video Category ID
Filters video search results based on their category. Examples include:
1: Film & Animation10: Music20: Gaming23: Comedy24: Entertainment25: News & Politics28: Science & Technology
Note: If you select a Video category ID, you must set the 'Search Type' to 'Video'.
Video Definition
Filters video search results based on video definition.
Any (default): No filter applied.
Only HD videos: Limits results to high-definition videos.
Only SD videos: Limits results to standard-definition videos.
Note: If you select a Video Definition, you must set the 'Search Type' to 'Video'.
Video Duration
Filters video search results based on duration.
- Any (default)
- Long (20+ minutes)
- Medium (4-20 minutes)
- Short (0-4 minutes)
Note: If you select a Video duration, you must set the 'Search Type' to 'Video'.
Paid Product Placement
Only include videos that are denoted by the creator as having a paid promotion. Such videos show a "includes paid promotion" label in the top left corner of the video. You can find more information about product placement and paid promotion here.
- Any (default)
- Only with: Only include videos with paid product placements.
Safe Search
Includes restricted content based on the filtering level.
- No filtering
- Moderate (default)
- Strict
Note: If you set the Safe Search parameter, you must set the 'Search Type' to 'Video'.
Video Caption
Filters videos based on whether they have captions.
- Any
- Only with captions
- Only without captions
Note: If you set the Video caption parameter, you must set the 'Search Type' to 'Video'.
For Mine
Only retrieve content owned by you.
- True
- False
Note: If you set the 'For Mine'' parameter, you must set the 'Search Type' to 'Video'.
On behalf of content owner
Only retrieve content owned by you as a content owner. This parameter can only be used by YouTube content partners. Content partners own and manager several YouTube channels. This way you can retrieve information over several channels.
- True
- False
Columns
The data returned from this query can be customized using various output columns. Columns are categorized into basic columns and advanced columns.
Note: Click 'Show more' to display the advanced columns.
- Video ID: The unique identifier for the video. A Video ID has 11 characters. How can I find the video ID of a YouTube video?
- Channel Name: The name of the channel that uploaded the video.
- Description: A brief description of the video. A video description can have up to 5000 characters.
- Published Time: The date and time when the video was published. In ISO 8601 format, i.e.,
2022-07-06T04:31:00Zrepresents 4:31 AM on July 6, 2022, in UTC. - Video Title: The title of the video.
Advanced Columns
These columns provide additional details and are available for more in-depth data analysis:
- Kind ID: Information about the results you receive in the rows, like
youtube#videoto indicate that it is data related to a video. - Channel ID: The unique identifier for the channel that uploaded the video. [How can I find the channel ID of a YouTube channel?](How can I find the channel ID of a channel?)
- Live Broadcast Content: Information about whether the video is a live broadcast.
- Publish Time: The date and time when the video was published. In ISO 8601 format, i.e.,
2022-07-06T04:31:00Zrepresents 4:31 AM on July 6, 2022, in UTC. - Thumbnail [Default, Medium, High] Height: The height of the thumbnail image in three different resolutions.
- Thumbnail [Default, Medium, High] URL: The URL of the thumbnail image in three different resolutions.
- Thumbnail [Default, Medium, High] Width: The width of the thumbnail image in three different resolutions.
Note: Thumbnail sizes: Default (120x90), Medium (320x280), High (480x360).
For additional help, visit our FAQ or Troubleshooting sections.
