Système de gestion des participants à un événement et de suivi automatisé

• •Compte Google et informations d'identification Gmail API
• •Token Bot Slack ou URL Webhook
• •Clé API Stripe
• •Informations d'identification Google Sheets API

{
  "id": "Viv8fgIQ3YahLz3q",
  "meta": {
    "instanceId": "15d6057a37b8367f33882dd60593ee5f6cc0c59310ff1dc66b626d726083b48d",
    "templateCredsSetupCompleted": true
  },
  "name": "Event Participant Management and Automated Follow-up System",
  "tags": [],
  "nodes": [
    {
      "id": "7c944a05-dc18-4966-875e-f101544e3597",
      "name": "Formulaire d'Inscription Typeform",
      "type": "n8n-nodes-base.typeformTrigger",
      "position": [
        0,
        0
      ],
      "webhookId": "baa3faaf-3d23-45ca-89b6-b2f399fb6899",
      "parameters": {
        "formId": "<__PLACEHOLDER_VALUE__Typeform Form ID__>"
      },
      "typeVersion": 1.1
    },
    {
      "id": "b4c828ad-aae3-4131-9383-165702e353e4",
      "name": "Configuration du Workflow",
      "type": "n8n-nodes-base.set",
      "position": [
        224,
        0
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "id-1",
              "name": "eventName",
              "type": "string",
              "value": "<__PLACEHOLDER_VALUE__Event Name__>"
            },
            {
              "id": "id-2",
              "name": "eventDate",
              "type": "string",
              "value": "<__PLACEHOLDER_VALUE__Event Date (YYYY-MM-DD)__>"
            },
            {
              "id": "id-3",
              "name": "eventTime",
              "type": "string",
              "value": "<__PLACEHOLDER_VALUE__Event Time__>"
            },
            {
              "id": "id-4",
              "name": "eventLocation",
              "type": "string",
              "value": "<__PLACEHOLDER_VALUE__Event Location__>"
            },
            {
              "id": "id-5",
              "name": "participationFee",
              "type": "string",
              "value": "<__PLACEHOLDER_VALUE__Participation Fee Amount__>"
            },
            {
              "id": "id-6",
              "name": "reminderDaysBefore",
              "type": "number",
              "value": 3
            },
            {
              "id": "id-7",
              "name": "followupDaysAfter",
              "type": "number",
              "value": 2
            },
            {
              "id": "id-8",
              "name": "organizerSlackChannel",
              "type": "string",
              "value": "<__PLACEHOLDER_VALUE__Slack Channel ID__>"
            }
          ]
        },
        "includeOtherFields": true
      },
      "typeVersion": 3.4
    },
    {
      "id": "d2e4b2da-73e2-485c-82c7-1f41d6b9a4f4",
      "name": "Ajouter à la Liste des Participants",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        448,
        0
      ],
      "parameters": {
        "columns": {
          "value": {
            "Name": "={{ $json.name }}",
            "Email": "={{ $json.email }}",
            "Phone": "={{ $json.phone }}",
            "Event Date": "={{ $('Workflow Configuration').first().json.eventDate }}",
            "Event Name": "={{ $('Workflow Configuration').first().json.eventName }}",
            "Payment Status": "Pending",
            "Registration Date": "={{ $now.toISO() }}"
          },
          "schema": [
            {
              "id": "Name",
              "required": false,
              "displayName": "Name",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Email",
              "required": false,
              "displayName": "Email",
              "defaultMatch": true,
              "canBeUsedToMatch": true
            },
            {
              "id": "Phone",
              "required": false,
              "displayName": "Phone",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Registration Date",
              "required": false,
              "displayName": "Registration Date",
              "defaultMatch": false,
              "canBeUsedToMatch": false
            },
            {
              "id": "Event Name",
              "required": false,
              "displayName": "Event Name",
              "defaultMatch": false,
              "canBeUsedToMatch": false
            },
            {
              "id": "Event Date",
              "required": false,
              "displayName": "Event Date",
              "defaultMatch": false,
              "canBeUsedToMatch": false
            },
            {
              "id": "Payment Status",
              "required": false,
              "displayName": "Payment Status",
              "defaultMatch": false,
              "canBeUsedToMatch": false
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ]
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "<__PLACEHOLDER_VALUE__Sheet Name (e.g., Participants)__>"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "<__PLACEHOLDER_VALUE__Google Sheets Document ID__>"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "fwevXXzMkUJJc2Ue",
          "name": "Google Sheets account 13"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "0847f022-be9a-4137-95cb-291f6f1608e9",
      "name": "Traiter le Paiement",
      "type": "n8n-nodes-base.stripe",
      "position": [
        672,
        0
      ],
      "parameters": {
        "amount": "={{ $('Workflow Configuration').first().json.participationFee * 100 }}",
        "source": "<__PLACEHOLDER_VALUE__Source ID__>",
        "currency": "jpy",
        "resource": "charge",
        "operation": "create",
        "customerId": "<__PLACEHOLDER_VALUE__Customer ID__>",
        "additionalFields": {
          "metadata": {
            "metadataProperties": [
              {
                "key": "participant_email",
                "value": "={{ $json.email }}"
              },
              {
                "key": "participant_name",
                "value": "={{ $json.name }}"
              },
              {
                "key": "event_name",
                "value": "={{ $('Workflow Configuration').first().json.eventName }}"
              }
            ]
          },
          "description": "={{ 'Event Registration: ' + $('Workflow Configuration').first().json.eventName }}"
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5d2c0d4e-5f4e-4659-9467-575667f47c0b",
      "name": "Vérifier le Statut du Paiement",
      "type": "n8n-nodes-base.if",
      "position": [
        896,
        0
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "id-1",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $json.status }}",
              "rightValue": "succeeded"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "e2462463-af2a-445c-b526-efcce51b9b18",
      "name": "Envoyer l'E-mail de Confirmation",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1136,
        -96
      ],
      "webhookId": "8731cfaf-f3fb-46aa-923e-ce0a23184d70",
      "parameters": {
        "sendTo": "={{ $('Typeform Registration Form').first().json.email }}",
        "message": "=<h2>ご登録ありがとうございます</h2><p>{{ $('Typeform Registration Form').first().json.name }} 様</p><p>{{ $('Workflow Configuration').first().json.eventName }} へのご登録が完了しました。</p><p><strong>イベント詳細:</strong></p><ul><li>日時: {{ $('Workflow Configuration').first().json.eventDate }} {{ $('Workflow Configuration').first().json.eventTime }}</li><li>場所: {{ $('Workflow Configuration').first().json.eventLocation }}</li></ul><p>当日お会いできることを楽しみにしております。</p>",
        "options": {},
        "subject": "={{ 'イベント参加確認: ' + $('Workflow Configuration').first().json.eventName }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "jVcyBJ7jBcuc69EM",
          "name": "Gmail account 3"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "e63d3572-bc39-4a7a-aa8c-2840ccc46c18",
      "name": "Ajouter au Calendrier",
      "type": "n8n-nodes-base.googleCalendar",
      "position": [
        1360,
        -96
      ],
      "parameters": {
        "end": "={{ DateTime.fromISO($('Workflow Configuration').first().json.eventDate + 'T' + $('Workflow Configuration').first().json.eventTime).plus({ hours: 2 }).toISO() }}",
        "start": "={{ $('Workflow Configuration').first().json.eventDate + 'T' + $('Workflow Configuration').first().json.eventTime }}",
        "calendar": {
          "__rl": true,
          "mode": "id",
          "value": "primary"
        },
        "additionalFields": {
          "summary": "={{ $('Workflow Configuration').first().json.eventName }}",
          "location": "={{ $('Workflow Configuration').first().json.eventLocation }}",
          "description": "={{ 'Participant: ' + $('Typeform Registration Form').first().json.name }}"
        }
      },
      "credentials": {
        "googleCalendarOAuth2Api": {
          "id": "XOC7KbMeZBKOuP5V",
          "name": "Google Calendar account 3"
        }
      },
      "typeVersion": 1.3
    },
    {
      "id": "b5c019f2-6e53-4348-adbf-1962574e9568",
      "name": "Notifier l'Organisateur",
      "type": "n8n-nodes-base.slack",
      "position": [
        1584,
        -96
      ],
      "webhookId": "bc4122aa-5c01-489d-a173-99dd915e0212",
      "parameters": {
        "text": "={{ '🎉 新規参加者登録\n名前: ' + $('Typeform Registration Form').first().json.name + '\nメール: ' + $('Typeform Registration Form').first().json.email + '\nイベント: ' + $('Workflow Configuration').first().json.eventName }}",
        "select": "channel",
        "channelId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('Workflow Configuration').first().json.organizerSlackChannel }}"
        },
        "otherOptions": {},
        "authentication": "oAuth2"
      },
      "credentials": {
        "slackOAuth2Api": {
          "id": "M63jLDIkcZG3nnmS",
          "name": "Slack account 2"
        }
      },
      "typeVersion": 2.3
    },
    {
      "id": "657ee013-6bca-4659-be15-1470fccb5b7f",
      "name": "Vérification Quotidienne des Rappels",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        224
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 9
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "f4f8d33b-3f41-42d5-99f1-3c721bb1af0d",
      "name": "Obtenir les Événements à Venir",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        224
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": false
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "succeeded",
              "lookupColumn": "Payment Status"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "<__PLACEHOLDER_VALUE__Sheet Name (e.g., Participants)__>"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "<__PLACEHOLDER_VALUE__Google Sheets Document ID (same as registration)__>"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "fwevXXzMkUJJc2Ue",
          "name": "Google Sheets account 13"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "86f23720-e55e-492e-87ba-3b4a961565d7",
      "name": "Calculer la Date de Rappel",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        448,
        224
      ],
      "parameters": {
        "options": {},
        "duration": "={{ $('Workflow Configuration').first().json.reminderDaysBefore }}",
        "magnitude": "={{ $json['Event Date'] }}",
        "operation": "subtractFromDate"
      },
      "typeVersion": 2
    },
    {
      "id": "feb98889-9ac8-41cb-bbb1-ef6a26eb3b76",
      "name": "Vérifier si un Rappel est Nécessaire",
      "type": "n8n-nodes-base.if",
      "position": [
        672,
        224
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "id-1",
              "operator": {
                "type": "string",
                "operation": "equals"
              },
              "leftValue": "={{ $now.toFormat('yyyy-MM-dd') }}",
              "rightValue": "={{ $json.output }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "07b2d002-cb41-4228-b46f-fada104e2bf1",
      "name": "Envoyer l'E-mail de Rappel",
      "type": "n8n-nodes-base.gmail",
      "position": [
        1392,
        256
      ],
      "webhookId": "696b628c-3be0-432e-93e3-67c9e0c2ab34",
      "parameters": {
        "sendTo": "={{ $json.Email }}",
        "message": "=<h2>イベントリマインダー</h2><p>{{ $json.Name }} 様</p><p>{{ $json['Event Name'] }} の開催が近づいてまいりました。</p><p><strong>イベント詳細:</strong></p><ul><li>日時: {{ $json['Event Date'] }} {{ $('Workflow Configuration').first().json.eventTime }}</li><li>場所: {{ $('Workflow Configuration').first().json.eventLocation }}</li></ul><p>お忘れなくご参加ください。</p>",
        "options": {},
        "subject": "={{ 'リマインダー: ' + $json['Event Name'] + ' が間もなく開催されます' }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "jVcyBJ7jBcuc69EM",
          "name": "Gmail account 3"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "b71cafb3-d90f-4817-a9b5-6f48bd3110da",
      "name": "Vérification Quotidienne du Suivi",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        0,
        448
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 10
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "ac113bc3-20d2-455f-b042-de09ad00c333",
      "name": "Obtenir les Événements Passés",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        448
      ],
      "parameters": {
        "options": {
          "returnFirstMatch": false
        },
        "filtersUI": {
          "values": [
            {
              "lookupValue": "succeeded",
              "lookupColumn": "Payment Status"
            },
            {
              "lookupColumn": "Follow-up Sent"
            }
          ]
        },
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "<__PLACEHOLDER_VALUE__Sheet Name (e.g., Participants)__>"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "<__PLACEHOLDER_VALUE__Google Sheets Document ID (same as registration)__>"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "fwevXXzMkUJJc2Ue",
          "name": "Google Sheets account 13"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "238e21d8-5ef5-4f41-8c24-969b0db3f66f",
      "name": "Calculer la Date de Suivi",
      "type": "n8n-nodes-base.dateTime",
      "position": [
        448,
        448
      ],
      "parameters": {
        "options": {},
        "duration": "={{ $('Workflow Configuration').first().json.followupDaysAfter }}",
        "magnitude": "={{ $json['Event Date'] }}",
        "operation": "addToDate"
      },
      "typeVersion": 2
    },
    {
      "id": "ac0142fc-af2f-4e01-8090-303f02b3fca0",
      "name": "Vérifier si un Suivi est Nécessaire",
      "type": "n8n-nodes-base.if",
      "position": [
        672,
        448
      ],
      "parameters": {
        "options": {},
        "conditions": {
          "options": {
            "leftValue": "",
            "caseSensitive": true,
            "typeValidation": "strict"
          },
          "combinator": "and",
          "conditions": [
            {
              "id": "id-1",
              "operator": {
                "type": "string",
                "operation": "gte"
              },
              "leftValue": "={{ $now.toFormat('yyyy-MM-dd') }}",
              "rightValue": "={{ $json.output }}"
            }
          ]
        }
      },
      "typeVersion": 2.2
    },
    {
      "id": "9f776c37-6551-4f18-a046-c3dc59a53fe9",
      "name": "Envoyer Remerciements et Questionnaire",
      "type": "n8n-nodes-base.gmail",
      "position": [
        912,
        624
      ],
      "webhookId": "0414943d-a2c0-442c-abc2-3165206f299e",
      "parameters": {
        "sendTo": "={{ $json.Email }}",
        "message": "=<h2>ご参加ありがとうございました</h2><p>{{ $json.Name }} 様</p><p>{{ $json['Event Name'] }} へのご参加、誠にありがとうございました。</p><p>今後のイベント改善のため、簡単なアンケートにご協力いただけますと幸いです。</p><p><a href=\"<__PLACEHOLDER_VALUE__Survey URL__>\">アンケートに回答する</a></p><p>またのご参加をお待ちしております。</p>",
        "options": {},
        "subject": "={{ 'ありがとうございました: ' + $json['Event Name'] }}"
      },
      "credentials": {
        "gmailOAuth2": {
          "id": "jVcyBJ7jBcuc69EM",
          "name": "Gmail account 3"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "22af0070-2118-4523-841c-533531700257",
      "name": "Mettre à Jour le Statut du Suivi",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        1120,
        624
      ],
      "parameters": {
        "columns": {
          "value": {
            "Follow-up Date": "={{ $now.toISO() }}",
            "Follow-up Sent": "Yes"
          },
          "schema": [
            {
              "id": "Email",
              "required": false,
              "displayName": "Email",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Follow-up Sent",
              "required": false,
              "displayName": "Follow-up Sent",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Follow-up Date",
              "required": false,
              "displayName": "Follow-up Date",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "defineBelow",
          "matchingColumns": [
            "Email"
          ]
        },
        "options": {},
        "operation": "update",
        "sheetName": {
          "__rl": true,
          "mode": "name",
          "value": "<__PLACEHOLDER_VALUE__Sheet Name (e.g., Participants)__>"
        },
        "documentId": {
          "__rl": true,
          "mode": "id",
          "value": "<__PLACEHOLDER_VALUE__Google Sheets Document ID (same as registration)__>"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "fwevXXzMkUJJc2Ue",
          "name": "Google Sheets account 13"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "42f7eaec-aa5a-4ee2-8d79-70bbbf8a73b0",
      "name": "Note Adhésive",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1744,
        -416
      ],
      "parameters": {
        "width": 944,
        "height": 1504,
        "content": "## Event Participant Management and Automated Follow-up System\n**\n### Who is this for?\n\nThis template is ideal for event organizers, community managers, and businesses that host workshops, webinars, conferences, or any event requiring participant registration and communication.\n\n### How it works\n\nThe workflow is divided into three main parts:\n\n1.  **Registration and Onboarding:**\n    *   When a new participant registers via a Typeform, their details are immediately added to a Google Sheet.\n    *   Payment is processed via Stripe.\n    *   Upon successful payment, a confirmation email is sent to the participant, and the event is added to their Google Calendar.\n    *   The organizer receives a Slack notification about the new registration.\n\n2.  **Event Reminders:**\n    *   A daily scheduled trigger checks the Google Sheet for upcoming events.\n    *   It calculates if an event is within the specified reminder period (e.g., 3 days before).\n    *   If a reminder is needed, an email is automatically sent to the participant.\n\n3.  **Post-Event Follow-up:**\n    *   Another daily scheduled trigger checks for past events.\n    *   It calculates if an event is due for a follow-up (e.g., 2 days after).\n    *   A thank-you email, including a survey link, is sent to participants.\n    *   The participant's status in the Google Sheet is updated to mark the follow-up as sent.\n\n### How to set it up\n\n1.  **Typeform Registration Form:** Replace `<__PLACEHOLDER_VALUE__Typeform Form ID__>` with your actual Typeform ID.\n2.  **Workflow Configuration:** Fill in the placeholder values for `Event Name`, `Event Date`, `Event Time`, `Event Location`, `Participation Fee Amount`, and `Slack Channel ID`.\n3.  **Google Sheets:**\n    *   Replace `<__PLACEHOLDER_VALUE__Google Sheets Document ID__>` and `<__PLACEHOLDER_VALUE__Sheet Name (e.g., Participants)__>` with your Google Sheet details. Ensure your sheet has columns for \"Name\", \"Email\", \"Phone\", \"Registration Date\", \"Event Name\", \"Event Date\", \"Payment Status\", \"Follow-up Sent\", and \"Follow-up Date\".\n    *   You will need to set up Google Sheets OAuth2 API credentials.\n4.  **Stripe (Process Payment):** Replace `<__PLACEHOLDER_VALUE__Customer ID__>` and `<__PLACEHOLDER_VALUE__Source ID__>` with your Stripe customer and source IDs. You will need Stripe API credentials.\n5.  **Gmail (Send Confirmation Email, Send Reminder Email, Send Thank You & Survey):** You will need to set up Gmail OAuth2 credentials.\n6.  **Google Calendar (Add to Calendar):** You will need to set up Google Calendar OAuth2 API credentials.\n7.  **Slack (Notify Organizer):** Replace `<__PLACEHOLDER_VALUE__Slack Channel ID__>` (if not already set in Workflow Configuration) and set up Slack OAuth2 API credentials.\n8.  **Survey URL (Send Thank You & Survey):** Replace `<__PLACEHOLDER_VALUE__Survey URL__>` with the link to your post-event survey.\n\n### Requirements\n\n*   Typeform account and a registration form.\n*   Google Sheet for participant management.\n*   Stripe account for payment processing.\n*   Gmail account for sending emails.\n*   Google Calendar for event scheduling.\n*   Slack account for organizer notifications.\n*   n8n credentials for Google Sheets, Stripe, Gmail, Google Calendar, and Slack.\n\n### How to customize the workflow\n\n*   **Reminder/Follow-up Timing:** Adjust the `reminderDaysBefore` and `followupDaysAfter` values in the \"Workflow Configuration\" node to change when reminder and follow-up emails are sent.\n*   **Email Content:** Modify the HTML content in the \"Send Confirmation Email\", \"Send Reminder Email\", and \"Send Thank You & Survey\" nodes to match your branding and messaging.\n*   **Payment Currency:** Change the `currency` in the \"Process Payment\" node if your event uses a different currency.\n*   **Additional Data:** Extend the Google Sheets nodes to capture more participant information from Typeform if needed.\n*   **Integration:** Easily integrate with other services by adding more nodes, for example, a CRM to add new participants as leads.\n`"
      },
      "typeVersion": 1
    },
    {
      "id": "63c03b4f-0fd4-44e7-b220-f38b1edd266f",
      "name": "Note Adhésive1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -80,
        -192
      ],
      "parameters": {
        "color": 3,
        "width": 640,
        "height": 784,
        "content": "## Registration and Onboarding\n 　*   When a new participant registers via a Typeform, their details are immediately added to a Google Sheet.\n    *   Payment is processed via Stripe.\n    *   Upon successful payment, a confirmation email is sent to the participant, and the event is added to their Google Calendar.\n    *   The organizer receives a Slack notification about the new registration."
      },
      "typeVersion": 1
    },
    {
      "id": "a6e75768-514e-498a-9f45-2ea5f9bfdede",
      "name": "Note Adhésive2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        864,
        432
      ],
      "parameters": {
        "color": 4,
        "width": 448,
        "height": 368,
        "content": "## Post-Event Follow-up \n 　*  Another daily scheduled trigger checks for past events.\n    *   It calculates if an event is due for a follow-up (e.g., 2 days after).\n    *   A thank-you email, including a survey link, is sent to participants.\n    *   The participant's status in the Google Sheet is updated to mark the follow-up as sent.\n"
      },
      "typeVersion": 1
    },
    {
      "id": "4f61bb8e-5bff-4dbd-abbc-0b5ef624bc6f",
      "name": "Note Adhésive3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1312,
        64
      ],
      "parameters": {
        "color": 6,
        "width": 368,
        "height": 336,
        "content": "## Event Reminders \n**    *   A daily scheduled trigger checks the Google Sheet for upcoming events.\n    *   It calculates if an event is within the specified reminder period (e.g., 3 days before).\n    *   If a reminder is needed, an email is automatically sent to the participant."
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "04d493c7-e7fb-4308-a629-c24c028753d6",
  "connections": {
    "e63d3572-bc39-4a7a-aa8c-2840ccc46c18": {
      "main": [
        [
          {
            "node": "b5c019f2-6e53-4348-adbf-1962574e9568",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac113bc3-20d2-455f-b042-de09ad00c333": {
      "main": [
        [
          {
            "node": "238e21d8-5ef5-4f41-8c24-969b0db3f66f",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "0847f022-be9a-4137-95cb-291f6f1608e9": {
      "main": [
        [
          {
            "node": "5d2c0d4e-5f4e-4659-9467-575667f47c0b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f4f8d33b-3f41-42d5-99f1-3c721bb1af0d": {
      "main": [
        [
          {
            "node": "86f23720-e55e-492e-87ba-3b4a961565d7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5d2c0d4e-5f4e-4659-9467-575667f47c0b": {
      "main": [
        [
          {
            "node": "e2462463-af2a-445c-b526-efcce51b9b18",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "657ee013-6bca-4659-be15-1470fccb5b7f": {
      "main": [
        [
          {
            "node": "f4f8d33b-3f41-42d5-99f1-3c721bb1af0d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b71cafb3-d90f-4817-a9b5-6f48bd3110da": {
      "main": [
        [
          {
            "node": "ac113bc3-20d2-455f-b042-de09ad00c333",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "b4c828ad-aae3-4131-9383-165702e353e4": {
      "main": [
        [
          {
            "node": "d2e4b2da-73e2-485c-82c7-1f41d6b9a4f4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d2e4b2da-73e2-485c-82c7-1f41d6b9a4f4": {
      "main": [
        [
          {
            "node": "0847f022-be9a-4137-95cb-291f6f1608e9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "86f23720-e55e-492e-87ba-3b4a961565d7": {
      "main": [
        [
          {
            "node": "feb98889-9ac8-41cb-bbb1-ef6a26eb3b76",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "e2462463-af2a-445c-b526-efcce51b9b18": {
      "main": [
        [
          {
            "node": "e63d3572-bc39-4a7a-aa8c-2840ccc46c18",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "9f776c37-6551-4f18-a046-c3dc59a53fe9": {
      "main": [
        [
          {
            "node": "22af0070-2118-4523-841c-533531700257",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "238e21d8-5ef5-4f41-8c24-969b0db3f66f": {
      "main": [
        [
          {
            "node": "ac0142fc-af2f-4e01-8090-303f02b3fca0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "feb98889-9ac8-41cb-bbb1-ef6a26eb3b76": {
      "main": [
        [
          {
            "node": "07b2d002-cb41-4228-b46f-fada104e2bf1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ac0142fc-af2f-4e01-8090-303f02b3fca0": {
      "main": [
        [
          {
            "node": "9f776c37-6551-4f18-a046-c3dc59a53fe9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "7c944a05-dc18-4966-875e-f101544e3597": {
      "main": [
        [
          {
            "node": "b4c828ad-aae3-4131-9383-165702e353e4",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}