n8n for Finance Teams & Fintech: 5 Automations That Replace Manual Spreadsheet Work (Free Workflow JSON)

{
  "name": "Daily Cash Flow Briefing",
  "nodes": [
    {
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": {
        "rule": { "interval": [{ "field": "cronExpression", "expression": "0 7 * * 1-5" }] }
      }
    },
    {
      "name": "Get Revenue Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "getAll",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Revenue!A:E"
      }
    },
    {
      "name": "Get Expense Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "getAll",
        "sheetId": "YOUR_SHEET_ID",
        "range": "Expenses!A:E"
      }
    },
    {
      "name": "Build Report",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const rev = $input.first().json; const exp = $input.last().json;\nconst revenue = rev.reduce((s, r) => s + parseFloat(r.amount || 0), 0);\nconst expenses = exp.reduce((s, r) => s + parseFloat(r.amount || 0), 0);\nconst netIncome = revenue - expenses;\nconst margin = revenue > 0 ? ((netIncome / revenue) * 100).toFixed(1) : 0;\nconst html = `<h2>Daily P&L — ${new Date().toDateString()}</h2><table border='1' cellpadding='8'><tr><td><b>Revenue</b></td><td>$${revenue.toLocaleString('en-US', {minimumFractionDigits:2})}</td></tr><tr><td><b>Expenses</b></td><td>$${expenses.toLocaleString('en-US', {minimumFractionDigits:2})}</td></tr><tr><td><b>Net Income</b></td><td>$${netIncome.toLocaleString('en-US', {minimumFractionDigits:2})}</td></tr><tr><td><b>Margin</b></td><td>${margin}%</td></tr></table>`;\nreturn [{ json: { html, revenue, expenses, netIncome } }];"
      }
    },
    {
      "name": "Email CFO",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "to": "cfo@yourcompany.com",
        "subject": "Daily P&L — {{ $now.format('MMM D, YYYY') }}",
        "message": "{{ $json.html }}",
        "options": { "bodyContentType": "html" }
      }
    }
  ]
}

{
  "name": "Invoice AP Workflow",
  "nodes": [
    {
      "name": "Invoice Webhook",
      "type": "n8n-nodes-base.webhook",
      "parameters": { "path": "invoice-received", "responseMode": "responseNode" }
    },
    {
      "name": "Parse Invoice",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const body = $input.first().json.body;\nconst amount = parseFloat(body.amount || body.total || 0);\nconst vendor = body.vendor_name || body.from || 'Unknown';\nconst dueDate = body.due_date || body.payment_due;\nconst poNumber = body.po_number || body.reference || '';\nreturn [{ json: { amount, vendor, dueDate, poNumber, rawBody: body, needsApproval: amount >= 2000 } }];"
      }
    },
    {
      "name": "Log to Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "appendOrUpdate",
        "sheetId": "YOUR_SHEET_ID",
        "columns": { "mappingMode": "defineBelow", "value": { "vendor": "={{ $json.vendor }}", "amount": "={{ $json.amount }}", "due_date": "={{ $json.dueDate }}", "po_number": "={{ $json.poNumber }}", "status": "pending", "received_at": "={{ $now.toISO() }}" } }
      }
    },
    {
      "name": "Needs Approval?",
      "type": "n8n-nodes-base.if",
      "parameters": { "conditions": { "boolean": [{ "value1": "={{ $json.needsApproval }}", "value2": true }] } }
    },
    {
      "name": "Slack AP Manager",
      "type": "n8n-nodes-base.slack",
      "parameters": {
        "channel": "#accounts-payable",
        "text": "*Invoice requires approval* \nVendor: {{ $json.vendor }}\nAmount: ${{ $json.amount }}\nDue: {{ $json.dueDate }}\nPO: {{ $json.poNumber }}\nLog: https://docs.google.com/spreadsheets/d/YOUR_SHEET_ID"
      }
    },
    {
      "name": "Auto-Approve Email",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "to": "ap@yourcompany.com",
        "subject": "Invoice auto-approved: {{ $json.vendor }} ${{ $json.amount }}",
        "message": "Invoice from {{ $json.vendor }} for ${{ $json.amount }} (due {{ $json.dueDate }}) has been auto-approved and logged. PO: {{ $json.poNumber }}"
      }
    }
  ]
}

