Optimisation de la gestion des Pull Requests avec Pipedrive
Ce workflow permet d'automatiser le suivi des Pull Requests GitHub en les intégrant directement dans Pipedrive. Lorsqu'...
Documentation Complète
📋 Synchronisation Automatisée des Événements Discord et Google Calendar
💡 Description
Ce workflow puissant automatise la synchronisation des événements programmés sur Discord avec Google Calendar, garantissant que vos calendriers sont toujours à jour. En utilisant une intégration fluide entre ces deux plateformes, il récupère régulièrement les événements de votre serveur Discord et les compare avec ceux de Google Calendar. Les nouveaux événements sont créés et les existants sont mis à jour automatiquement, éliminant ainsi les erreurs manuelles et économisant un temps précieux pour votre équipe. Parfait pour garder tout le monde informé sans effort supplémentaire.
📈 Impact & ROI: Ce workflow augmente l'efficacité opérationnelle en réduisant le temps consacré à la mise à jour manuelle des calendriers, permettant ainsi aux équipes de se concentrer sur des tâches plus stratégiques. L'automatisation minimise également les erreurs potentielles, garantissant que tous les membres de l'équipe disposent d'informations à jour et précises.
🚀 Fonctionnalités Clés
- ✅ Automatisation complète de la mise à jour des événements
- ✅ Intégration transparente entre Discord et Google Calendar
- ✅ Réduction du risque d'erreurs manuelles dans la gestion des calendriers
- ✅ Amélioration de l'efficacité de l'équipe grâce à une information centralisée
📊 Architecture Technique
9
Nodes
Nodes
5
Connexions
Connexions
3
Services
Services
🔌 Services Intégrés
DiscordGoogle Calendarn8n
🔧 Composition du Workflow
| Node | Type | Description |
|---|---|---|
| List scheduled events from Discord | httpRequest | Requête HTTP vers une API externe |
| On schedule | scheduleTrigger | Traitement des données |
| Update event details | googleCalendar | Traitement des données |
| Create event | googleCalendar | Traitement des données |
| Get events | googleCalendar | Traitement des données |
| Create or update? | if | Condition logique pour router le flux |
| Configure | set | Traitement des données |
| Sticky Note1 | stickyNote | Traitement des données |
| Sticky Note | stickyNote | Traitement des données |
📖 Guide d'Implémentation
- Import du workflow: Téléchargez le fichier JSON et importez-le dans votre instance n8n
- Configuration des credentials: Configurez les accès pour chaque service utilisé
- Personnalisation: Adaptez les paramètres selon vos besoins spécifiques
- Test: Exécutez le workflow en mode test pour vérifier le bon fonctionnement
- Activation: Activez le workflow pour une exécution automatique
🏷️ Tags
Structure JSON
Voir le code JSON complet
{
"meta": {
"instanceId": "a2434c94d549548a685cca39cc4614698e94f527bcea84eefa363f1037ae14cd"
},
"nodes": [
{
"id": "78d5f452-5ba1-4d59-9d52-8f32512d2c25",
"name": "List scheduled events from Discord",
"type": "n8n-nodes-base.httpRequest",
"position": [
1940,
1000
],
"parameters": {
"url": "=https:\/\/discord.com\/api\/guilds\/{{ $('Configure').first().json.guild_id }}\/scheduled-events",
"options": [],
"sendQuery": true,
"authentication": "genericCredentialType",
"genericAuthType": "httpHeaderAuth",
"queryParameters": {
"parameters": [
{
"name": "with_user_count",
"value": "true"
}
]
}
},
"credentials": {
"httpHeaderAuth": {
"id": "fxbcosIH3MYkufX8",
"name": "FILL ME"
}
},
"typeVersion": 4.1
},
{
"id": "af149917-0d46-4a40-b377-69c088a4a7b9",
"name": "On schedule",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
1420,
1000
],
"parameters": {
"rule": {
"interval": [
[]
]
}
},
"typeVersion": 1.1
},
{
"id": "619c149f-f954-4f5d-a160-01a8b85f3eb7",
"name": "Update event details",
"type": "n8n-nodes-base.googleCalendar",
"position": [
2600,
900
],
"parameters": {
"eventId": "={{ $json.id }}",
"calendar": {
"__rl": true,
"mode": "list",
"value": "[UPDATE ME]",
"cachedResultName": "Events"
},
"operation": "update",
"updateFields": {
"end": "={{ $('List scheduled events from Discord').item.json.scheduled_end_time }}",
"start": "={{ $('List scheduled events from Discord').item.json.scheduled_start_time }}",
"summary": "={{ $('List scheduled events from Discord').item.json.name }}",
"location": "={{ $('List scheduled events from Discord').item.json.entity_metadata.location }}",
"description": "={{ $('List scheduled events from Discord').item.json.description }}"
}
},
"credentials": {
"googleCalendarOAuth2Api": {
"id": "dRGPTy0BjDpAYjYl",
"name": "FILL ME"
}
},
"typeVersion": 1
},
{
"id": "56e60042-d345-46f2-b1c6-4e21825cb5c9",
"name": "Create event",
"type": "n8n-nodes-base.googleCalendar",
"position": [
2600,
1100
],
"parameters": {
"end": "={{ $('List scheduled events from Discord').item.json.scheduled_end_time }}",
"start": "={{ $('List scheduled events from Discord').item.json.scheduled_start_time }}",
"calendar": {
"__rl": true,
"mode": "list",
"value": "[UPDATE ME]",
"cachedResultName": "Events"
},
"additionalFields": {
"id": "={{ $('List scheduled events from Discord').item.json.id }}",
"summary": "={{ $('List scheduled events from Discord').item.json.name }}",
"location": "={{ $('List scheduled events from Discord').item.json.entity_metadata.location }}",
"description": "={{ $('List scheduled events from Discord').item.json.description }}"
}
},
"credentials": {
"googleCalendarOAuth2Api": {
"id": "dRGPTy0BjDpAYjYl",
"name": "FILL ME"
}
},
"typeVersion": 1
},
{
"id": "afb05bee-eb5f-453f-8e95-277296ce94b8",
"name": "Get events",
"type": "n8n-nodes-base.googleCalendar",
"position": [
2160,
1000
],
"parameters": {
"eventId": "={{ $json.id }}",
"options": [],
"calendar": {
"__rl": true,
"mode": "list",
"value": "[UPDATE ME]",
"cachedResultName": "Events"
},
"operation": "get"
},
"credentials": {
"googleCalendarOAuth2Api": {
"id": "dRGPTy0BjDpAYjYl",
"name": "FILL ME"
}
},
"typeVersion": 1,
"continueOnFail": true,
"alwaysOutputData": false
},
{
"id": "56b731bd-4676-4b77-bafa-7120a51bf75d",
"name": "Create or update?",
"type": "n8n-nodes-base.if",
"position": [
2380,
1000
],
"parameters": {
"conditions": {
"string": [
{
"value1": "={{ $json.id }}",
"operation": "isNotEmpty"
}
]
}
},
"typeVersion": 1
},
{
"id": "12e40b0e-3740-47db-8647-eff8c0c959df",
"name": "Configure",
"type": "n8n-nodes-base.set",
"position": [
1680,
1000
],
"parameters": {
"values": {
"string": [
{
"name": "guild_id",
"value": "447359847986495498"
}
]
},
"options": []
},
"typeVersion": 2
},
{
"id": "4160a727-6a50-40ce-a7f2-0abbd5a6b1bc",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
1600,
940
],
"parameters": {
"width": 254.7946768060834,
"height": 296.7300380228139,
"content": "### Configuration\n\n\n\n\n\n\n\n\n\n\n\n\n\n__`guild_id`__: the server ID in Discord. See how to get that [from this Wikipedia tutorial](https:\/\/en.wikipedia.org\/wiki\/Template:Discord_server#:~:text=Getting%20Guild%20ID,to%20get%20the%20guild%20ID.)."
},
"typeVersion": 1
},
{
"id": "ac717afe-1d30-4994-a134-0d535d04b932",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
920,
760
],
"parameters": {
"width": 420.45280925604845,
"height": 639.1273068962362,
"content": "## Sync Discord scheduled events to Google Calendar\nThis workflow syncs Discord scheduled events to Google Calendar. On a specified schedule, a request to Discord's API is made to get the scheduled events on a particular server. Only the events that have not been created or have recently been updated will be sent to Google Calendar.\n\n### Setup\nYou will need to create a Discord bot. See how to do that [here](https:\/\/github.com\/reactiflux\/discord-irc\/wiki\/Creating-a-discord-bot-&-getting-a-token). Once you have created your bot, create **Header Auth** in `List scheduled events from Discord` node. Your header auth fields should be:\n\nName: Authorization\nValue: Bot _<your token>_ \n(i.e. Bot MTEzMTgw...uQdg)\n\n### How it works\n1. Triggers off on the `On schedule` node.\n2. Gets the scheduled events from Discord.\n3. The IDs of the Discord scheduled events are used to get the events from Google Calendar, since the IDs are the same on creation of the Google Calendar event.\n4. We can now determine which events are new or have been updated.\n5. The new or updated events are created or updated in Google Calendar."
},
"typeVersion": 1
}
],
"connections": {
"Configure": {
"main": [
[
{
"node": "List scheduled events from Discord",
"type": "main",
"index": 0
}
]
]
},
"Get events": {
"main": [
[
{
"node": "Create or update?",
"type": "main",
"index": 0
}
]
]
},
"On schedule": {
"main": [
[
{
"node": "Configure",
"type": "main",
"index": 0
}
]
]
},
"Create or update?": {
"main": [
[
{
"node": "Update event details",
"type": "main",
"index": 0
}
],
[
{
"node": "Create event",
"type": "main",
"index": 0
}
]
]
},
"List scheduled events from Discord": {
"main": [
[
{
"node": "Get events",
"type": "main",
"index": 0
}
]
]
}
}
}
Workflows Similaires
Synchronisation Automatisée des Événements Discord et Google Calendar
Ce workflow puissant automatise la synchronisation des événements programmés sur Discord avec Google Calendar, garant...
Automatisez les commandes Squarespace vers Google Sheets
Ce workflow automatise le processus de récupération des commandes de Squarespace et leur enregistrement dans Google Sh...