CSV to JSON Conversion and Error Handling Workflow

This n8n workflow facilitates the conversion of CSV data received via a webhook into JSON format, with robust error handling and response mechanisms. It is useful for automating CSV uploads, processing them, and integrating with other services or reporting tools.

The workflow begins with a webhook node listening for incoming POST requests containing CSV data. Incoming data is then checked through a switch node that evaluates content type and binary data presence. If the data is a raw CSV text, it is processed by a code node that converts raw text into JSON object(s) by parsing CSV lines.

Subsequently, the workflow employs aggregate nodes to compile the processed data. If the data passes validation, it responds with a success message containing the JSON data. If an error occurs during parsing or processing, the workflow responds accordingly, either with an error message or by sending notifications, such as via Slack.

Additionally, the workflow includes sticky notes for documentation, and nodes for error notification that send messages to Slack with execution details, providing transparency and easy troubleshooting.

This workflow is ideal for scenarios where CSV files are uploaded or sent via API, requiring automated conversion to JSON for further processing or storage, with comprehensive error handling and alerts.