QuickBooks发票到Google表格自动化

• •HTTP Webhook 端点（n8n 会自动生成）
• •Google Sheets API 凭证

{
  "id": "4gzrrLiXlAZrOodq",
  "meta": {
    "instanceId": "1a54c41d9050a8f1fa6f74ca858828ad9fb97b9fafa3e9760e576171c531a787"
  },
  "name": "Quickbooks 发票到 Google Sheet 自动化",
  "tags": [],
  "nodes": [
    {
      "id": "a10919bd-1940-4f81-8c7f-44725a12b7e1",
      "name": "QuickBooks Webhook",
      "type": "n8n-nodes-base.webhook",
      "position": [
        260,
        1100
      ],
      "webhookId": "{YOUR_WEBHOOK_ID}",
      "parameters": {
        "path": "quickbooks-invoice",
        "options": {},
        "httpMethod": "POST"
      },
      "typeVersion": 1
    },
    {
      "id": "73b985b5-5984-4c30-9113-3238e0bca12f",
      "name": "代码",
      "type": "n8n-nodes-base.code",
      "position": [
        1440,
        1100
      ],
      "parameters": {
        "jsCode": "return items.map(item => {\n  return {\n    json: {\n      ID: item.json.Id,\n      Domain: item.json.domain,\n      \"Customer Name\": item.json.CustomerRef?.name || \"\",\n      \"Due Date\": item.json.DueDate || \"\"\n    }\n  };\n});\n"
      },
      "typeVersion": 2
    },
    {
      "id": "621a872a-3622-4bd2-8a92-fc2947132359",
      "name": "获取发票",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        880,
        1100
      ],
      "parameters": {
        "resource": "invoice",
        "invoiceId": "={{ $json.body.eventNotifications[0].dataChangeEvent.entities[0].id }}"
      },
      "typeVersion": 1
    },
    {
      "id": "61c0a129-a49e-407d-8d26-57f999333558",
      "name": "在表格中追加或更新行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        2100,
        1100
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "ID",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "ID",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Domain",
              "type": "string",
              "display": true,
              "required": false,
              "displayName": "Domain",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [
            "ID"
          ],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_SHEET_ID}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{YOUR_GOOGLE_DOCUMENT_ID}/edit#gid=0",
          "cachedResultName": "quickbooks"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "{YOUR_GOOGLE_DOCUMENT_ID}",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/{YOUR_GOOGLE_DOCUMENT_ID}/edit?usp=drivesdk",
          "cachedResultName": "quickbooks"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "bd74fe13-f6d2-40e6-a310-f70ba77901cd",
      "name": "便签",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        0,
        560
      ],
      "parameters": {
        "color": 3,
        "width": 480,
        "height": 500,
        "content": "## 🛠️ 前提条件"
      },
      "typeVersion": 1
    },
    {
      "id": "9cef3279-b6d3-4afc-b87f-c6d5af317ae5",
      "name": "便签1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        60,
        1240
      ],
      "parameters": {
        "width": 480,
        "height": 340,
        "content": "### 步骤 1：Webhook 触发器已激活！🪝📢"
      },
      "typeVersion": 1
    },
    {
      "id": "1bf6a99b-e913-462c-8484-a53ec4e60acd",
      "name": "便签2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        700,
        660
      ],
      "parameters": {
        "color": 5,
        "width": 480,
        "height": 400,
        "content": "### 步骤 2：发票数据获取器 📄🔍"
      },
      "typeVersion": 1
    },
    {
      "id": "e7356f43-b3d8-428f-9113-457e1bd9090c",
      "name": "便签3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1260,
        1240
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 380,
        "content": "### 步骤 3：JSON 格式化器 🛠️📦"
      },
      "typeVersion": 1
    },
    {
      "id": "c7891c9d-6699-470f-8ef7-f6ce21e01548",
      "name": "便签4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1900,
        600
      ],
      "parameters": {
        "color": 6,
        "width": 520,
        "height": 460,
        "content": "### 步骤 4：Google Sheet 追加 📄➕"
      },
      "typeVersion": 1
    },
    {
      "id": "2bbfaf8c-4ce1-40c3-8ed4-b79f77237187",
      "name": "便利贴5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        2100,
        1340
      ],
      "parameters": {
        "color": 3,
        "width": 440,
        "height": 380,
        "content": "### 联系我们"
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "19e1f8a9-5325-4c3a-91c9-0b3aa765c942",
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Append or update row in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get an invoice": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "QuickBooks Webhook": {
      "main": [
        [
          {
            "node": "Get an invoice",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}