n8n for Project Managers: 5 Automations That Keep Every Project on Track (Free Workflow JSON)

{
  "name": "Weekly Project Status Report",
  "nodes": [
    {
      "id": "1",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": {
        "rule": { "interval": [{ "field": "weeks", "weeksInterval": 1 }] },
        "triggerAtDay": [5],
        "triggerAtHour": 16
      }
    },
    {
      "id": "2",
      "name": "Read Project Tasks",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "read",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "Tasks",
        "range": "A1:F200"
      }
    },
    {
      "id": "3",
      "name": "Build Report",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const tasks = $input.all().map(t => t.json);\nconst total = tasks.length;\nconst done = tasks.filter(t => t.Status === 'Done').length;\nconst overdue = tasks.filter(t => t.Status !== 'Done' && new Date(t.DueDate) < new Date()).length;\nconst pct = Math.round(done / total * 100);\nconst html = `<h2>Weekly Status Report</h2><p><b>Overall:</b> ${pct}% complete (${done}/${total} tasks)</p><p><b>Overdue:</b> ${overdue} task(s)</p>`;\nreturn [{ json: { html, subject: `Project Status — ${new Date().toDateString()}` } }];"
      }
    },
    {
      "id": "4",
      "name": "Email Stakeholders",
      "type": "n8n-nodes-base.gmail",
      "parameters": {
        "operation": "send",
        "toList": "stakeholder1@company.com,stakeholder2@company.com",
        "subject": "={{ $json.subject }}",
        "emailType": "html",
        "message": "={{ $json.html }}"
      }
    }
  ],
  "connections": {
    "Schedule Trigger": { "main": [[{ "node": "Read Project Tasks" }]] },
    "Read Project Tasks": { "main": [[{ "node": "Build Report" }]] },
    "Build Report": { "main": [[{ "node": "Email Stakeholders" }]] }
  }
}

{
  "name": "Overdue Task Alert",
  "nodes": [
    {
      "id": "1",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": {
        "rule": { "interval": [{ "field": "hours", "hoursInterval": 24 }] },
        "triggerAtHour": 9
      }
    },
    {
      "id": "2",
      "name": "Read Tasks",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "read",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "Tasks",
        "range": "A1:E200"
      }
    },
    {
      "id": "3",
      "name": "Filter Overdue",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const today = new Date();\nconst overdue = $input.all()\n  .map(t => t.json)\n  .filter(t => t.Status !== 'Done' && new Date(t.DueDate) < today);\nif (overdue.length === 0) return [];\nconst lines = overdue.map(t => `• *${t.Task}* — Owner: ${t.Owner}, Due: ${t.DueDate}`).join('\\n');\nreturn [{ json: { text: `*${overdue.length} overdue task(s):*\\n${lines}`, count: overdue.length } }];"
      }
    },
    {
      "id": "4",
      "name": "IF Has Overdue",
      "type": "n8n-nodes-base.if",
      "parameters": {
        "conditions": { "number": [{ "value1": "={{ $json.count }}", "operation": "larger", "value2": 0 }] }
      }
    },
    {
      "id": "5",
      "name": "Slack Alert",
      "type": "n8n-nodes-base.slack",
      "parameters": {
        "operation": "post",
        "channel": "#project-updates",
        "text": "={{ $json.text }}"
      }
    }
  ],
  "connections": {
    "Schedule Trigger": { "main": [[{ "node": "Read Tasks" }]] },
    "Read Tasks": { "main": [[{ "node": "Filter Overdue" }]] },
    "Filter Overdue": { "main": [[{ "node": "IF Has Overdue" }]] },
    "IF Has Overdue": { "main": [[{ "node": "Slack Alert" }]] }
  }
}

{
  "name": "Budget Alert",
  "nodes": [
    {
      "id": "1",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "parameters": {
        "rule": { "interval": [{ "field": "hours", "hoursInterval": 1 }] }
      }
    },
    {
      "id": "2",
      "name": "Read Budget Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "parameters": {
        "operation": "read",
        "documentId": "YOUR_SHEET_ID",
        "sheetName": "Budget",
        "range": "A1:C50"
      }
    },
    {
      "id": "3",
      "name": "Check Budget",
      "type": "n8n-nodes-base.code",
      "parameters": {
        "jsCode": "const rows = $input.all().map(r => r.json);\nconst alerts = rows\n  .filter(r => r.Budget > 0)\n  .map(r => ({ ...r, pct: Math.round(r.Spent / r.Budget * 100) }))\n  .filter(r => r.pct >= 80);\nreturn alerts.map(r => ({ json: r }));"
      }
    },
    {
      "id": "4",
      "name": "IF Critical",
      "type": "n8n-nodes-base.if",
      "parameters": {
        "conditions": { "number": [{ "value1": "={{ $json.pct }}", "operation": "largerEqual", "value2": 100 }] }
      }
    },
    {
      "id": "5",
      "name": "Slack PM Alert",
      "type": "n8n-nodes-base.slack",
      "parameters": {
        "operation": "post",
        "channel": "#project-finance",
        "text": "={{ `Budget alert: ${$json.Project} is at ${$json.pct}% ($${$json.Spent} of $${$json.Budget})` }}"
      }
    }
  ],
  "connections": {
    "Schedule Trigger": { "main": [[{ "node": "Read Budget Sheet" }]] },
    "Read Budget Sheet": { "main": [[{ "node": "Check Budget" }]] },
    "Check Budget": { "main": [[{ "node": "IF Critical" }]] },
    "IF Critical": { "main": [[{ "node": "Slack PM Alert" }]] }
  }
}