Selectors for YouTube Video URLs
Want to extract YouTube video data straight into your spreadsheet?
You can see below the exhaustive list of selectors designed for any YouTube video pages. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our YouTuve video scraper template or use them by yourself in your own spreadsheet.
=IMPORTFROMWEB("YouTube video url", "title, views_count,likes_count")
=IMPORTFROMWEB(A2,B1:C1)
1. Video Information
| Selector | Description |
|---|---|
| title | Video’s title |
| description_header | Video’s description |
| published_date | Date video was first published |
| upload_date | Date video was uploaded |
| video_id | The unique identifier for the video on YouTube. |
| channel_url | The unique identifier for the channel that uploaded the video. |
| unlisted | Whether the video is unlisted or not. |
| category | The category that the video belongs to on YouTube. |
| thumbnail_image_url | The URL of the thumbnail image for the video |
2. Video Metrics
| Selector | Description |
|---|---|
| views_count | Number of views |
| likes_count | Number of likes |
| comments_count | Number of comments |
| isFamilyFriendly | Indicates if video is appropriate for all ages |
| paid | Indicates if video is for free users or paid |
| duration | Length of video |
3. Creator information
| Selector | Description |
|---|---|
| author | Video’s author |
| author_url | Author’s YouTube channel URL |
Selectors for YouTube Channels
Want to extract YouTube channel data straight into your spreadsheet?
You can see below the exhaustive list of selectors designed for any YouTube channel. These built-in data selectors are used within your =IMPORTFROMWEB( ) function; just pick them up directly in our YouTube channel scraper template or use them by yourself in your own spreadsheet.
=IMPORTFROMWEB("https://www.youtube.com/@espn/about", "title, description, subscribers_count")
1. Channel information
| Selector | Description |
|---|---|
| title | Channel’s title |
| description | Channel’s description |
| location | Channel’s location |
| join_date | Date channel was created |
| logo_url | URL of the channel’s logo |
| banner_url | URL of the channel’s banner |
2. Channel metrics
| Selector | Description |
|---|---|
| views_count | Cumulated number of videos views |
| subscribers_count | Number of channel subscribers |
| videos_count | Number of videos in channel |
3. Channel videos
You can see below the exhaustive list of selectors designed for any YouTube channel video list.
Note that you can retrieve the 30 first videos along with their meta data, and the channel URL must respect the format as written below:
=IMPORTFROMWEB("https://www.youtube.com/@espn/videos", "video_title,video_description,views_count")
| Selector | Description |
|---|---|
| video_title | Returns the title of the channel videos list |
| views_count | Extracts the views number of the channel videos list |
| video_duration | Extracts the duration of the channel videos list |
| video_description | Returns the description of the channel videos list |
| video_published_date | Returns the pubished_date of the channel videos list |
| video_thumbnail_source | Import the thumbnail source URL of the channel videos list |
| video_url | Extracts the URLs of the channel videos list |
Selectors for YouTube Search URLs
These selectors will retrieve data for the first 30 videos (in average) found with the YouTube search query.
| Selector | Description |
|---|---|
| video_title | Returns the title of the videos |
| video_channel_name | Returns the channel name of the videos |
| video_views_count | Returns the number of views for each video |
| video_published_date | Returns the published date for each video |
| video_thumbnail_image_url | Returns the thumbnail image URL for each video |