Automatische Rechnungserstellung: von Google Sheets zu QuickBooks Online

• •Google Sheets API-Anmeldedaten

{
  "meta": {
    "instanceId": "c8c9ba5d3eb26ae47a06d24ff164a01c0d73ed4753a74903c2bb609d434a0f6b",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "110fb731-d1e5-4559-9927-d39c6ece9ae4",
      "name": "Manueller Test-Trigger",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -160,
        0
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "6ea70fc0-4e62-46e3-8450-3f6d7324d978",
      "name": "Zeilen aus Google Tabellen lesen",
      "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": "Rechnung in QuickBooks erstellen",
      "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": "Konfiguration - Tabellen-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": "Workflow-Beschreibung",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -460,
        -300
      ],
      "parameters": {
        "color": 5,
        "width": 272,
        "height": 912,
        "content": "# Workflow description\n\nClick run, read rows, create invoices. Simple.\n\n**Example sheet (read-only):**\nhttps://docs.google.com/spreadsheets/d/17RyZVropXUeUXX1qJqHss5fNsHSuGsbPioY7Q0BwP00/edit?gid=2132365041#gid=2132365041\n\n## Steps\n1) **Manual Test Trigger** - you press Execute.\n2) **Config - Sheet URL** - holds the Google Sheets URL (as `sheets_url`). Defaults to the example above.\n3) **Read Rows from Google Sheets** - loads rows; expects `CustomerId`, `Amount`, `Description`.\n4) **Create Invoice in QuickBooks** - makes one invoice per row. Uses itemId=4, Qty=1.\n\n## Setup\n- Connect **QuickBooks** and **Google Sheets** credentials.\n- Keep the example link for demo or replace with your own sheet.\n- Change `itemId` in the invoice node to your real item.\n\n## Replace Sheets\nSwap the reader with Airtable, CSV, DB query, or your API. Keep the same field names.\n\nDone. If something fails, open the execution and check the red node."
      },
      "typeVersion": 1
    }
  ],
  "pinData": {},
  "connections": {
    "9749bc6e-a5ca-48af-8bde-5aa8b58bfbe3": {
      "main": [
        [
          {
            "node": "Zeilen aus Google Sheets lesen",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "110fb731-d1e5-4559-9927-d39c6ece9ae4": {
      "main": [
        [
          {
            "node": "9749bc6e-a5ca-48af-8bde-5aa8b58bfbe3",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Zeilen aus Google Sheets lesen": {
      "main": [
        [
          {
            "node": "03f4308a-e6db-48c5-a502-329b915b7386",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}