{
  "name": "Monthly Finance Report",
  "nodes": [
    {
      "name": "Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": { "rule": { "interval": [{ "field": "cronExpression", "expression": "0 8 1 * *" }] } }
    },
    {
      "name": "Revenue Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": { "operation": "getAll", "sheetId": "YOUR_SHEET_ID", "range": "Revenue!A:C" }
    },
    {
      "name": "Expenses Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": { "operation": "getAll", "sheetId": "YOUR_SHEET_ID", "range": "Expenses!A:C" }
    },
    {
      "name": "Payroll Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": { "operation": "getAll", "sheetId": "YOUR_SHEET_ID", "range": "Payroll!A:C" }
    },
    {
      "name": "Consolidate",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const items = $input.all();\nconst revenue = items.filter(i => i.json._sheet === 'Revenue').reduce((s,r) => s + parseFloat(r.json.amount||0), 0);\nconst expenses = items.filter(i => i.json._sheet === 'Expenses').reduce((s,r) => s + parseFloat(r.json.amount||0), 0);\nconst payroll = items.filter(i => i.json._sheet === 'Payroll').reduce((s,r) => s + parseFloat(r.json.amount||0), 0);\nconst totalCosts = expenses + payroll;\nconst grossProfit = revenue - totalCosts;\nconst margin = revenue > 0 ? ((grossProfit/revenue)*100).toFixed(1) : 0;\nconst now = new Date(); const lastMonth = new Date(now.getFullYear(), now.getMonth()-1, 1);\nconst monthName = lastMonth.toLocaleString('default',{month:'long',year:'numeric'});\nconst html = `<h1>Monthly Financial Report — ${monthName}</h1><table border='1' cellpadding='10' style='border-collapse:collapse'><tr><th>Metric</th><th>Amount</th></tr><tr><td>Total Revenue</td><td>$${revenue.toLocaleString()}</td></tr><tr><td>Operating Expenses</td><td>$${expenses.toLocaleString()}</td></tr><tr><td>Payroll</td><td>$${payroll.toLocaleString()}</td></tr><tr><td>Total Costs</td><td>$${totalCosts.toLocaleString()}</td></tr><tr><td><b>Gross Profit</b></td><td><b>$${grossProfit.toLocaleString()}</b></td></tr><tr><td>Net Margin</td><td>${margin}%</td></tr></table>`;\nreturn [{ json: { html, monthName, revenue, totalCosts, grossProfit, margin } }];"
      }
    },
    {
      "name": "Email Finance Team",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "to": "cfo@yourcompany.com, ceo@yourcompany.com",
        "subject": "Monthly Financial Report — {{ $json.monthName }}",
        "message": "{{ $json.html }}",
        "options": { "bodyContentType": "html" }
      }
    }
  ]
}

{
  "name": "Expense Approval",
  "nodes": [
    {
      "name": "Expense Webhook",
      "type": "n8n-nodes-base.webhook",
      "parameters": { "path": "expense-submitted", "responseMode": "responseNode" }
    },
    {
      "name": "Parse Expense",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const b = $input.first().json.body;\nreturn [{ json: { submitter: b.employee_name, email: b.employee_email, amount: parseFloat(b.amount||0), category: b.category||'Other', description: b.description||'', receipts_url: b.receipts_url||'', submitted_at: new Date().toISOString(), needs_approval: parseFloat(b.amount||0) >= 500 } }];"
      }
    },
    {
      "name": "Under Threshold?",
      "type": "n8n-nodes-base.if",
      "parameters": { "conditions": { "boolean": [{ "value1": "={{ $json.needs_approval }}", "value2": false }] } }
    },
    {
      "name": "Auto-Approve",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "to": "={{ $json.email }}",
        "subject": "Expense approved: ${{ $json.amount }} — {{ $json.category }}",
        "message": "Hi {{ $json.submitter }},\n\nYour ${{ $json.amount }} expense ({{ $json.category }}) has been approved automatically. It will be included in the next reimbursement run.\n\n— Finance Team"
      }
    },
    {
      "name": "Slack Manager",
      "type": "n8n-nodes-base.slack",
      "parameters": {
        "channel": "@finance-manager",
        "text": "*Expense approval needed*\nEmployee: {{ $json.submitter }}\nAmount: ${{ $json.amount }}\nCategory: {{ $json.category }}\nDescription: {{ $json.description }}\nReceipts: {{ $json.receipts_url }}\nReply 'APPROVE {{ $json.email }}' or 'REJECT {{ $json.email }} [reason]'"
      }
    }
  ]
}

