This n8n workflow automates the process of importing data from a CSV file into a MySQL database with a manual trigger. It is ideal for situations where data updates or batch imports are needed without automation-based scheduling.

The workflow begins with a manual trigger allowing the user to initiate the process on demand. Once triggered, the ‘Read From File’ node reads a CSV file located at a specified path, in this case, ‘concerts-2023.csv’. The data read from the file is in binary format.

Next, the ‘Convert To Spreadsheet’ node processes this binary data, converting it into a spreadsheet format that can be easily manipulated or inserted into databases. This step prepares the data for database insertion.

Finally, the ‘Insert into MySQL’ node takes the processed spreadsheet data and inserts it into a predefined MySQL table named ‘concerts_2023_csv’. It maps the CSV columns such as Date, Band, ConcertName, Country, City, Location, and LocationAddress to the corresponding database columns.

This workflow is particularly useful for updating database content with new CSV data batches, such as importing concert schedules, event listings, or any structured tabular data into a database for further analysis or display on a website.