الفواتير المدفوعة في جدول المحاسبة

{
  "name": "الفواتير المدفوعة في جدول المحاسبة (Flowngn)",
  "nodes": [
    {
      "parameters": {
        "content": "## الفواتير المدفوعة في جدول المحاسبة\nكل فاتورة مدفوعة في Stripe تُسجَّل تلقائيًا، جاهزة لمحاسبك.\n\n**Setup**\n1. Open each node and connect your own credentials.\n2. Replace every YOUR_… placeholder.\n3. Test once, then activate.\n\nFree template from Flowngn",
        "height": 260,
        "width": 340
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Setup notes",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -420,
        -60
      ]
    },
    {
      "parameters": {
        "events": [
          "invoice.paid"
        ]
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Invoice paid",
      "type": "n8n-nodes-base.stripeTrigger",
      "typeVersion": 1,
      "position": [
        0,
        0
      ],
      "webhookId": "458223d5-1673-42cd-a93b-ba83e310fb25"
    },
    {
      "parameters": {
        "assignments": {
          "assignments": [
            {
              "id": "a1",
              "name": "date",
              "value": "={{ DateTime.fromSeconds($json.data.object.created).toISODate() }}",
              "type": "string"
            },
            {
              "id": "a2",
              "name": "customer",
              "value": "={{ $json.data.object.customer_email }}",
              "type": "string"
            },
            {
              "id": "a3",
              "name": "amount",
              "value": "={{ $json.data.object.amount_paid / 100 }}",
              "type": "number"
            },
            {
              "id": "a4",
              "name": "currency",
              "value": "={{ $json.data.object.currency.toUpperCase() }}",
              "type": "string"
            },
            {
              "id": "a5",
              "name": "tax",
              "value": "={{ ($json.data.object.tax || 0) / 100 }}",
              "type": "number"
            },
            {
              "id": "a6",
              "name": "invoice_pdf",
              "value": "={{ $json.data.object.invoice_pdf }}",
              "type": "string"
            }
          ]
        },
        "options": {}
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Pick invoice fields",
      "type": "n8n-nodes-base.set",
      "typeVersion": 3.4,
      "position": [
        300,
        0
      ]
    },
    {
      "parameters": {
        "operation": "append",
        "documentId": {
          "__rl": true,
          "value": "YOUR_SPREADSHEET_ID",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": "Invoices",
          "mode": "name"
        },
        "columns": {
          "mappingMode": "autoMapInputData",
          "value": {}
        },
        "options": {}
      },
      "id": "458223d5-1673-42cd-a93b-ba83e310fb25",
      "name": "Add to bookkeeping",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        600,
        0
      ]
    }
  ],
  "connections": {
    "Invoice paid": {
      "main": [
        [
          {
            "node": "Pick invoice fields",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Pick invoice fields": {
      "main": [
        [
          {
            "node": "Add to bookkeeping",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "meta": {
    "templateCredsSetupCompleted": false
  },
  "tags": []
}