N8N Flow Development for Excel Processing

Замовник: AI | Опубліковано: 06.10.2025

Hey, I’d like to have an N8N flow built with the following steps: STEP 1: Input via N8N Form The form contains: A field for email address A field for uploading an Excel file STEP 2: Processing the Excel For each row in the uploaded Excel file, an ASCII code must be constructed. This ASCII code consists of 8 elements: Employer number Employee number Type (always “K”) Date (YYYYMMDD) Day code (e.g., 7010, T010, T900 … depending on the situation) Number of hours (format xxyy → 0800 for 8 hours, 0750 for 7h30, …) Shift code (2 characters, alphanumeric) Cost center (30 characters, usually the customer name) The values for these 8 elements come from different sources: Some come from the uploaded Excel (e.g., date, number of hours). Some come from a second Excel/lookup file (e.g., employer number, employee number). Other fields are calculated or fixed (e.g., Type = “K”). Step 3: Output The output is a new Excel file. The structure of that file must be: Column 1: the full ASCII code (concatenation of the 8 elements) Columns 2 through 9: the 8 individual elements side by side (for verification and transparency) STEP 4: Send the output The resulting Excel must be emailed to the address provided in the input form. I need a JSON file that I can upload in N8N with clear instructions. Ideally I get a video where you go through the N8N workflow to explain every node and how I need to fill in all the parameters.