{
  "name": "Generate dynamic sales pipeline metrics for Slack using Airtable",
  "nodes": [
    {
      "id": "2488c731-3008-4f49-b7a6-e7ef45007927",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -496,
        -272
      ],
      "parameters": {
        "width": 448,
        "height": 672,
        "content": "## 📩 Weekly Slack Sales Report Automation\n\nSends a weekly pipeline summary to Slack with real sales metrics like open deals, top deal, win rate, weighted pipeline, and total revenue closed.\n\n👤 Who It’"
      }
    },
    {
      "id": "9cd0f108-3e28-4039-a8a3-b9bf37a28e53",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -16,
        -608
      ],
      "parameters": {
        "width": 624,
        "height": 304,
        "content": "Workflow Breakdown\n\t1.\tSearch Airtable for deals marked “Won”\n\t2.\tSearch Airtable again for all other open deals\n\t3.\tMerge results into one array\n\t4.\tSplit & summarize in Code Node 1: format Slack mes"
      }
    },
    {
      "id": "3d418639-c107-4ee7-b461-6a492f835c92",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        144,
        112
      ]
    },
    {
      "id": "6a5fed72-ce8f-41bf-9f26-be81c5011394",
      "name": "Search Open Deals",
      "type": "n8n-nodes-base.airtable",
      "position": [
        656,
        -80
      ]
    },
    {
      "id": "a52e60df-e378-40c0-be0a-c3512661b452",
      "name": "Search Won Deals",
      "type": "n8n-nodes-base.airtable",
      "position": [
        656,
        432
      ]
    },
    {
      "id": "49091bc3-1815-407f-bb1e-79a3c0413171",
      "name": "Merge Deals",
      "type": "n8n-nodes-base.merge",
      "position": [
        1088,
        112
      ]
    },
    {
      "id": "179a3e43-8f0e-4f93-ad58-8f5a8f8b07db",
      "name": "Slack Message Summary",
      "type": "n8n-nodes-base.code",
      "position": [
        1296,
        112
      ]
    },
    {
      "id": "7b1c11c7-43ea-4825-94f0-286c8e89a453",
      "name": "Advanced Metrics",
      "type": "n8n-nodes-base.code",
      "position": [
        1504,
        112
      ]
    },
    {
      "id": "a3740fd8-0e24-4581-a156-006ffe33b40b",
      "name": "Slack Message",
      "type": "n8n-nodes-base.slack",
      "position": [
        1904,
        112
      ]
    },
    {
      "id": "8349a72d-1430-42d3-adde-06a577cb9f3c",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        224
      ],
      "parameters": {
        "width": 416,
        "height": 416,
        "content": "## Search Open Deals\n[Read more about Airtable node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.airtable/)\n\nThis node fetches all remaining records in the pipeline that are stil"
      }
    },
    {
      "id": "9df9bf18-cc92-4711-b0a8-1b6c7bf94574",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        496,
        -272
      ],
      "parameters": {
        "width": 416,
        "height": 416,
        "content": "## Search Won Deals\n[Read more about the Airtable node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.airtable/)\n\nThis node queries the Airtable deal table for all records where St"
      }
    },
    {
      "id": "593619f0-bd06-436c-9203-096a6eef52b5",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1760,
        -80
      ],
      "parameters": {
        "width": 416,
        "height": 416,
        "content": "## Send Slack Message\n[Read more about the Slack node](https://docs.n8n.io/integrations/builtin/app-nodes/n8n-nodes-base.slack/)\n\nThis node takes the formatted message and posts it to the designated S"
      }
    },
    {
      "id": "0c21cce2-a383-424c-9018-9c04b37b3fd7",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        992,
        -80
      ],
      "parameters": {
        "width": 688,
        "height": 416,
        "content": "## Process & Format Metrics\n[Read more about the Code node](https://www.google.com/search?client=safari&rls=en&q=code+node+n8n&ie=UTF-8&oe=UTF-8)\n\n[Read more about the Merge node](https://docs.n8n.io/"
      }
    },
    {
      "id": "aebcfa3e-9587-403e-b4f7-0e9c7088fbc5",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        -80
      ],
      "parameters": {
        "width": 416,
        "height": 416,
        "content": "## Schedule Trigger\n[Read more about Calendly Credentials](https://docs.n8n.io/integrations/builtin/credentials/calendly/)\n\nTriggers the workflow on a recurring schedule. You can set it to run as ofte"
      }
    }
  ],
  "connections": {
    "Merge Deals": {
      "main": [
        [
          {
            "node": "Slack Message Summary",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Advanced Metrics": {
      "main": [
        [
          {
            "node": "Slack Message",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "Search Open Deals",
            "type": "main",
            "index": 0
          },
          {
            "node": "Search Won Deals",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Search Won Deals": {
      "main": [
        [
          {
            "node": "Merge Deals",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Search Open Deals": {
      "main": [
        [
          {
            "node": "Merge Deals",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Slack Message Summary": {
      "main": [
        [
          {
            "node": "Advanced Metrics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}