n8n Email-to-Excel Automation

Job ID: 39927133

Budget: ₹12,500 – ₹37,500 INR

I’m looking to replace my manual spreadsheet routine with an end-to-end workflow built in n8n (or a comparable open-source tool). Every time I send a structured Email containing transaction and inventory details, the system should:

• Parse the message and append a clean, timestamped row to a master Excel workbook.
• Update supporting sheets for the journal and general ledger automatically.
• Recalculate and refresh three core reports—Balance Sheet, Income Statement, and Cash Flow Statement—so they’re always current.

Key points
• The email format will stay consistent, making field mapping straightforward.
• The Excel file may sit in OneDrive or a local folder; let me know which approach you prefer for reliability.
• I’m open to using ancillary libraries (e.g., XLSX, Pandas, Power Query) if they improve speed or stability, but keep everything editable in Excel.
• Basic validation, error logging, and duplicate-prevention matter to me.
• Clear documentation and a short Loom-style walkthrough are expected so I can tweak the flow later.

When you reply, include a detailed project proposal outlining your approach, tool stack, estimated timeline, and any similar automations you’ve shipped. I’m ready to move quickly once I see a well-structured plan.