{
  "name": "Compliance Deadline Tracker",
  "nodes": [
    {
      "name": "Daily Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": { "rule": { "interval": [{ "field": "cronExpression", "expression": "0 8 * * 1-5" }] } }
    },
    {
      "name": "Get Compliance Calendar",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "getAll",
        "sheetId": "YOUR_COMPLIANCE_SHEET_ID",
        "range": "Deadlines!A:F"
      }
    },
    {
      "name": "Calculate Urgency",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const items = $input.all();\nconst today = new Date();\nreturn items\n  .filter(item => item.json.status !== 'completed')\n  .map(item => {\n    const due = new Date(item.json.due_date);\n    const daysLeft = Math.ceil((due - today) / (1000 * 60 * 60 * 24));\n    let urgency = 'NONE';\n    if (daysLeft < 0) urgency = 'OVERDUE';\n    else if (daysLeft <= 7) urgency = 'CRITICAL';\n    else if (daysLeft <= 14) urgency = 'URGENT';\n    else if (daysLeft <= 30) urgency = 'WARNING';\n    else if (daysLeft <= 60) urgency = 'NOTICE';\n    return { json: { ...item.json, daysLeft, urgency } };\n  })\n  .filter(item => item.json.urgency !== 'NONE');"
      }
    },
    {
      "name": "Route by Urgency",
      "type": "n8n-nodes-base.switch",
      "parameters": {
        "dataType": "string",
        "value1": "={{ $json.urgency }}",
        "rules": [
          { "value2": "OVERDUE", "output": 0 },
          { "value2": "CRITICAL", "output": 0 },
          { "value2": "URGENT", "output": 1 },
          { "value2": "WARNING", "output": 2 },
          { "value2": "NOTICE", "output": 2 }
        ]
      }
    },
    {
      "name": "Slack Compliance Channel",
      "type": "n8n-nodes-base.slack",
      "parameters": {
        "channel": "#compliance",
        "text": ":rotating_light: *{{ $json.urgency }}: {{ $json.deadline_name }}*\nDue: {{ $json.due_date }} ({{ $json.daysLeft }} days)\nOwner: {{ $json.owner }}\nRegulation: {{ $json.regulation }}\nAction required: {{ $json.action_required }}"
      }
    },
    {
      "name": "Email Owner — Urgent",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "to": "={{ $json.owner_email }}",
        "subject": "[URGENT] Compliance deadline in {{ $json.daysLeft }} days: {{ $json.deadline_name }}",
        "message": "Hi {{ $json.owner }},\n\n{{ $json.deadline_name }} is due in {{ $json.daysLeft }} days ({{ $json.due_date }}).\n\nRegulation: {{ $json.regulation }}\nAction required: {{ $json.action_required }}\n\nPlease confirm completion in the tracking sheet when done."
      }
    },
    {
      "name": "Email Owner — Notice",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "to": "={{ $json.owner_email }}",
        "subject": "Compliance reminder ({{ $json.daysLeft }} days): {{ $json.deadline_name }}",
        "message": "Hi {{ $json.owner }},\n\nReminder: {{ $json.deadline_name }} is due on {{ $json.due_date }} ({{ $json.daysLeft }} days from today).\n\nRegulation: {{ $json.regulation }}\nAction: {{ $json.action_required }}"
      }
    }
  ]
}