Quick start

Youtube is a leading video-sharing website hosting millions of clips. It allows to create playlists however they are not always functional. Therefore Linkest gives you possibility to create bespoke playlists with advanced functions.

With Linkest you will be able to create and subdivide playlists and create links to other playlists, as well as add links to additional sources. The Linkest also allows to promote videos which will be posted in the future and to use Google sheets features to create and manage playlists.

Published playlist is available for everybody by unique link without registration or any other limitations.

Below we provide a few examples of Linkest features

Example 1: You want to create a playlist with videos from conferences. You may want to split videos into groups by topic or location – and it is really easy by creating folders in your playlist. Over time, you may decide that your playlist has too many videos which makes video search difficult - with Linkest you can move your videos into new smaller playlists. In this way, you will be able to organize your videos in a number of interlinked playlists, thus significantly improving the ease of navigation through your videos.

Example 2: You want to create a playlist with your favorite football team matches. If you are putting these videos together, you can highlight key moments of the game, such as goals, red and yellow cards, and penalties, on each video so that the viewers can find them easily.

Example 3: You are planning to make videos of programming classes, you have a plan, but you have recorded only a few first classes. On Linkest playlists you can promote classes you are planning to record by adding their titles to the playlist. Also you can add links to other sources to your videos, folders and playlists. For instance, to a course video you can add links to the professor’s webpage, presentations or case studies from the course. This will facilitate study process.

An important feature of Linkest playlists is that you create them using Google sheets. (If someone is not familiar with this product, it is enough to say that it on-line analog of MS Excel). So you have almost unlimited possibilities for creating, editing and automation of your playlists. Also you have lots of possibilities for team-work.

Look our video tutorial to understand how to create your playlists.

To create and publish your playlist, follow these steps:

  1. Go to Google Drive
  2. Install add-on Linkest
  3. Create a new Google sheets
  4. Create a new playlist and fill-in it
  5. Check the data and correct errors
  6. Publish playlist
  7. Share playlist

Open created Google sheets. To Install add-on Linkest select Add-ons, then Get add-ons... Enter Linkest into the search line, find it and install.

After installing add-on the Linkest menu will appear in sheets menu. It contains the following items:

  1. Create template: Prepared active sheet for playlist data.
  2. Check playlist: Checks the current playlist and displays error messages.
  3. Publish playlist: Publishes the current playlist. Action Check playlist are also automatically executed at this step.
  4. More options:
    1. Move playlist to other spreadsheet: Allows to move active playlist with his link to other spreadsheet.
    2. Show instructions:Shows short instructions.

To create a playlist, click Create template

Playlist sheets consists of next parts:

  • Cell A1: Playlist’s name
  • Cell A2: Description of playlist
  • Cell A3: Link to the playlist. It is read-only cell. To get link to the current playlist click Register or Verify playlist link.
  • Cell A4: The date of the last publication of the playlist. It is read-only cell. This field is updated after the publication of the playlist.
  • Cells A6-F1000: Table with the descriptions of playlist items.

Table with the descriptions of playlist items consists of next parts:

  • Column A: Type of the item.
  • Column B. Name of the item. The length of the name should be less than 200 characters.
  • Column C: Start time of the video. Format: hh:mm:ss. This field should be left blank for Folder, Playlist, Announcement and Link. For Video this field is optional. For Part this field is necessary.
  • Column D: End time of the video. Format: hh:mm:ss. This field should be left blank for Folder, Playlist, Announcement and Link. For Video and Part this field is optional.
  • Column F: Error messages. If any errors or incomplete information it fills-in automatically after Check playlist, Publish playlist and Publish all playlists actions.

Playlist can contain only items of the following types:

  1. Video: Use this type to add videos to playlist. Field URL must contain correct link to youtube video. "Start time" and "End time" fields can be empty or contain correct time.
  2. Part: Use this type to identify the parts of video. You can add items of this type only under a video type item. Field URL must contain the same link as a video above. Start time field can not be empty. Finish time can be empty or contain later time than Start time field.
  3. Heading: Use this type to split up playlist to different parts. It can contain only Name. Fields "URL", "Start time" and "End time" must be empty.
  4. Playlist: Use this type to add links to other playlist. Field URL must be correct link to other Linkest playlist. Fields "Start time" and "End time" must be empty.
  5. Announcement: Use this type to add announcement of future video. It can contain only Name. Fields "URL", "Start time" and "End time" must be empty.
  6. Link: Use this type to add any links to Video, Part, Folder, Announcement or Current playlist. You must put this item directly under Video, Part, Folder or Announcement (or in the top of the playlist if you want to add links to Current playlist). Fields "Start time" and "End time" must be empty.

When you Publish playlist, note the following points:

  • All lines with errors will not be published.
  • If the line with the type Video contains an error - all the lines with type Part related to this video will not be published.
  • If the line with any kind of type contains an error, all the lines with type Link related to this line will not be published.
  • If the line has type Playlist, all the lines with type Link related to this line will not be published.

By clicking Publish playlist, you save the current version of your playlist on our server and it becomes available for your viewers through a link in cell A3. If you publish a playlist for the first time it will be automatically associated to the new link.

To move a playlist with his link to other spreadsheet, use the function More options > Move playlist to other spreadsheet