Making a Master Database of all your favorite playlists from Crate Hackers

Подробнее о видео

All right, some of you asked about the creation of the master Crate Hackers database. First, I visit the Crate Hackers website and select the playlist to extract data from. I mark it as checked to indicate I've worked on it. Next, I open the PDF and click on an extension called Bardeen.

Bardeen works wonders by scraping data from the webpage and transferring it to my master CreateHackers list. The list includes artist title, mood, energy, playlist name, creator, and a direct Spotify link.

The magic continues with an app called AppSheet, which lives atop the master list and allows easy search functionality. For example, searching for Michael Jackson reveals all playlists featuring his music. The results display the name, creator, BPM, energy, dance, and mood. Clicking any link takes me directly to the Spotify playlist.

Another useful feature is filtering by various fields. Typing "Aaron" in the "created by" field brings up all playlists created by Aaron Traylor. The results show artist name, BPM, energy, dance, mood, and a direct Spotify link.

I hope you find this information helpful and enjoy using it.