自动发票创建：从Google Sheets到QuickBooks Online

• •Google Sheets API 凭证

{
  "meta": {
    "instanceId": "c8c9ba5d3eb26ae47a06d24ff164a01c0d73ed4753a74903c2bb609d434a0f6b",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "110fb731-d1e5-4559-9927-d39c6ece9ae4",
      "name": "手动测试触发器",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -160,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6ea70fc0-4e62-46e3-8450-3f6d7324d978",
      "name": "从 Google Sheets 读取行",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        288,
        0
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $json.sheets_url }}"
        },
        "documentId": {
          "__rl": true,
          "mode": "url",
          "value": "={{ $json.sheets_url }}"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "gbEbCNKqCMSRZPql",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.6
    },
    {
      "id": "03f4308a-e6db-48c5-a502-329b915b7386",
      "name": "在 QuickBooks 中创建发票",
      "type": "n8n-nodes-base.quickbooks",
      "position": [
        512,
        0
      ],
      "parameters": {
        "Line": [
          {
            "Qty": 1,
            "Amount": "={{ $json.Amount }}",
            "itemId": "4",
            "DetailType": "SalesItemLineDetail",
            "Description": "={{ $json.Description }}"
          }
        ],
        "resource": "invoice",
        "operation": "create",
        "CustomerRef": "={{ $json.CustomerId }}",
        "additionalFields": {}
      },
      "credentials": {
        "quickBooksOAuth2Api": {
          "id": "swiF4vinAA4Z04DX",
          "name": "QuickBooks Online account 2"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "9749bc6e-a5ca-48af-8bde-5aa8b58bfbe3",
      "name": "配置 - 表格 URL",
      "type": "n8n-nodes-base.set",
      "position": [
        64,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "a869e559-b784-44e4-bc9d-96fb0e8445a4",
              "name": "sheets_url",
              "type": "string",
              "value": "https://docs.google.com/spreadsheets/d/17RyZVropXUeUXX1qJqHss5fNsHSuGsbPioY7Q0BwP00/edit?gid=2132365041#gid=2132365041"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "c7d6b2a7-3d4f-4e8f-9f55-6e7a9a99a4a1",
      "name": "工作流描述",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -460,
        -300
      ],
      "parameters": {
        "color": 5,
        "width": 272,
        "height": 912,
        "content": "# 工作流描述"
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "Config - Sheet URL": {
      "main": [
        [
          {
            "node": "Read Rows from Google Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Manual Test Trigger": {
      "main": [
        [
          {
            "node": "Config - Sheet URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Rows from Google Sheets": {
      "main": [
        [
          {
            "node": "Create Invoice in QuickBooks",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}