Automated CSV File Processing and Logging in Excel

This n8n workflow automates the process of monitoring a specific folder in OneDrive for new files, particularly CSV files, and seamlessly imports their data into an Excel spreadsheet while logging updates. It starts with a trigger that detects new files added to the watched folder. If the file is a CSV, it downloads the file and extracts data from it. The workflow then prepares the extracted data and updates a specified Excel sheet with this information, maintaining an organized record of incoming data streams. It also handles non-CSV files by stopping execution and logging errors, ensuring clean operation. This workflow is ideal for automating data entries, consolidating reports, or keeping a live dashboard updated with the latest CSV data, significantly reducing manual effort and minimizing errors in data entry tasks.