Create a video gallery from Youtube
Make your own video gallery
If you want to share some videos on your website, you can create a nice video gallery with picture preview, description and Youtube direct link.
Manage your video list on Sheets and share it easily with onleetable.
Create the Sheets for your Youtube videos
This is really easy, make a copy of this template : Youtube Gallery Template
Once you created your own copy open it, the Sheets is filled with some data for the example. To use your own video you just have to remove the data and add your Youtube url in the column A, blue background.
Youtube video gallery with onleetable
When you have added your Youtube urls in the column A to get Title, Description, picture etc... you just need to click on the butoon "Get Youtube Data". At first launch you will have to validate the scope.
Behind the button there is an Apps Script code that will collect the data for each video on Youtube and fill the sheets.
That's all now your Sheets is ready with all the information needed and we will now create the onleetable.
Create onleetable and embed your Youtube Gallery on your site
In the sheets, open onleetable from the right sidebar.
If it is the first time you open onleetable for this sheets, validate access.
Then select Column B to F and click "Refresh Selection".
Expend "Design" section and activate "Card view".
Click "Create" or "Save"
For the zone selection do not select the column A as we just need it to extract the Youtube data. As onleetable adjust automatically the selection to the rows with data, the best to have a dynamic Gallery is to select the column B to F and not a specific zone. By this way when you add a new video to the Sheets it is automatically integrated to your onleetable.
Create Youtube personnal gallery with onleetable
Youtube Gallery Example
Regarding Apps Script to extract Youyube Data
To view the script, in the Google Sheets go to "Extensions > Apps Script". This will open the script page and you can modify it.