{ "name": "Mise à jour Besoins Urgents - Vaylats", "modules": [ { "id": "google-sheets-watch", "name": "Surveiller les modifications - Vaylats", "app": "google-sheets", "config": { "connection": { "id": "votre_connexion_google", "name": "Votre compte Google" }, "sheetId": "ID_DU_SHEET_VAYLATS", "worksheet": "Feuille1", "watch": "rows", "range": "A2:D100", "trigger": "onChange" } }, { "id": "filter-vert", "name": "Filtrer les postes disponibles (Vert)", "app": "built-in", "type": "filter", "config": { "conditions": [ { "left": "{{2}}", "operator": "contains", "right": "🟢" }, { "operator": "OR", "left": "{{3}}", "operator": "contains", "right": "🟢" } ] } }, { "id": "count-vert", "name": "Compter les postes Vert par ligne", "app": "built-in", "type": "setVariable", "config": { "variableName": "countVert", "value": "{{if(contains(2; '🟢'); 1; 0) + if(contains(3; '🟢'); 1; 0)}}" } }, { "id": "format-text", "name": "Formater le texte pour Jimdo", "app": "built-in", "type": "textAggregator", "config": { "text": "📌 Besoins urgents d'hospitaliers (Mise à jour : {{now.format('DD/MM/YYYY')}})\n\n🏠 Vaylats\n{{#each items}}- {{1}} : {{countVert}} poste(s) disponible(s){{#if 4}} | {{4}}{{/if}}\n{{/each}}" } }, { "id": "send-email", "name": "Envoyer un email avec les besoins urgents", "app": "gmail", "config": { "connection": { "id": "votre_connexion_gmail", "name": "Votre compte Gmail" }, "to": "[email protected]", "subject": "[Mathéo] Mise à jour des besoins urgents - Vaylats", "body": "{{format-text.text}}" } } ] }