Modèle Google Calendar vers Sheets v1.0

Name: Modèle Google Calendar vers Sheets v1.0
Rating: 4.5 (10 reviews)
Author: Shi Varong

Avancé

Ceci est unOther, IT Opsworkflow d'automatisation du domainecontenant 18 nœuds.Utilise principalement des nœuds comme If, Code, GoogleSheets, GoogleCalendar, SplitInBatches. Synchroniser automatiquement les événements Google Calendar avec un suivi Google Sheets

Prérequis

•Informations d'identification Google Sheets API

Nœuds utilisés (18)

Catégorie

Autres

Opérations IT

Aperçu du workflow

Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement

Déclencheur Planifié1

Obtenir les Événements1

Vérifier les Événements Vides1

Boucle sur Événements et Lignes1

Obtenir les Lignes1

Correspondance Événements vs Lignes1

Vérifier la Correspondance1

Mettre à Jour Sheet1

Ajouter à Sheet1

React Flow

Exporter le workflow

Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow

{
  "id": "tpJVuoH0Z7kyiXZH",
  "meta": {
    "instanceId": "3f5dc502ba8ad809ce92e2700eacbfc6e18a9b581bf97a1f829d453fba1ca472",
    "templateCredsSetupCompleted": true
  },
  "name": "google-calendar-shees-template-v1.0",
  "tags": [],
  "nodes": [
    {
      "id": "e7d2f6c5-9d54-496b-83ff-1d22e6782c43",
      "name": "Déclencheur Planifié1",
      "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": "Obtenir les Événements1",
      "type": "n8n-nodes-base.googleCalendar",
      "notes": "Get events",
      "position": [
        4460,
        1320
      ],
      "parameters": {},
      "notesInFlow": true,
      "typeVersion": 1.3
    },
    {
      "id": "5ee267ed-5b2a-4bd3-a4e6-f8d101433892",
      "name": "Vérifier les Événements Vides1",
      "type": "n8n-nodes-base.if",
      "position": [
        4700,
        1320
      ],
      "parameters": {},
      "typeVersion": 2.2,
      "alwaysOutputData": true
    },
    {
      "id": "404884b7-8b8d-405d-a6dd-27217f2c6ac4",
      "name": "Boucle sur Événements et Lignes1",
      "type": "n8n-nodes-base.splitInBatches",
      "notes": "Loop over",
      "position": [
        5160,
        1340
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "9355e33a-109c-41d2-abec-559ebbf97758",
      "name": "Obtenir les Lignes1",
      "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": "Correspondance Événements vs Lignes1",
      "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": "Vérifier la Correspondance1",
      "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": "Mettre à Jour 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": "Note Adhésive9",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4320,
        1500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fcc2f4e1-06bc-4c4a-99b9-1efd869644d5",
      "name": "Note Adhésive10",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        4320,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "66e8c77d-d12b-41ae-a631-bf603687562e",
      "name": "Note Adhésive11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3960,
        1260
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "f978e8f1-0f29-44c3-8e99-4422b5dba01c",
      "name": "Note Adhésive12",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        3960,
        1500
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c4929ab1-873d-41d5-8a0d-ff4cc96c2d90",
      "name": "Note Adhésive13",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5040,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fdf237ab-5851-472f-92e5-11fa41f53555",
      "name": "Note Adhésive14",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5040,
        1680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "21ee9327-52b6-48b0-b756-ca125c6ed697",
      "name": "Note Adhésive15",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5700,
        1220
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "fa732d6e-36a9-4604-90ef-38bc467c6d5a",
      "name": "Note Adhésive16",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        5700,
        1680
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "ff657f6f-9da2-4c1a-8fc6-89dd8a6c8efa",
      "name": "Ajouter à 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": "Note Adhésive17",
      "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
          }
        ]
      ]
    }
  }
}

Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Avancé - Autres, Opérations IT

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.