{
  "name": "Consolidate Stripe, PayPal, Shopify and bank revenue and prepare tax filings with OpenAI",
  "nodes": [
    {
      "id": "827cbd50-730e-4ddf-93dc-fa68d0724ff9",
      "name": "Workflow Configuration",
      "type": "n8n-nodes-base.set",
      "position": [
        -224,
        288
      ]
    },
    {
      "id": "74d8059b-52fe-4b35-bc6a-c89a90803868",
      "name": "Get Stripe Transactions",
      "type": "n8n-nodes-base.stripe",
      "position": [
        0,
        80
      ]
    },
    {
      "id": "48dce256-d478-4814-a1c3-48b0087f57e9",
      "name": "Get PayPal Transactions",
      "type": "n8n-nodes-base.payPal",
      "position": [
        0,
        272
      ]
    },
    {
      "id": "475587a0-60f5-45c5-b7dc-e8c5c28d613d",
      "name": "Get Shopify Orders",
      "type": "n8n-nodes-base.shopify",
      "position": [
        0,
        464
      ]
    },
    {
      "id": "ba27bdb1-ee18-4fd0-878b-8d19a0fc9db6",
      "name": "Get Bank Feed Data",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        0,
        656
      ]
    },
    {
      "id": "627e15cc-7a89-4d09-9f13-bfc21360c1ca",
      "name": "Normalize Stripe Data",
      "type": "n8n-nodes-base.set",
      "position": [
        208,
        112
      ]
    },
    {
      "id": "69974097-d415-4b94-93bb-2ffa7796026e",
      "name": "Normalize PayPal Data",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        272
      ]
    },
    {
      "id": "7a796a3c-a049-48e7-b7b9-ce5cab1a9dd3",
      "name": "Normalize Shopify Data",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        464
      ]
    },
    {
      "id": "9e2c41c2-5690-4081-8594-8832a3f4eef1",
      "name": "Normalize Bank Data",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        656
      ]
    },
    {
      "id": "2a4f11e4-4d51-4c71-baf6-ff241c193e3d",
      "name": "Merge All Revenue Sources",
      "type": "n8n-nodes-base.aggregate",
      "position": [
        448,
        288
      ]
    },
    {
      "id": "833c661f-0aff-4be4-834a-108c40f92725",
      "name": "AI Income Categorizer",
      "type": "@n8n/n8n-nodes-langchain.agent",
      "position": [
        672,
        288
      ]
    },
    {
      "id": "9497a3e4-6beb-4aff-9032-a765685fc98a",
      "name": "OpenAI Model",
      "type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
      "position": [
        688,
        512
      ]
    },
    {
      "id": "07444727-4739-44ed-8312-b47e24da62d9",
      "name": "Structured Output Parser",
      "type": "@n8n/n8n-nodes-langchain.outputParserStructured",
      "position": [
        816,
        512
      ]
    },
    {
      "id": "d531269c-0591-4ba6-af34-e68613c12329",
      "name": "Calculate Period Totals",
      "type": "n8n-nodes-base.code",
      "position": [
        1024,
        288
      ]
    },
    {
      "id": "d739f8aa-6436-4d5d-9b54-b33c39eb5b4e",
      "name": "Format as CSV",
      "type": "n8n-nodes-base.code",
      "position": [
        1248,
        192
      ]
    },
    {
      "id": "d22f7d8e-0094-4dfb-b29e-c2d28da87040",
      "name": "Format as XML",
      "type": "n8n-nodes-base.code",
      "position": [
        1696,
        480
      ]
    },
    {
      "id": "62bba3e6-8d63-4684-a961-d6b783aea349",
      "name": "Check Submission Method",
      "type": "n8n-nodes-base.if",
      "position": [
        1472,
        192
      ]
    },
    {
      "id": "35e46f44-2e36-4fb6-927d-c4981615836b",
      "name": "Submit to Government API",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1696,
        96
      ]
    },
    {
      "id": "46772d2d-fb8f-47bb-8943-ef32f2bed8ab",
      "name": "Email to Tax Agent",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1696,
        288
      ]
    },
    {
      "id": "82060b39-886f-4e46-96ad-5f837116f1eb",
      "name": "Archive to Google Drive",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        1920,
        288
      ]
    },
    {
      "id": "43b5a026-1918-4f2b-a76c-3271ba1fd3d4",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1136,
        -288
      ],
      "parameters": {
        "width": 400,
        "height": 208,
        "content": "## Customization\nModify normalization rules per jurisdiction; add expense categories to AI prompt;  \n\n## Benefits\nEliminates manual reconciliation; reduces tax filing time by 80%; improves accuracy; "
      }
    },
    {
      "id": "25215ef2-8cb0-41e3-8f17-706714474149",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        672,
        -288
      ],
      "parameters": {
        "width": 416,
        "height": 208,
        "content": "## Prerequisites\nStripe, PayPal, Shopify, or bank APIs; OpenAI account; Google Workspace;  \n\n## Use Cases\nQuarterly tax preparation for e-commerce; multi-channel revenue reconciliation; "
      }
    },
    {
      "id": "219f5590-aeb3-44ac-b607-0ff38da38c07",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        272,
        -288
      ],
      "parameters": {
        "width": 320,
        "height": 208,
        "content": "## Setup Steps\n1. Connect Stripe/PayPal/Shopify accounts with API keys to respective nodes.\n2. Configure bank feed authentication \n3. Set OpenAI credentials for AI Income Categorizer node.\n4. Link Goo"
      }
    },
    {
      "id": "fc759cae-6766-43e5-b517-e03f9bffb698",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        -288
      ],
      "parameters": {
        "width": 752,
        "height": 192,
        "content": "## How It Works\nConsolidates daily revenue from Stripe, PayPal, Shopify, and bank feeds into a single system. The workflow automatically normalizes data across payment sources, uses AI to categorize i"
      }
    },
    {
      "id": "89107252-fe33-4736-aa8f-f364ec4a1f86",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        656,
        -32
      ],
      "parameters": {
        "width": 304,
        "height": 880,
        "content": "## AI-Powered Income Categorization\n**What:** Use all normalized streams and categorizes income using AI-powered transaction analysis.\n**Why:** Automates income classification and detects anomalies "
      }
    },
    {
      "id": "bc7e0768-29f3-4c48-930d-f68f583ba464",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        976,
        -32
      ],
      "parameters": {
        "width": 1104,
        "height": 864,
        "content": "## Tax Period Calculation and submission\n**What:** Computes period totals and tax period summaries with validation checks.\n**Why:** Ensures accuracy and compliance-ready figures for regulatory submiss"
      }
    },
    {
      "id": "666e7b09-aefd-4026-a92b-3fd11ce34648",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        144,
        -32
      ],
      "parameters": {
        "width": 496,
        "height": 864,
        "content": "\n## Data Normalization\n**What:** Applies format-standardization and transformation rules to each data source independently.\n**Why:** Creates consistent data structure  "
      }
    },
    {
      "id": "7ea72134-db7a-490c-9bad-91f93cdebb1e",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        -32
      ],
      "parameters": {
        "width": 640,
        "height": 848,
        "content": "## Multi-Source Data Collection\n**What:** Retrieves raw transaction data from four distinct payment sources  \n**Why:** Ensures complete revenue visibility across all channels."
      }
    },
    {
      "id": "a6403c5a-d2fa-45ba-9e73-96d5ee5374fe",
      "name": "Monthly revenue aggregation",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -448,
        288
      ]
    }
  ],
  "connections": {
    "OpenAI Model": {
      "ai_languageModel": [
        [
          {
            "node": "AI Income Categorizer",
            "type": "ai_languageModel",
            "index": 0
          }
        ]
      ]
    },
    "Format as CSV": {
      "main": [
        [
          {
            "node": "Check Submission Method",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Format as XML": {
      "main": [
        [
          {
            "node": "Archive to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Email to Tax Agent": {
      "main": [
        [
          {
            "node": "Archive to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Bank Feed Data": {
      "main": [
        [
          {
            "node": "Normalize Bank Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Shopify Orders": {
      "main": [
        [
          {
            "node": "Normalize Shopify Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Bank Data": {
      "main": [
        [
          {
            "node": "Merge All Revenue Sources",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "AI Income Categorizer": {
      "main": [
        [
          {
            "node": "Calculate Period Totals",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize PayPal Data": {
      "main": [
        [
          {
            "node": "Merge All Revenue Sources",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Stripe Data": {
      "main": [
        [
          {
            "node": "Merge All Revenue Sources",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Normalize Shopify Data": {
      "main": [
        [
          {
            "node": "Merge All Revenue Sources",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Workflow Configuration": {
      "main": [
        [
          {
            "node": "Get Stripe Transactions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get PayPal Transactions",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Shopify Orders",
            "type": "main",
            "index": 0
          },
          {
            "node": "Get Bank Feed Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Calculate Period Totals": {
      "main": [
        [
          {
            "node": "Format as CSV",
            "type": "main",
            "index": 0
          },
          {
            "node": "Format as XML",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Check Submission Method": {
      "main": [
        [
          {
            "node": "Submit to Government API",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Email to Tax Agent",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get PayPal Transactions": {
      "main": [
        [
          {
            "node": "Normalize PayPal Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Stripe Transactions": {
      "main": [
        [
          {
            "node": "Normalize Stripe Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Structured Output Parser": {
      "ai_outputParser": [
        [
          {
            "node": "AI Income Categorizer",
            "type": "ai_outputParser",
            "index": 0
          }
        ]
      ]
    },
    "Submit to Government API": {
      "main": [
        [
          {
            "node": "Archive to Google Drive",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge All Revenue Sources": {
      "main": [
        [
          {
            "node": "AI Income Categorizer",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Monthly revenue aggregation": {
      "main": [
        [
          {
            "node": "Workflow Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}