{
  "name": "Recover abandoned onboarding users with personalized emails via Postgres, Gmail & Slack",
  "nodes": [
    {
      "id": "235e1c65-4c7b-486c-8c82-1a8701a9cc5e",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -336,
        -80
      ]
    },
    {
      "id": "1eda6ee0-8f8a-466e-a5ca-90ce12ba5acb",
      "name": "Find Abandoned Users",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -112,
        -80
      ]
    },
    {
      "id": "0b77e61d-2f82-4fd7-962d-ee714ac7f981",
      "name": "Alert Sales Team",
      "type": "n8n-nodes-base.slack",
      "position": [
        1680,
        -80
      ]
    },
    {
      "id": "607c2651-d22a-4a82-b9d6-fbe16181a120",
      "name": "If",
      "type": "n8n-nodes-base.if",
      "position": [
        112,
        -80
      ]
    },
    {
      "id": "bcb6f17b-75c0-4298-9a69-272aa0ffda76",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        336,
        -80
      ]
    },
    {
      "id": "3c960e40-70de-446b-9a72-7763a3289c13",
      "name": "PrepareEmail email",
      "type": "@itechnotion/n8n-nodes-inboxplus.inboxPlus",
      "position": [
        560,
        -80
      ]
    },
    {
      "id": "18d25a98-ccc6-4138-8780-11f2bee671e2",
      "name": "Send a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        784,
        -80
      ]
    },
    {
      "id": "6f26a2b4-84b9-421b-b0c2-98694208f854",
      "name": "Get a message",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1008,
        -80
      ]
    },
    {
      "id": "210bd1ef-b47f-4c47-ac70-1b7290ab3d4c",
      "name": "StartSequence email",
      "type": "@itechnotion/n8n-nodes-inboxplus.inboxPlus",
      "position": [
        1232,
        -80
      ]
    },
    {
      "id": "48468632-7376-46c7-83e5-6324a4d3fa35",
      "name": "Update rows in a table",
      "type": "n8n-nodes-base.postgres",
      "position": [
        1456,
        -80
      ]
    },
    {
      "id": "b3ee6a42-c4a6-4b40-9831-eb2343cb1db3",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -912,
        -320
      ],
      "parameters": {
        "width": 512,
        "height": 560,
        "content": "## Automated User Recovery Email Workflow\nThis workflow identifies inactive users who abandoned onboarding, sends automated recovery emails, updates their status, and alerts the sales team—ideal for S"
      }
    },
    {
      "id": "ecc7088d-34af-47ab-95d9-efaf202a516b",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -384,
        -320
      ],
      "parameters": {
        "width": 640,
        "height": 560,
        "content": "## Step 1: Start the check and find inactive users\nThe workflow runs automatically on a schedule and queries your database to find users who abandoned onboarding and have been inactive for more than 2"
      }
    },
    {
      "id": "10a8ec77-68a4-4359-88db-696ea421ef4b",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        -320
      ],
      "parameters": {
        "width": 1104,
        "height": 560,
        "content": "## Step 2: Prepare users and generate recovery emails\nInactive users are validated and processed one by one. A personalized recovery email is prepared using a predefined template and sent via Gmail, w"
      }
    },
    {
      "id": "872f488d-a292-48f8-aca0-5d30a34d8c77",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1392,
        -320
      ],
      "parameters": {
        "width": 480,
        "height": 560,
        "content": "## Step 3: Update records and notify the sales team\nHere the user record is updated to prevent duplicate outreach, and a notification is posted to Slack for the sales team"
      }
    }
  ],
  "connections": {
    "If": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get a message": {
      "main": [
        [
          {
            "node": "StartSequence email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Send a message": {
      "main": [
        [
          {
            "node": "Get a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "PrepareEmail email",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Alert Sales Team": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Find Abandoned Users",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "PrepareEmail email": {
      "main": [
        [
          {
            "node": "Send a message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "StartSequence email": {
      "main": [
        [
          {
            "node": "Update rows in a table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Find Abandoned Users": {
      "main": [
        [
          {
            "node": "If",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Update rows in a table": {
      "main": [
        [
          {
            "node": "Alert Sales Team",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}