{
  "name": "Automate cross-border tax compliance with Google Sheets, PostgreSQL and Slack alerts",
  "nodes": [
    {
      "id": "09e9c76c-8ab4-4865-b931-c01688668516",
      "name": "Daily Tax Processing Schedule",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -2176,
        -368
      ]
    },
    {
      "id": "977fa1df-4321-478b-90cd-b2820d3f5e9d",
      "name": "Workflow Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        -1984,
        -368
      ]
    },
    {
      "id": "2b011ca6-adde-45fa-bc9f-8f785e4afea0",
      "name": "Fetch Revenue Transactions",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -1824,
        -272
      ]
    },
    {
      "id": "34061bae-7cca-4b2b-a6de-1c6c0ab9278d",
      "name": "Extract Transaction Data",
      "type": "n8n-nodes-base.set",
      "position": [
        -1440,
        -240
      ]
    },
    {
      "id": "c91ab5df-72e1-4fb6-adfc-75dc456a2473",
      "name": "Identify Tax Obligations by Country",
      "type": "n8n-nodes-base.code",
      "position": [
        -304,
        -384
      ]
    },
    {
      "id": "da718199-fbc6-42f4-a43e-bd8489e71376",
      "name": "Apply Tax Rules by Jurisdiction",
      "type": "n8n-nodes-base.code",
      "position": [
        -112,
        -448
      ]
    },
    {
      "id": "6409a001-aa9c-4eab-83a7-a4c34d2127e0",
      "name": "Group Transactions by Region",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        1024,
        -432
      ]
    },
    {
      "id": "5d9030b8-84c7-43f7-9038-9e3cb6712cd9",
      "name": "Generate Regional Tax Reports",
      "type": "n8n-nodes-base.code",
      "position": [
        1904,
        -352
      ]
    },
    {
      "id": "733756b4-ca27-428a-8c74-6c75b2291305",
      "name": "Send Reports to Tax Consultants",
      "type": "n8n-nodes-base.gmail",
      "position": [
        2128,
        -448
      ]
    },
    {
      "id": "7711cb47-fa6c-412a-99fc-128ecdee5ba9",
      "name": "Archive Evidence to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        2128,
        -256
      ]
    },
    {
      "id": "c920cebf-9abb-43d1-89c8-398a7188ee97",
      "name": "Filter Valid Transactions",
      "type": "n8n-nodes-base.filter",
      "position": [
        -1184,
        -320
      ]
    },
    {
      "id": "f07aaad8-8aab-4897-a104-ec32e0f4be62",
      "name": "Check High-Risk Transactions",
      "type": "n8n-nodes-base.if",
      "position": [
        336,
        -384
      ]
    },
    {
      "id": "3b125608-e1a5-4464-b7ff-274b1b72ce37",
      "name": "Store Transactions in Database",
      "type": "n8n-nodes-base.postgres",
      "position": [
        816,
        -368
      ]
    },
    {
      "id": "00c63a08-5846-4684-a486-90cbc0699c64",
      "name": "Retrieve Historical Tax Data",
      "type": "n8n-nodes-base.postgres",
      "position": [
        -448,
        -144
      ]
    },
    {
      "id": "54f4d737-d41e-4be9-b62a-239aac1f29e4",
      "name": "Calculate Compliance Metrics",
      "type": "n8n-nodes-base.summarize",
      "position": [
        1232,
        -336
      ]
    },
    {
      "id": "fd7bde9d-4e05-4fa3-971b-bd08508bb374",
      "name": "Alert Finance Team on High-Risk",
      "type": "n8n-nodes-base.slack",
      "position": [
        560,
        -304
      ]
    },
    {
      "id": "d1788286-b92b-4981-a370-49f454ee4822",
      "name": "Detect Anomalies and Fraud Patterns",
      "type": "n8n-nodes-base.code",
      "position": [
        112,
        -384
      ]
    },
    {
      "id": "a815e2b1-3ac1-4268-acbb-d61d29851eff",
      "name": "Fetch Exchange Rates",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -960,
        -320
      ]
    },
    {
      "id": "e73e573d-b0b3-43a9-8a5c-9c77584e3a2d",
      "name": "Normalize Currency to USD",
      "type": "n8n-nodes-base.code",
      "position": [
        -736,
        -320
      ]
    },
    {
      "id": "11e4a40a-6d15-4a1f-b3cb-7ee8e6865d2c",
      "name": "Merge Historical Trends",
      "type": "n8n-nodes-base.set",
      "position": [
        1456,
        -240
      ]
    },
    {
      "id": "7ddd9bec-de2d-4770-852b-ae6eda0e9e9a",
      "name": "Generate Predictive Tax Forecast",
      "type": "n8n-nodes-base.code",
      "position": [
        1680,
        -240
      ]
    },
    {
      "id": "f3b639a3-d748-404f-b942-8f9401907045",
      "name": "Validate VAT Numbers via VIES",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -512,
        -320
      ]
    },
    {
      "id": "8196da88-a552-4394-835e-ba99158373d1",
      "name": "Split Transactions for Processing",
      "type": "n8n-nodes-base.splitOut",
      "position": [
        -1632,
        -480
      ]
    },
    {
      "id": "f8c6825f-ccbe-426b-bb55-5a60fc50bf00",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -896,
        -912
      ],
      "parameters": {
        "width": 816,
        "height": 336,
        "content": "## Prerequisites\nAccounts and API credentials for Google Sheets, Gmail, Drive; access to transaction database; tax rule configuration.\n\n## Use Cases\nDaily financial reconciliation, automated tax calcu"
      }
    },
    {
      "id": "e152089d-64d8-4fab-b051-43522f9a1cf1",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1408,
        -912
      ],
      "parameters": {
        "width": 464,
        "height": 176,
        "content": "## Setup Steps\n1. Connect Google Sheets/SQL for transactions\n2. Configure tax rules in workflow\n3. Set Gmail/Drive for report delivery\n4. Activate schedule for daily execution"
      }
    },
    {
      "id": "317e61e1-d7e6-4209-8ebe-1be1ae0b9a09",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2208,
        -912
      ],
      "parameters": {
        "width": 752,
        "height": 272,
        "content": "## How It Works\nThis workflow automates the complete end-to-end processing of daily revenue transactions for finance and accounting teams. It systematically retrieves, validates, and standardizes tran"
      }
    },
    {
      "id": "6b040310-d72e-4bf6-a6bc-efea8baa789f",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        752,
        -528
      ],
      "parameters": {
        "width": 1600,
        "height": 576,
        "content": "## Generate & Send Reports\n**What:** Create compliance files and email to authorities\n**Why:** Automates reporting, reduces manual intervention\n"
      }
    },
    {
      "id": "139423aa-159c-490c-b6a3-416c39bfde2c",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -560,
        -528
      ],
      "parameters": {
        "width": 1296,
        "height": 576,
        "content": "## Apply Tax Rules & Detect Anomalies\n\n**What:** Compute taxes and flag irregularities\n**Why:** Ensures compliance and prevents errors"
      }
    },
    {
      "id": "4079bbdf-46a4-49fb-ae0b-c0e0fbc3e17f",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1248,
        -528
      ],
      "parameters": {
        "width": 672,
        "height": 576,
        "content": "## Validate & Normalize Data\n\n**What:** Filter invalid transactions and standardize formats\n**Why:** Maintains data integrity and consistency"
      }
    },
    {
      "id": "23a88ce8-7d02-4040-9484-f04bf0fcf316",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2208,
        -528
      ],
      "parameters": {
        "width": 944,
        "height": 576,
        "content": "## Fetch & Prepare Transactions\n\n**What:** Collect daily revenue data from multiple sources\n**Why:** Ensures all transactions are centralized for processing"
      }
    }
  ],
  "connections": {
    "Fetch Exchange Rates": {
      "main": [
        [
          {
            "node": "Normalize Currency to USD",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Configuration": {
      "main": [
        [
          {
            "node": "Fetch Revenue Transactions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Retrieve Historical Tax Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Historical Trends": {
      "main": [
        [
          {
            "node": "Generate Predictive Tax Forecast",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Extract Transaction Data": {
      "main": [
        [
          {
            "node": "Identify Tax Obligations by Country",
            "type": "main",
            "index": 0
          },
          {
            "node": "Filter Valid Transactions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Filter Valid Transactions": {
      "main": [
        [
          {
            "node": "Fetch Exchange Rates",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Currency to USD": {
      "main": [
        [
          {
            "node": "Validate VAT Numbers via VIES",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Fetch Revenue Transactions": {
      "main": [
        [
          {
            "node": "Extract Transaction Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "Split Transactions for Processing",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Compliance Metrics": {
      "main": [
        [
          {
            "node": "Merge Historical Trends",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check High-Risk Transactions": {
      "main": [
        [
          {
            "node": "Alert Finance Team on High-Risk",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Store Transactions in Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Group Transactions by Region": {
      "main": [
        [
          {
            "node": "Generate Regional Tax Reports",
            "type": "main",
            "index": 0
          },
          {
            "node": "Calculate Compliance Metrics",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Retrieve Historical Tax Data": {
      "main": [
        [
          {
            "node": "Merge Historical Trends",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Daily Tax Processing Schedule": {
      "main": [
        [
          {
            "node": "Workflow Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Regional Tax Reports": {
      "main": [
        [
          {
            "node": "Send Reports to Tax Consultants",
            "type": "main",
            "index": 0
          },
          {
            "node": "Archive Evidence to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Validate VAT Numbers via VIES": {
      "main": [
        [
          {
            "node": "Identify Tax Obligations by Country",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Store Transactions in Database": {
      "main": [
        [
          {
            "node": "Group Transactions by Region",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Alert Finance Team on High-Risk": {
      "main": [
        [
          {
            "node": "Store Transactions in Database",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Apply Tax Rules by Jurisdiction": {
      "main": [
        [
          {
            "node": "Group Transactions by Region",
            "type": "main",
            "index": 0
          },
          {
            "node": "Detect Anomalies and Fraud Patterns",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Generate Predictive Tax Forecast": {
      "main": [
        [
          {
            "node": "Generate Regional Tax Reports",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split Transactions for Processing": {
      "main": [
        [
          {
            "node": "Extract Transaction Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Detect Anomalies and Fraud Patterns": {
      "main": [
        [
          {
            "node": "Check High-Risk Transactions",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Identify Tax Obligations by Country": {
      "main": [
        [
          {
            "node": "Apply Tax Rules by Jurisdiction",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}