☰

Spotify Playlist Extractor

Extracts song titles, artists, albums and durations from a Spotify playlist

当前为 2025-05-22 提交的版本，查看 最新版本。

// ==UserScript==
// @name         Spotify Playlist Extractor
// @namespace    http://tampermonkey.net/
// @version      2025-05-22.2
// @description  Extracts song titles, artists, albums and durations from a Spotify playlist
// @author       Elias Braun
// @match        https://*.spotify.com/playlist/*
// @icon         https://raw.githubusercontent.com/eliasbraunv/SpotifyExtractor/refs/heads/main/spotifyexcel6464.png
// @grant        none
// @run-at       document-idle
// @license      MIT
// ==/UserScript==

(async function () {
    'use strict';

    function sanitize(text) {
        return text
            ? text.replace(/\u200B/g, '').replace(/\s+/g, ' ').trim()
            : '';
    }

    function waitForScrollContainer(timeout = 10000) {
        return new Promise((resolve, reject) => {
            const startTime = Date.now();
            const interval = setInterval(() => {
                const el = document.querySelectorAll('div[data-overlayscrollbars-viewport="scrollbarHidden overflowXHidden overflowYScroll"]');
                const els = el[1];
                if (els) {
                    clearInterval(interval);
                    resolve(els);
                } else if (Date.now() - startTime > timeout) {
                    clearInterval(interval);
                    reject('Scroll container not found in time');
                }
            }, 300);
        });
    }

    function extractVisibleSongs() {
        const rows = document.querySelectorAll('div[data-testid="tracklist-row"]');
        const songs = new Map();

        rows.forEach(row => {
            try {
                const titleLink = row.querySelector('div[aria-colindex="2"] a[data-testid="internal-track-link"] div.encore-text-body-medium');
                const title = sanitize(titleLink?.textContent);

                const artistAnchors = row.querySelectorAll('div[aria-colindex="2"] span.encore-text-body-small a');
                const artist = sanitize(Array.from(artistAnchors).map(a => a.textContent).join(', '));

                const albumLink = row.querySelector('div[aria-colindex="3"] a');
                const album = sanitize(albumLink?.textContent);

                const durationDiv = row.querySelector('div[aria-colindex="5"] div.encore-text-body-small');
                const duration = sanitize(durationDiv?.textContent);

                if (title && artist && album && duration) {
                    songs.set(
                        title + '||' + artist + '||' + album + '||' + duration,
                        { title, artist, album, duration }
                    );
                }
            } catch {
                // skip rows that don't fit pattern
            }
        });

        return Array.from(songs.values());
    }

    async function scrollAndExtractSongs(scrollContainer) {
        const collectedSongs = new Map();
        let previousScrollTop = -1;
        let sameCount = 0;

        while (sameCount < 5) {
            const visibleSongs = extractVisibleSongs();
            visibleSongs.forEach(({ title, artist, album, duration }) => {
                collectedSongs.set(title + '||' + artist + '||' + album + '||' + duration, { title, artist, album, duration });
            });

            scrollContainer.scrollTop += 500;
            await new Promise(r => setTimeout(r, 100));

            if (scrollContainer.scrollTop === previousScrollTop) {
                sameCount++;
            } else {
                sameCount = 0;
                previousScrollTop = scrollContainer.scrollTop;
            }
        }

        return Array.from(collectedSongs.values());
    }

    function formatSongsForClipboard(songs) {
        return songs.map(({ title, artist, album, duration }) =>
            `${title}\t${artist}\t${album}\t${duration}`
        ).join('\n');
    }

async function copyToClipboard(text, songCount) {
    try {
        await navigator.clipboard.writeText(text);
        alert(`${songCount} songs extracted`);
    } catch (e) {
        console.error('❌ Failed to copy playlist to clipboard:', e);
        alert('❌ Failed to copy playlist to clipboard. See console.');
    }
}

    // Function to run extraction + copy
async function extractAndCopy() {
    try {
        console.log('⏳ Waiting for scroll container...');
        const scrollContainer = await waitForScrollContainer();
        console.log('✅ Scroll container found. Scrolling and collecting songs, artists, albums, and durations...');

        const allSongs = await scrollAndExtractSongs(scrollContainer);

        console.log(`🎵 Done! Found ${allSongs.length} unique songs:`);
        console.table(allSongs);

        const formattedText = formatSongsForClipboard(allSongs);
        // Pass songs count to copyToClipboard
        await copyToClipboard(formattedText, allSongs.length);
    } catch (err) {
        console.error('❌ Error:', err);
        alert('❌ Error occurred during extraction. See console.');
    }
}

    // Inject the "Extract" button next to existing button
async function addExtractButton(retries = 10, delayMs = 2000) {
    for (let i = 0; i < retries; i++) {
        const existingButton = document.querySelector('button[data-testid="more-button"]');
        if (existingButton) {
            // Create the new button
            const extractButton = document.createElement('button');
            extractButton.className = existingButton.className; // clone classes
            extractButton.setAttribute('aria-label', 'Extract playlist data');
            extractButton.setAttribute('data-testid', 'extract-button');
            extractButton.setAttribute('type', 'button');
            extractButton.setAttribute('aria-haspopup', 'false');
            extractButton.setAttribute('aria-expanded', 'false');

            extractButton.innerHTML = `<span aria-hidden="true" class="e-9911-button__icon-wrapper" style="font-weight: 600; font-size: 1rem; line-height: 1; user-select:none;">Extract to Clipboard</span>`;

            existingButton.parentNode.insertBefore(extractButton, existingButton.nextSibling);

            extractButton.addEventListener('click', extractAndCopy);

            console.log('Extract button added');
            return; // done
        }

        console.warn(`Could not find existing button, retrying ${i + 1}/${retries}...`);
        await new Promise(res => setTimeout(res, delayMs));
    }

    console.error('Failed to add Extract button: existing button not found after retries.');
}


// Run addExtractButton after a short delay so page elements are loaded
setTimeout(addExtractButton, 2000);

})();