{
  "name": "Forecast and report multi-channel tax liabilities with OpenAI, Gmail, Sheets and Airtable",
  "nodes": [
    {
      "id": "b97ae7d0-92db-4081-ae2d-451f2197ede7",
      "name": "Monthly Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -928,
        192
      ]
    },
    {
      "id": "b5040bf9-e5e5-401f-8c15-db79c9cdf6b9",
      "name": "Workflow Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        -704,
        192
      ]
    },
    {
      "id": "f572bf39-d656-45a8-81f1-0b5ecec52427",
      "name": "Aggregate Multi-Channel Revenue",
      "type": "n8n-nodes-base.code",
      "position": [
        -480,
        96
      ]
    },
    {
      "id": "92d6de1d-d2da-4576-9f24-3b70cb2c86ef",
      "name": "Calculate Tax Liabilities",
      "type": "n8n-nodes-base.code",
      "position": [
        1328,
        368
      ]
    },
    {
      "id": "79262d31-382d-4ff3-b1a0-cd7919969ede",
      "name": "Generate Rolling Forecast",
      "type": "n8n-nodes-base.code",
      "position": [
        1552,
        368
      ]
    },
    {
      "id": "51cde6e7-0e08-46be-845d-3abd487de36e",
      "name": "Format Report Data",
      "type": "n8n-nodes-base.set",
      "position": [
        2000,
        336
      ]
    },
    {
      "id": "cba2aef7-a63f-424b-b0ff-148627581f28",
      "name": "Send Report to Tax Agent",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2224,
        48
      ]
    },
    {
      "id": "e78c4f22-7635-492b-84c8-6fcea07b827e",
      "name": "Store in Google Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2224,
        240
      ]
    },
    {
      "id": "aa9c2324-aad7-41ab-a047-dbc53baaf70f",
      "name": "Store in Airtable",
      "type": "n8n-nodes-base.airtable",
      "position": [
        2224,
        432
      ]
    },
    {
      "id": "569bb1f7-1cf6-4e9e-abf5-372a0cf4fff3",
      "name": "Fetch Historical Revenue Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -480,
        304
      ]
    },
    {
      "id": "c13d854c-fe24-401b-8cb0-e218b5aabb67",
      "name": "Merge Historical and Current Data",
      "type": "n8n-nodes-base.merge",
      "position": [
        -240,
        256
      ]
    },
    {
      "id": "adcf3e72-051e-4d6d-8483-b309f8605c8a",
      "name": "Calculate Revenue Statistics",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -16,
        256
      ]
    },
    {
      "id": "1d8a4e95-1a5b-4a38-8782-0f18ba38e2f2",
      "name": "Check Tax Threshold",
      "type": "n8n-nodes-base.if",
      "position": [
        432,
        256
      ]
    },
    {
      "id": "a2ceff9e-a895-4509-aeae-4468bd13eb28",
      "name": "Route by Revenue Tier",
      "type": "n8n-nodes-base.switch",
      "position": [
        656,
        112
      ]
    },
    {
      "id": "fd83e5bd-cb64-4562-a8df-c8e85769a759",
      "name": "Calculate Tax Deductions",
      "type": "n8n-nodes-base.code",
      "position": [
        880,
        0
      ]
    },
    {
      "id": "c6d84e71-615d-44d9-bc6c-7575d0898d5a",
      "name": "Apply Progressive Tax Brackets",
      "type": "n8n-nodes-base.code",
      "position": [
        880,
        192
      ]
    },
    {
      "id": "9fd6ce70-63eb-42e6-92a5-94612d8ad044",
      "name": "Detect Anomalies",
      "type": "n8n-nodes-base.code",
      "position": [
        208,
        256
      ]
    },
    {
      "id": "853c325f-cfdb-4a3c-9eb7-d1b0f04da49a",
      "name": "Format Alert Data",
      "type": "n8n-nodes-base.set",
      "position": [
        656,
        384
      ]
    },
    {
      "id": "83ac3974-86c0-49b1-b31f-c236efa8bfe0",
      "name": "Send Anomaly Alert",
      "type": "n8n-nodes-base.gmail",
      "position": [
        880,
        384
      ]
    },
    {
      "id": "62b16b45-2484-46bb-aa29-bd812e2c7856",
      "name": "Combine Tax Calculations",
      "type": "n8n-nodes-base.merge",
      "position": [
        1104,
        128
      ]
    },
    {
      "id": "ef282ea0-3880-4724-8dd9-b8a92827f39f",
      "name": "Generate Scenario Analysis",
      "type": "n8n-nodes-base.code",
      "position": [
        1776,
        432
      ]
    },
    {
      "id": "26b2a0b4-1801-4a62-85f4-7fced38b8411",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        -528
      ],
      "parameters": {
        "width": 480,
        "height": 352,
        "content": "\n## Prerequisites\nActive e-commerce platform accounts with API access. Payment processor credentials.\n## Use Cases\nAutomated monthly sales tax calculations for multi-state e-commerce. \n## Customizatio"
      }
    },
    {
      "id": "707ec656-deb9-4ab2-94ea-8ac0f0e3b646",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        96,
        -496
      ],
      "parameters": {
        "width": 384,
        "height": 336,
        "content": "## Setup Steps\n1. Configure e-commerce API credentials for transaction access\n2. Set up payment processor integrations (Stripe, PayPal) for revenue reconciliation\n3. Add accounting system credentials "
      }
    },
    {
      "id": "0617d844-ff60-4cb3-a747-699283982373",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -832,
        -448
      ],
      "parameters": {
        "width": 896,
        "height": 288,
        "content": "## How It Works\nThis workflow automates tax compliance by aggregating multi-channel revenue data, calculating jurisdiction-specific tax obligations, detecting anomalies, and generating submission-read"
      }
    },
    {
      "id": "b75db707-2e79-4488-8015-e16ca07452dc",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        176,
        -112
      ],
      "parameters": {
        "width": 1296,
        "height": 864,
        "content": "## AI Anomaly Detection  & Alert\nAnalyzes calculated tax obligations using AI models to identify unusual patterns, deduction anomalies, and potential audit triggers.\n**Why** - Catches calculation erro"
      }
    },
    {
      "id": "94d69234-5e2c-443f-b077-25dacf74df9e",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -304,
        -112
      ],
      "parameters": {
        "width": 464,
        "height": 896,
        "content": "## Tax Calculation Engine \nRoutes transactions by jurisdiction, applies tax rates, calculates obligations, and handles progressive brackets using rule-based logic.\n**Why** - Automates complex tax calc"
      }
    },
    {
      "id": "2d2cd2c4-197b-4267-9ab5-77e6f2f7ecc5",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -976,
        -112
      ],
      "parameters": {
        "width": 656,
        "height": 864,
        "content": "## Revenue Aggregation \nFetches transaction data from multiple e-commerce platforms, payment gateways, and accounting systems via scheduled triggers.\n**Why** - Consolidates fragmented revenue streams "
      }
    },
    {
      "id": "66116014-1018-4d0f-98de-76128be4dcb0",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1504,
        -128
      ],
      "parameters": {
        "width": 960,
        "height": 1024,
        "content": "\n## Report Generation \nFormats tax data into authority-specific submission templates, generates supporting documentation, and creates audit-ready reports.\n**Why** - Produces compliant filings matching"
      }
    }
  ],
  "connections": {
    "Detect Anomalies": {
      "main": [
        [
          {
            "node": "Check Tax Threshold",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monthly Schedule": {
      "main": [
        [
          {
            "node": "Workflow Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Alert Data": {
      "main": [
        [
          {
            "node": "Send Anomaly Alert",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format Report Data": {
      "main": [
        [
          {
            "node": "Send Report to Tax Agent",
            "type": "main",
            "index": 0
          },
          {
            "node": "Store in Google Sheets",
            "type": "main",
            "index": 0
          },
          {
            "node": "Store in Airtable",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Tax Threshold": {
      "main": [
        [
          {
            "node": "Format Alert Data",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Route by Revenue Tier",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Route by Revenue Tier": {
      "main": [
        [
          {
            "node": "Calculate Tax Deductions",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Apply Progressive Tax Brackets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Configuration": {
      "main": [
        [
          {
            "node": "Aggregate Multi-Channel Revenue",
            "type": "main",
            "index": 0
          },
          {
            "node": "Fetch Historical Revenue Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Tax Deductions": {
      "main": [
        [
          {
            "node": "Combine Tax Calculations",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Combine Tax Calculations": {
      "main": [
        [
          {
            "node": "Calculate Tax Liabilities",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Tax Liabilities": {
      "main": [
        [
          {
            "node": "Generate Rolling Forecast",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Rolling Forecast": {
      "main": [
        [
          {
            "node": "Format Report Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "Generate Scenario Analysis",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Scenario Analysis": {
      "main": [
        [
          {
            "node": "Format Report Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Revenue Statistics": {
      "main": [
        [
          {
            "node": "Detect Anomalies",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Historical Revenue Data": {
      "main": [
        [
          {
            "node": "Merge Historical and Current Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apply Progressive Tax Brackets": {
      "main": [
        [
          {
            "node": "Combine Tax Calculations",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Aggregate Multi-Channel Revenue": {
      "main": [
        [
          {
            "node": "Calculate Tax Liabilities",
            "type": "main",
            "index": 0
          },
          {
            "node": "Merge Historical and Current Data",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Merge Historical and Current Data": {
      "main": [
        [
          {
            "node": "Calculate Revenue Statistics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}