{
  "name": "Automate offer letters & notifications with Google Sheets, Gmail & Slack",
  "nodes": [
    {
      "id": "7eefa653-1d50-48d2-9f3f-48323a0a1f1c",
      "name": "Google Sheets Trigger",
      "type": "n8n-nodes-base.googleSheetsTrigger",
      "position": [
        -16,
        112
      ]
    },
    {
      "id": "6f075f9c-d612-4794-84c7-ed77dcdc2aa8",
      "name": "Get PDF",
      "type": "n8n-nodes-base.extractFromFile",
      "position": [
        880,
        352
      ]
    },
    {
      "id": "f9b95280-3d09-47bc-aaaa-f37f00c7c9d7",
      "name": "PDF Generate",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        704,
        352
      ]
    },
    {
      "id": "5e209a30-88c2-4515-80c1-8a8780e9f7de",
      "name": "Download PDF",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1056,
        352
      ]
    },
    {
      "id": "7d52b706-7c66-41f1-8634-8659701d6f96",
      "name": "Send a message to Manager",
      "type": "n8n-nodes-base.slack",
      "position": [
        1360,
        400
      ]
    },
    {
      "id": "6717be07-c307-4b3b-bcbb-8003848c0960",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -64,
        -96
      ],
      "parameters": {
        "width": 416,
        "height": 112,
        "content": "## Sample Sheet\nhttps://docs.google.com/spreadsheets/d/15emSCM6Ui3O7oH2BXcorZJUi2BbWpZKCTcqq-Iyn0Kk/edit?gid=0#gid=0"
      }
    },
    {
      "id": "5b7bc055-daf7-4061-a709-5b99b148efef",
      "name": "Check Document Status(If Document Status is Pending)",
      "type": "n8n-nodes-base.if",
      "position": [
        208,
        112
      ]
    },
    {
      "id": "95d22c3f-5567-4920-bf4a-7461a1e6efa2",
      "name": "Create Offer Letter",
      "type": "n8n-nodes-base.code",
      "position": [
        528,
        352
      ]
    },
    {
      "id": "833faaf8-29d5-499d-967a-5e62339522c4",
      "name": "Send Missing Document Email",
      "type": "n8n-nodes-base.gmail",
      "position": [
        544,
        -32
      ]
    },
    {
      "id": "a1e8ac99-2612-46db-9652-ea91675bf6f8",
      "name": "Change Status",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        752,
        -32
      ]
    },
    {
      "id": "d7ada8e5-dd28-4b51-bbb0-0094a20a896b",
      "name": "Upload Offer Letter",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1360,
        16
      ]
    },
    {
      "id": "769c9fcc-d4b9-470c-9d0b-0b784ecf471b",
      "name": "Add Offer Letter in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1568,
        16
      ]
    },
    {
      "id": "55338c56-fce3-4857-ae43-f183fcd54190",
      "name": "Send Offer Letter To Candidate",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1360,
        208
      ]
    },
    {
      "id": "c18319e0-5d4d-4a47-8409-15f9bc0c58ba",
      "name": "Change Status in Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1568,
        400
      ]
    },
    {
      "id": "9a267438-fbbd-4413-8ba6-f9d96ade7956",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        -96
      ],
      "parameters": {
        "width": 420,
        "height": 532,
        "content": "## How it works\nThis workflow automates candidate onboarding by monitoring a Google Sheet for new entries. When a candidate's document status is updated:\n\n- **Documents Pending**: Sends a reminder ema"
      }
    },
    {
      "id": "5e6b12e8-7b5f-4bd3-b954-3ce98a90c388",
      "name": "Document Verification",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        448,
        -128
      ],
      "parameters": {
        "width": 748,
        "height": 292,
        "content": "## Send missing documents Email\n"
      }
    },
    {
      "id": "7e5baf0b-4a92-4371-849d-be4456314a95",
      "name": "Offer Letter Generation",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        448,
        176
      ],
      "parameters": {
        "width": 756,
        "height": 356,
        "content": "## Offer Letter Generation\nCreates HTML offer letter from candidate data, converts to PDF via ConvertAPI, and downloads the final document."
      }
    },
    {
      "id": "2792c913-e716-4c98-b383-d780dcc269e1",
      "name": "Distribution & Notifications",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        -128
      ],
      "parameters": {
        "width": 556,
        "height": 724,
        "content": "## Distribution & Notifications\nUploads offer letter to Google Drive, emails candidate with PDF attachment, notifies manager via Slack, and updates sheet with final status."
      }
    }
  ],
  "connections": {
    "Get PDF": {
      "main": [
        [
          {
            "node": "Download PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Download PDF": {
      "main": [
        [
          {
            "node": "Upload Offer Letter",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send Offer Letter To Candidate",
            "type": "main",
            "index": 0
          },
          {
            "node": "Send a message to Manager",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "PDF Generate": {
      "main": [
        [
          {
            "node": "Get PDF",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Offer Letter": {
      "main": [
        [
          {
            "node": "PDF Generate",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Upload Offer Letter": {
      "main": [
        [
          {
            "node": "Add Offer Letter in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets Trigger": {
      "main": [
        [
          {
            "node": "Check Document Status(If Document Status is Pending)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message to Manager": {
      "main": [
        [
          {
            "node": "Change Status in Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send Missing Document Email": {
      "main": [
        [
          {
            "node": "Change Status",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Document Status(If Document Status is Pending)": {
      "main": [
        [
          {
            "node": "Send Missing Document Email",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Create Offer Letter",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}