Hi !
Here it is :
"meta": {
"instanceId": "acaf48b5e5942fb5b7f5f92a6eea286196e1eb2dacd59a5a48c1fd87412e3081"
},
"nodes": [
{
"parameters": {
"propertyId": {
"__rl": true,
"value": "*my_analytics_url*",
"mode": "url"
},
"dateRange": "yesterday",
"metricsGA4": {
"metricValues": [
{},
{
"listName": "active28DayUsers"
}
]
},
"dimensionsGA4": {
"dimensionValues": [
{}
]
},
"returnAll": true,
"additionalFields": {}
},
"id": "373add59-3985-4519-84cb-9ef3fddb65e8",
"name": "Récupérer le nombre de visiteurs de la veille",
"type": "n8n-nodes-base.googleAnalytics",
"typeVersion": 2,
"position": [
260,
620
],
"alwaysOutputData": true,
"credentials": {
"googleAnalyticsOAuth2": {
"id": "*my_analytics_id*",
"name": "Google Analytics account"
}
}
},
{
"parameters": {
"conditions": {
"options": {
"caseSensitive": true,
"leftValue": "",
"typeValidation": "loose",
"version": 2
},
"conditions": [
{
"id": "66d003d7-690d-4d37-a709-77fcd442b531",
"leftValue": "={{ $json.totalUsers }}",
"rightValue": "=1",
"operator": {
"type": "string",
"operation": "equals",
"name": "filter.operator.equals"
}
}
],
"combinator": "and"
},
"looseTypeValidation": true,
"options": {}
},
"id": "8ccbcce5-0a74-41e8-98c5-eb1c6c084ab6",
"name": "Condition date + nb visiteurs",
"type": "n8n-nodes-base.if",
"typeVersion": 2.2,
"position": [
500,
620
]
},
{
"parameters": {
"sendTo": "[email protected]",
"subject": "=Site Dury Artisans Bois : Analytics détecte une seule visite ({{ $json.formattedDate }})",
"message": "=Bonjour,<br><br>\n\nCe message est généré automatiquement suite à une analyse du compte Google Analytics pour le site https://www.dury-artisan-bois.fr/. <br><br>\n\nNous avons remarqué qu'une seule visite a été détectée sur le site le {{ $json.formattedDate }}. Veuillez vérifier que le lien avec le site s'effectue toujours.<br><br>\n\n<hr>\n<br>\nVotre assistant N8N / Google Analytics",
"options": {
"appendAttribution": false,
"senderName": "RV - N8N Automatisation"
}
},
"id": "301bc796-6605-441c-97f3-a79e6c314935",
"name": "Envoie un mail",
"type": "n8n-nodes-base.gmail",
"typeVersion": 2.1,
"position": [
1000,
620
],
"webhookId": "faa8b371-3941-4072-bb53-d8ed23d45bc9",
"credentials": {
"gmailOAuth2": {
"id": "*my_gmail_credentials*",
"name": "Gmail account"
}
}
},
{
"parameters": {
"jsCode": "// Loop over input items and add a new field called 'formattedDate' to the JSON of each one\nfor (const item of $input.all()) {\n const rawDate = item.json.date; // Remplace 'dateField' par le nom du champ contenant la date\n \n if (rawDate && rawDate.length === 8) {\n const year = rawDate.substring(0, 4);\n const month = rawDate.substring(4, 6);\n const day = rawDate.substring(6, 8);\n \n // Reformater la date au format DD/MM/YYYY\n item.json.formattedDate = `${day}/${month}/${year}`;\n } else {\n item.json.formattedDate = 'Invalid date'; // Gérer les cas où le format est incorrect\n }\n}\n\nreturn $input.all();\n"
},
"id": "98548655-e64b-4608-bde2-4954ff774b3b",
"name": "Code",
"type": "n8n-nodes-base.code",
"typeVersion": 2,
"position": [
500,
480
]
},
{
"parameters": {
"rule": {
"interval": [
{
"triggerAtHour": 9
}
]
}
},
"id": "dde4f737-caaa-432d-b45d-31a786c05964",
"name": "Lancement à 8h du matin",
"type": "n8n-nodes-base.scheduleTrigger",
"typeVersion": 1.2,
"position": [
0,
620
]
},
{
"parameters": {
"mode": "combine",
"advanced": true,
"mergeByFields": {
"values": [
{
"field1": "date",
"field2": "date"
}
]
},
"options": {}
},
"id": "61962a85-16c0-4d9d-9ca2-39c506603d56",
"name": "Merge",
"type": "n8n-nodes-base.merge",
"typeVersion": 3,
"position": [
780,
620
]
}
],
"connections": {
"Récupérer le nombre de visiteurs de la veille": {
"main": [
[
{
"node": "Code",
"type": "main",
"index": 0
},
{
"node": "Condition date + nb visiteurs",
"type": "main",
"index": 0
}
]
]
},
"Condition date + nb visiteurs": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 1
}
]
]
},
"Code": {
"main": [
[
{
"node": "Merge",
"type": "main",
"index": 0
}
]
]
},
"Lancement à 8h du matin": {
"main": [
[
{
"node": "Récupérer le nombre de visiteurs de la veille",
"type": "main",
"index": 0
}
]
]
},
"Merge": {
"main": [
[
{
"node": "Envoie un mail",
"type": "main",
"index": 0
}
]
]
}
},
"pinData": {}
}
