JSON Parser into CSV - AI Adoption & Ops Velocity - Kick Off

n8n_csv_parser.js

// Initialize the CSV with the header row
let csvOutput = "Quote,Author\n";

// Loop through all incoming items passed natively by n8n
for (const item of $input.all()) {
    // Safely navigate the JSON structure
    const content = item.json.content || {};
    const parts = content.parts || [];

    for (const part of parts) {
        const text = part.text || "";

        if (text.includes("—")) {
            // Split the quote and author by the em-dash
            const segments = text.split("—");
            let quotePart = segments[0];
            let authorPart = segments[1];

            // Clean up surrounding spaces, newlines, and outer quotes
            let quote = quotePart.trim().replace(/^"|"$/g, '');
            let author = authorPart.trim();

            // Handle internal quotes for valid CSV formatting (double them up)
            quote = quote.replace(/"/g, '""');
            author = author.replace(/"/g, '""');

            // Append the row to our output string
            csvOutput += `"${quote}","${author}"\n`;
        }
    }
}

// Return the final CSV string inside the structure n8n expects
return {
    csv_result: csvOutput.trim()
};