🎶 How to Create Playlists

To create a dynamic Spotify playlist, log in to your deployed app and navigate to the “Create Playlist” section, typically located at the /dashboard/create-playlist path.

🛠️ Defining a Playlist

On the creation page, you'll be able to:

• Name your playlist
• Set a track limit size
• Set a sort order, including optional nested priorities
• Define rules using smart filters

🎛️ Available Conditions

You can build your playlist using a variety of filters:

• Never Played – Tracks you've saved or liked but never played
• Most Played – Your top tracks based on play count
• Recently Added – Songs recently added to your saved albums or liked tracks
• Liked Songs by Artist – Only include liked tracks from specific artists
• Exclude Tracks – Filter out songs from the exclusions playlist

🧩 Available Data Fields

You can build filters using any of the following data fields:

• artist_name
• album_name
• track_name
• is_liked
• date_added_after
• date_added_before
• date_added_in_last_X_days
• min_plays
• max_plays
• plays
• last_played_at
• first_played

🔤 Expected Values

Each field expects specific input values:

• artist_name – Text (case-insensitive)
• album_name – Text (case-insensitive)
• track_name – Text (case-insensitive)
• is_liked – Boolean (TRUE or FALSE)
• date_added_after – Date (YYYY-MM-DD)
• date_added_before – Date (YYYY-MM-DD)
• date_added_in_last_X_days – Number of days since track was added (e.g. 30)
• min_plays – Integer (e.g. 1)
• max_plays – Integer (e.g. 5)
• plays – Integer (e.g. 1)
• last_played_at – Date (YYYY-MM-DD)
• first_played – Date (YYYY-MM-DD)

🔧 Available Operators

You can combine fields with operators to form powerful rules. Supported operators include:

• is
• is_not
• contains
• does_not_contain
• greater_than
• less_than
• greater_than_or_equal_to
• less_than_or_equal_to

You can nest multiple filters using ALL (AND) or ANY (OR) logic to create more complex rules.

After setting your conditions and saving, your playlist will be generated and updated automatically according to your selected schedule.

🚫 Using the Exclusions Playlist

When this app was initially set up, it automatically created a playlist called Exclusions. This playlist is designed to help you prevent certain tracks from appearing in any of your auto-generated playlists.

If you add any songs to the Exclusions playlist, they will be excluded from all auto-generated playlists during the next sync.

If you later want to allow those tracks back into your playlists, simply remove them from the Exclusions playlist. The next nightly sync will make them eligible for inclusion again.

⏱️ Syncing

Playlists are automatically synced when they are first created, ensuring they are immediately up to date. After that, each playlist is refreshed daily at 2:00 AM EST.

📅 Current Sync Schedule

• Every 10 minutes: We poll Spotify for your recent plays and handle duplicate entries.
• Every day:
  • Sync all albums
  • Sync album tracks for newly added albums and re-check previously added albums on a rolling schedule
  • Sync liked tracks — daily checks for changes in the past X days (configurable), and a full refresh every Sunday
  • Sync track availability — ensures we don’t add unplayable tracks to playlists
  • Sync exclusions playlist — updates the list of tracks to be excluded from playlists
• Build unified table: All your library and play data is merged into a single unified table for playlist generation.
• Sync dynamic playlists: After all the above tasks complete, each dynamic playlist is rebuilt and updated based on your configured rules.

🗑️ Deleting Playlists

If you want to delete any of your playlists, you can manage this directly in your Spotify app.

Find the automated playlist in your Spotify app and delete it like you would any other playlist.

During the next daily update, the system will check if the playlist is still associated with your account. If it is no longer found, the related rule logic will be automatically removed from the playlist_mapping database.

There’s no need to delete anything manually from the database — it all happens automatically.