{
  "name": "Automated job applications & status tracking with LinkedIn, Indeed & Google Sheets",
  "nodes": [
    {
      "id": "template-overview",
      "name": "📋 Template Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        160
      ],
      "parameters": {
        "width": 389,
        "height": 464,
        "content": "## 🎯 Job Application Automation System\n\n**What it does:**\n- Reads job listings from Google Sheets\n- Automatically applies to jobs with personalized cover letters\n- Tracks application status every 2 da"
      }
    },
    {
      "id": "sheet-structure",
      "name": "📊 Sheet Structure",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        820,
        160
      ],
      "parameters": {
        "width": 295,
        "height": 284,
        "content": "## 📊 Excel Sheet Structure\n\nRequired columns:\n- Job_ID: Unique identifier\n- Company: Company name\n- Position: Job title\n- Status: Not Applied, Applied, etc.\n- Applied_Date: Application date\n- Last_Che"
      }
    },
    {
      "id": "setup-notes",
      "name": "⚙️ Setup Notes",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1180,
        160
      ],
      "parameters": {
        "width": 295,
        "height": 224,
        "content": "## 🔧 Configuration Setup\n\n1. Replace 'YOUR_GOOGLE_SHEET_ID' with actual ID\n2. Add your resume URL (Google Drive link)\n3. Customize cover letter template\n4. Update email addresses\n\n**Security Note:** N"
      }
    },
    {
      "id": "daily-trigger",
      "name": "🕘 Daily Application Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        240,
        480
      ]
    },
    {
      "id": "configuration",
      "name": "⚙️ Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        460,
        480
      ]
    },
    {
      "id": "read-jobs",
      "name": "📖 Read Jobs Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        680,
        480
      ]
    },
    {
      "id": "filter-pending",
      "name": "🎯 Filter Pending Applications",
      "type": "n8n-nodes-base.filter",
      "position": [
        900,
        480
      ]
    },
    {
      "id": "split-jobs",
      "name": "🔄 Process Jobs One by One",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        1120,
        480
      ]
    },
    {
      "id": "prepare-data",
      "name": "📝 Prepare Application Data",
      "type": "n8n-nodes-base.set",
      "position": [
        1340,
        480
      ]
    },
    {
      "id": "platform-router",
      "name": "🔀 Route by Platform",
      "type": "n8n-nodes-base.switch",
      "position": [
        1560,
        480
      ]
    },
    {
      "id": "linkedin-apply",
      "name": "💼 Apply via LinkedIn",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1780,
        380
      ]
    },
    {
      "id": "indeed-apply",
      "name": "🔍 Apply via Indeed",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1780,
        580
      ]
    },
    {
      "id": "process-result",
      "name": "📊 Process Application Result",
      "type": "n8n-nodes-base.set",
      "position": [
        2000,
        480
      ]
    },
    {
      "id": "update-status",
      "name": "📝 Update Job Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2220,
        480
      ]
    },
    {
      "id": "send-notification",
      "name": "📧 Send Application Notification",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2440,
        480
      ]
    },
    {
      "id": "status-tracking-info",
      "name": "📊 Status Tracking Info",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        380,
        740
      ],
      "parameters": {
        "width": 329,
        "height": 204,
        "content": "## 📈 Status Tracking Workflow\n\nThis section runs every 2 days to:\n- Check status of applied jobs\n- Update the spreadsheet\n- Send notifications for changes\n\n**Note:** Replace mock status checks with ac"
      }
    },
    {
      "id": "status-trigger",
      "name": "🕐 Status Check Trigger",
      "type": "n8n-nodes-base.cron",
      "position": [
        240,
        980
      ]
    },
    {
      "id": "read-applied",
      "name": "📖 Read Applied Jobs",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        460,
        980
      ]
    },
    {
      "id": "filter-applied",
      "name": "🎯 Filter Applied Jobs",
      "type": "n8n-nodes-base.filter",
      "position": [
        680,
        980
      ]
    },
    {
      "id": "split-status",
      "name": "🔄 Check Status One by One",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        900,
        980
      ]
    },
    {
      "id": "mock-status-check",
      "name": "🔍 Mock Status Check",
      "type": "n8n-nodes-base.set",
      "position": [
        1120,
        980
      ]
    },
    {
      "id": "status-changed",
      "name": "🔄 Check if Status Changed",
      "type": "n8n-nodes-base.if",
      "position": [
        1340,
        980
      ]
    },
    {
      "id": "update-changed",
      "name": "📝 Update Changed Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1560,
        980
      ]
    },
    {
      "id": "send-status-update",
      "name": "📧 Send Status Update",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1780,
        980
      ]
    }
  ],
  "connections": {
    "⚙️ Configuration": {
      "main": [
        [
          {
            "node": "📖 Read Jobs Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📖 Read Jobs Sheet": {
      "main": [
        [
          {
            "node": "🎯 Filter Pending Applications",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔍 Apply via Indeed": {
      "main": [
        [
          {
            "node": "📊 Process Application Result",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📖 Read Applied Jobs": {
      "main": [
        [
          {
            "node": "🎯 Filter Applied Jobs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📝 Update Job Status": {
      "main": [
        [
          {
            "node": "📧 Send Application Notification",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔀 Route by Platform": {
      "main": [
        [
          {
            "node": "💼 Apply via LinkedIn",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "🔍 Apply via Indeed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔍 Mock Status Check": {
      "main": [
        [
          {
            "node": "🔄 Check if Status Changed",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "💼 Apply via LinkedIn": {
      "main": [
        [
          {
            "node": "📊 Process Application Result",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🎯 Filter Applied Jobs": {
      "main": [
        [
          {
            "node": "🔄 Check Status One by One",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🕐 Status Check Trigger": {
      "main": [
        [
          {
            "node": "📖 Read Applied Jobs",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📝 Update Changed Status": {
      "main": [
        [
          {
            "node": "📧 Send Status Update",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔄 Check Status One by One": {
      "main": [
        [
          {
            "node": "🔍 Mock Status Check",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔄 Check if Status Changed": {
      "main": [
        [
          {
            "node": "📝 Update Changed Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🔄 Process Jobs One by One": {
      "main": [
        [
          {
            "node": "📝 Prepare Application Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📝 Prepare Application Data": {
      "main": [
        [
          {
            "node": "🔀 Route by Platform",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🕘 Daily Application Trigger": {
      "main": [
        [
          {
            "node": "⚙️ Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "📊 Process Application Result": {
      "main": [
        [
          {
            "node": "📝 Update Job Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "🎯 Filter Pending Applications": {
      "main": [
        [
          {
            "node": "🔄 Process Jobs One by One",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}