Hackernews submitted posts

export_hackernews_submitted_posts.js

(function () {
    const popup = createPopup('HN submitted');
    if (location.host != 'news.ycombinator.com' || !(location.pathname == '/user' || location.pathname == '/submitted'))  {
        popup.innerHTML = 'ERROR: Go to your user or submitted page on HN and then try again.';
        return;
    }
    const id = location.search.split('=')[1];
    const types = {
        csv: {
            header: 'Name,URL',
            filename: id + "'s HN submitted",
            totype: f => toCSV(f.name, f.url)
        },
        html: {
            header: '<title>' + id + "'s HN submitted</title><style>body {font-family: sans-serif;}</style><h1>" + id + "'s HN submitted</h1>",
            filename: id + "'s-HN-submitted",
            totype: f => '<p>' + link(f.url, f.name)
        }
    };
    const submitted = [];
    const form = popup.appendChild(document.createElement('form'));
    form.innerHTML = 
        '<input id=query> <button type=submit>Search</button> ' + 
        'Export to <button id=exportToCSV data-filetype=csv>CSV</button> ' + 
        '<button id=exportToHTML data-filetype=html>HTML</button><br><br>' +
        '<div id=results></div>';
    query.focus();
    form.onsubmit = async function (event) {
        event.preventDefault();
        const re = new RegExp(query.value, 'i');
        await getsubmitted();
        const found = submitted
            .filter(f => f.name.match(re) || f.url.match(re))
            .map(f => '<tr><td>' + link(f.url, f.name) + '<td>' + link(f.url, f.url));
        results.innerHTML = found.length ? '<table>' + found.join('') + '</table>' : 'not found';
    };
    exportToCSV.onclick = exportToHTML.onclick = async function (event) {
        event.preventDefault();
        const filetype = this.dataset.filetype;
        await getsubmitted();
        downloadFile(types[filetype].header, submitted.map(types[filetype].totype), types[filetype].filename, filetype);
        results.innerHTML = 'Finished exporting.';
    };
    async function getsubmitted() {
        if (submitted.length > 0) return;
        var url = `submitted?id=${id}`;
        var page = 1;
        while (url) {
            results.innerHTML = `Fetching page ${page++} ...<br><br>`;
            const response = await fetch(url);
            const html = await response.text();
            const parser = new DOMParser();
            const doc = parser.parseFromString(html, 'text/html');
            doc.querySelectorAll('span.titleline > a').forEach(a => submitted.push({name: a.innerText, url: a.href}));
            const more = doc.querySelector('a.morelink');
            url = more?.href;
            if (more) {
                await sleep(850);
            }
        }
    }

    function createPopup(title) {
        const div = document.body.appendChild(document.createElement('div'));
        div.innerHTML = title + " <a onclick='document.body.removeChild(this.parentNode)' style='cursor: pointer; padding: 4px'>X</a><br><br>";
        div.style.cssText = 'position: absolute; padding: 8px; top: 4px; color: black; background-color: white; z-index: 1001; border: 1px solid #ddd;';
        return div.appendChild(document.createElement('div'));
    }
    function toCSV(...fields) {
        return fields.map(field => `"${field == undefined ? "" : field.toString().replace(/"/g, '""')}"`).join(',');
    }
    function downloadFile(header, lines, filename, filetype) {
        const a = document.body.appendChild(document.createElement('a'));
        a.href = URL.createObjectURL(new Blob([header + '\n' + lines.join('\n')], {type: 'text/' + filetype}));
        const date = new Date().toISOString().replace(/[T:]/g, '-').slice(0, 19);
        a.download = `${filename}-${date}.${filetype}`;
        a.click();
    }
    async function sleep(time) {
        return new Promise(resolve => setTimeout(resolve, time));
    }
    function link(url, text) {
        return `<a href="${url}" target=_blank>${text}</a>`;
    }
})();

gistfile1.txt

Download HackerNews (HN) submitted posts as CSV and import into google sheets. This works as of January 2, 2025.

Instructions:

Open HN submissions page by pasting this link https://news.ycombinator.com/submitted?id={put your username} in chrome or 
clicking on submissions in your HN profile page.
Paste above script in console and click CSV button to get the CSV.

Credit goes to Gabriel Sroka's repository https://github.com/gabrielsroka/gabrielsroka.github.io. He has a getHNFavorites.js 
file: https://github.com/gabrielsroka/gabrielsroka.github.io/blob/master/getHNFavorites.js from which inspiration was taken 
with some minor changes. This is the HN discussion related to the Favorites script 
https://news.ycombinator.com/item?id=22788236.