Google Kalender zu Sheets Vorlage v1.0

Name: Google Kalender zu Sheets Vorlage v1.0
Rating: 4.5 (10 reviews)
Author: Shi Varong

Experte

Dies ist ein Other, IT Ops-Bereich Automatisierungsworkflow mit 18 Nodes. Hauptsächlich werden If, Code, GoogleSheets, GoogleCalendar, SplitInBatches und andere Nodes verwendet. Automatische Synchronisierung von Google-Kalender-Events mit einem Google-Tracker-Sheet

Voraussetzungen

•Google Sheets API-Anmeldedaten

Verwendete Nodes (18)

Kategorie

Sonstiges

IT-Betrieb

Workflow-Vorschau

Visualisierung der Node-Verbindungen, mit Zoom und Pan

Zeitplan-Trigger1

Ereignisse abrufen1

Auf leere Ereignisse prüfen1

Schleife über Ereignisse & Zeilen1

Zeilen abrufen1

Ereignisse mit Zeilen abgleichen1

Auf Übereinstimmung prüfen1

Sheet aktualisieren1

Zu Sheet hinzufügen1

React Flow

Workflow exportieren

Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n

{
  "id": "tpJVuoH0Z7kyiXZH",
  "meta": {
    "instanceId": "3f5dc502ba8ad809ce92e2700eacbfc6e18a9b581bf97a1f829d453fba1ca472",
    "templateCredsSetupCompleted": true
  },
  "name": "google-calendar-shees-template-v1.0",
  "tags": [],
  "nodes": [
    {
      "id": "e7d2f6c5-9d54-496b-83ff-1d22e6782c43",
      "name": "Zeitplan-Trigger1",
      "type": "n8n-nodes-base.scheduleTrigger",
      "notes": "Every 1 min",
      "position": [
        4040,
        1320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.2
    },
    {
      "id": "834ec869-a81e-4d28-b9d5-9dc81d4cece6",
      "name": "Ereignisse abrufen1",
      "type": "n8n-nodes-base.googleCalendar",
      "notes": "Get events",
      "position": [
        4460,
        1320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.3
    },
    {
      "id": "5ee267ed-5b2a-4bd3-a4e6-f8d101433892",
      "name": "Auf leere Ereignisse prüfen1",
      "type": "n8n-nodes-base.if",
      "position": [
        4700,
        1320
      ],
      "parameters": {},
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "404884b7-8b8d-405d-a6dd-27217f2c6ac4",
      "name": "Schleife über Ereignisse & Zeilen1",
      "type": "n8n-nodes-base.splitInBatches",
      "notes": "Loop over",
      "position": [
        5160,
        1340
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "9355e33a-109c-41d2-abec-559ebbf97758",
      "name": "Zeilen abrufen1",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Get rows",
      "onError": "continueRegularOutput",
      "position": [
        5420,
        1440
      ],
      "parameters": {},
      "executeOnce": true,
      "notesInFlow": true,
      "retryOnFail": false,
      "typeVersion": 4.6,
      "alwaysOutputData": true
    },
    {
      "id": "d57d6abc-af73-41b7-8e3d-c4346d934171",
      "name": "Ereignisse mit Zeilen abgleichen1",
      "type": "n8n-nodes-base.code",
      "notes": "Check event against sheet",
      "position": [
        5800,
        1320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2,
      "alwaysOutputData": false
    },
    {
      "id": "d587e1c9-b04d-417f-b155-847df5ac83cb",
      "name": "Auf Übereinstimmung prüfen1",
      "type": "n8n-nodes-base.if",
      "notes": "true -> update; false -> add to sheet",
      "position": [
        6040,
        1320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 2.2
    },
    {
      "id": "48c435fb-df81-44a4-ad55-8cf7db844b76",
      "name": "Sheet aktualisieren1",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Update rows in sheet",
      "position": [
        6340,
        1300
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "04e8f9f2-0c1c-4a2b-83a6-5bf9a9d14943",
      "name": "Haftnotiz9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4320,
        1500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fcc2f4e1-06bc-4c4a-99b9-1efd869644d5",
      "name": "Haftnotiz10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4320,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "66e8c77d-d12b-41ae-a631-bf603687562e",
      "name": "Haftnotiz11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3960,
        1260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f978e8f1-0f29-44c3-8e99-4422b5dba01c",
      "name": "Haftnotiz12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3960,
        1500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c4929ab1-873d-41d5-8a0d-ff4cc96c2d90",
      "name": "Haftnotiz13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5040,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fdf237ab-5851-472f-92e5-11fa41f53555",
      "name": "Haftnotiz14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5040,
        1680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "21ee9327-52b6-48b0-b756-ca125c6ed697",
      "name": "Haftnotiz15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5700,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa732d6e-36a9-4604-90ef-38bc467c6d5a",
      "name": "Haftnotiz16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5700,
        1680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ff657f6f-9da2-4c1a-8fc6-89dd8a6c8efa",
      "name": "Zu Sheet hinzufügen1",
      "type": "n8n-nodes-base.googleSheets",
      "notes": "Add rows to sheet",
      "position": [
        6340,
        1480
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 4.6
    },
    {
      "id": "b3c2f7df-409a-4699-a48b-9a1bf1c227fb",
      "name": "Haftnotiz17",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3940,
        1040
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "1a845fb1-74c7-4d0f-9c1b-a11d7174fd55",
  "connections": {
    "9355e33a-109c-41d2-abec-559ebbf97758": {
      "main": [
        [
          {
            "node": "404884b7-8b8d-405d-a6dd-27217f2c6ac4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "834ec869-a81e-4d28-b9d5-9dc81d4cece6": {
      "main": [
        [
          {
            "node": "5ee267ed-5b2a-4bd3-a4e6-f8d101433892",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d587e1c9-b04d-417f-b155-847df5ac83cb": {
      "main": [
        [
          {
            "node": "48c435fb-df81-44a4-ad55-8cf7db844b76",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "ff657f6f-9da2-4c1a-8fc6-89dd8a6c8efa",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e7d2f6c5-9d54-496b-83ff-1d22e6782c43": {
      "main": [
        [
          {
            "node": "834ec869-a81e-4d28-b9d5-9dc81d4cece6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d57d6abc-af73-41b7-8e3d-c4346d934171": {
      "main": [
        [
          {
            "node": "d587e1c9-b04d-417f-b155-847df5ac83cb",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5ee267ed-5b2a-4bd3-a4e6-f8d101433892": {
      "main": [
        [],
        [
          {
            "node": "404884b7-8b8d-405d-a6dd-27217f2c6ac4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "404884b7-8b8d-405d-a6dd-27217f2c6ac4": {
      "main": [
        [
          {
            "node": "d57d6abc-af73-41b7-8e3d-c4346d934171",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "9355e33a-109c-41d2-abec-559ebbf97758",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}

Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Experte - Sonstiges, IT-Betrieb

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.