Plantilla de Google Calendar a Sheets v1.0

Name: Plantilla de Google Calendar a Sheets v1.0
Rating: 4.5 (10 reviews)
Author: Shi Varong

Avanzado

Este es unOther, IT Opsflujo de automatización del dominio deautomatización que contiene 18 nodos.Utiliza principalmente nodos como If, Code, GoogleSheets, GoogleCalendar, SplitInBatches. Sincronizar automáticamente eventos de Google Calendar con un rastreador de Google Sheets

Requisitos previos

•Credenciales de API de Google Sheets

Nodos utilizados (18)

Categoría

Otros

Operaciones de TI

Vista previa del flujo de trabajo

Visualización de las conexiones entre nodos, con soporte para zoom y panorámica

Disparador programado1

Get Events1

Check for Empty Events1

Loop Over Events & Rows1

Get Rows1

Match Events vs Rows1

Check for Match1

Update Sheet1

Add to Sheet1

React Flow

Exportar flujo de trabajo

Copie la siguiente configuración JSON en n8n para importar y usar este flujo de trabajo

{
  "id": "tpJVuoH0Z7kyiXZH",
  "meta": {
    "instanceId": "3f5dc502ba8ad809ce92e2700eacbfc6e18a9b581bf97a1f829d453fba1ca472",
    "templateCredsSetupCompleted": true
  },
  "name": "google-calendar-shees-template-v1.0",
  "tags": [],
  "nodes": [
    {
      "id": "e7d2f6c5-9d54-496b-83ff-1d22e6782c43",
      "name": "Disparador programado1",
      "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": "Get Events1",
      "type": "n8n-nodes-base.googleCalendar",
      "notes": "Get events",
      "position": [
        4460,
        1320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.3
    },
    {
      "id": "5ee267ed-5b2a-4bd3-a4e6-f8d101433892",
      "name": "Check for Empty Events1",
      "type": "n8n-nodes-base.if",
      "position": [
        4700,
        1320
      ],
      "parameters": {},
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "404884b7-8b8d-405d-a6dd-27217f2c6ac4",
      "name": "Loop Over Events & Rows1",
      "type": "n8n-nodes-base.splitInBatches",
      "notes": "Loop over",
      "position": [
        5160,
        1340
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "9355e33a-109c-41d2-abec-559ebbf97758",
      "name": "Get Rows1",
      "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": "Match Events vs Rows1",
      "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": "Check for Match1",
      "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": "Update Sheet1",
      "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": "Nota adhesiva9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4320,
        1500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fcc2f4e1-06bc-4c4a-99b9-1efd869644d5",
      "name": "Nota adhesiva10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4320,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "66e8c77d-d12b-41ae-a631-bf603687562e",
      "name": "Nota adhesiva11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3960,
        1260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f978e8f1-0f29-44c3-8e99-4422b5dba01c",
      "name": "Nota adhesiva12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3960,
        1500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c4929ab1-873d-41d5-8a0d-ff4cc96c2d90",
      "name": "Nota adhesiva13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5040,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fdf237ab-5851-472f-92e5-11fa41f53555",
      "name": "Nota adhesiva14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5040,
        1680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "21ee9327-52b6-48b0-b756-ca125c6ed697",
      "name": "Nota adhesiva15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5700,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa732d6e-36a9-4604-90ef-38bc467c6d5a",
      "name": "Nota adhesiva16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5700,
        1680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ff657f6f-9da2-4c1a-8fc6-89dd8a6c8efa",
      "name": "Add to Sheet1",
      "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": "Nota adhesiva17",
      "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
          }
        ]
      ]
    },
    "Schedule Trigger1": {
      "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
          }
        ]
      ]
    }
  }
}

Preguntas frecuentes

¿Cómo usar este flujo de trabajo?

Copie el código de configuración JSON de arriba, cree un nuevo flujo de trabajo en su instancia de n8n y seleccione "Importar desde JSON", pegue la configuración y luego modifique la configuración de credenciales según sea necesario.

¿En qué escenarios es adecuado este flujo de trabajo?

Avanzado - Otros, Operaciones de TI

¿Es de pago?

Este flujo de trabajo es completamente gratuito, puede importarlo y usarlo directamente. Sin embargo, tenga en cuenta que los servicios de terceros utilizados en el flujo de trabajo (como la API de OpenAI) pueden requerir un pago por su cuenta.