“My workflow concept is as follows: there is one Excel worksheet file that serves as the main file. Then, whenever a new file is received, I want all the data from the new file to be automatically transferred into the first worksheet. For example, the first file is the master file containing all records, and when employees in my company send me a new file, I want the workflow to automatically collect the data from the second Excel file and append it as new rows into the table in the first file immediately and automatically.”
What have tried so far?
Are new files coming in have same format as the master file? Are they of the same columns? If you can provide more information, tharlt would be great.
Yes, the coming up file has the same column and data with justr a new date. my example is like I’ve got a Master file of sale data 1-15 May 2026 and the employee continue sending me new record everyday like sales data on 16, 17 and i want to put the coming excel files into the master automatic. @SevvyR
Are they sending the new file via email? What is the trigger? Or they simply input data into your tool and upon submission you wanted those information copied directly to your master file?
What error are you getting? Would like to check where you gor stuck. At any rate Google sheet ir airtable has append instance which you can directly use to process your inputs. which part did you encounter error?
If the columns already match, the cleanest pattern is: watch the incoming folder, read the new workbook, append rows to the master file, then archive the processed file. Which file store is the master on - OneDrive, Google Drive, or local disk?
Welcome to the n8n community @WIKROM_KAPAOTHONG
There is this official template, it doesn’t exactly do “append to a master file” out of the box, but it shows the foundation: read the received Excel, transform the data and save the result. From there, the workflow would be: monitor folder/email + read new Excel + map columns + append to master file + save/update the master.
Working with Excel spreadsheet files (xls & xlsx) | n8n workflow template
Hi @WIKROM_KAPAOTHONG ,
Here are good references that can help you get started.