Simplifiez la demande, l’approbation et la planification des congés ou absences. Intégrez vos outils RH, notifiez automatiquement les responsables et synchronisez les plannings pour limiter les oublis et garantir la continuité de service.
Simplifiez la demande, l’approbation et la planification des congés ou absences. Intégrez vos outils RH, notifiez automatiquement les responsables et synchronisez les plannings pour limiter les oublis et garantir la continuité de service.
{
"id": "SJrqDqTBIAyaZQkq",
"meta": {
"instanceId": "73d9d5380db181d01f4e26492c771d4cb5c4d6d109f18e2621cf49cac4c50763",
"templateCredsSetupCompleted": true
},
"name": "UTM Link Creator & QR Code Generator with Scheduled Google Analytics Reports",
"tags": [],
"nodes": [
{
"id": "5efbd956-51b6-4f94-aebc-07e3e691f7eb",
"name": "OpenAI Chat Model1",
"type": "@n8n/n8n-nodes-langchain.lmChatOpenAi",
"position": [
-180,
480
],
"parameters": {
"model": {
"__rl": true,
"mode": "list",
"value": "gpt-4o-mini"
},
"options": {}
},
"credentials": {
"openAiApi": {
"id": "95QGJD3XSz0piaNU",
"name": "OpenAi account"
}
},
"typeVersion": 1.2
},
{
"id": "a1acd323-ed07-41b4-a51e-614afe361893",
"name": "Window Buffer Memory",
"type": "@n8n/n8n-nodes-langchain.memoryBufferWindow",
"position": [
0,
480
],
"parameters": {
"sessionKey": "={{ $json.timestamp }}",
"sessionIdType": "customKey",
"contextWindowLength": 200
},
"typeVersion": 1.3
},
{
"id": "c3c2b5fa-c294-4306-a050-dccd592477fa",
"name": "Google Analytics",
"type": "n8n-nodes-base.googleAnalyticsTool",
"position": [
160,
480
],
"parameters": {
"metricsGA4": {
"metricValues": [
{
"listName": "sessions"
}
]
},
"propertyId": {
"__rl": true,
"mode": "list",
"value": "404306108",
"cachedResultUrl": "https://analytics.google.com/analytics/web/#/p404306108/",
"cachedResultName": "East Coast Concrete Coating"
},
"dimensionsGA4": {
"dimensionValues": [
{},
{
"listName": "sourceMedium"
}
]
},
"additionalFields": {}
},
"credentials": {
"googleAnalyticsOAuth2": {
"id": "sVZ61SpNfC2D1Z7V",
"name": "Google Analytics account"
}
},
"typeVersion": 2
},
{
"id": "cbc7b539-2fa6-493b-a66c-13db8d8d420c",
"name": "Create UTM Link & Send To Database",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-440,
-80
],
"parameters": {},
"typeVersion": 1
},
{
"id": "5358f2cc-bdb0-4e9b-a6b9-93418f83db02",
"name": "Set UTM Parameters For Link",
"type": "n8n-nodes-base.set",
"position": [
-220,
-80
],
"parameters": {
"options": {},
"assignments": {
"assignments": [
{
"id": "28d0a36d-5b03-4b74-9941-ef0e1aab86bf",
"name": "website_url",
"type": "string",
"value": "https://ecconcretecoating.com/"
},
{
"id": "1a2ee174-4684-4246-813f-b67285af48b8",
"name": "campaign_id",
"type": "string",
"value": "12246"
},
{
"id": "e15a846d-6e37-4fbf-a9f4-b3fce3441295",
"name": "campaign_source",
"type": "string",
"value": "google"
},
{
"id": "f15e2bb1-08a6-48c4-8458-b753864e9364",
"name": "campaign_medium",
"type": "string",
"value": "display"
},
{
"id": "548900ab-aa2c-498f-bbd9-a787306e72db",
"name": "campaign_name",
"type": "string",
"value": "summerfun"
},
{
"id": "fd8d1bd4-a75d-4c49-b795-8fda7c377b66",
"name": "campaign_term",
"type": "string",
"value": "conretecoating"
}
]
}
},
"typeVersion": 3.4
},
{
"id": "45daf73a-01c2-40ab-8546-7fdd489e2a1c",
"name": "Create UTM Link With Parameters",
"type": "n8n-nodes-base.code",
"position": [
40,
-140
],
"parameters": {
"jsCode": "const items = $input.all();nconst updatedItems = items.map((item) => {n const utmUrl = `${item?.json?.website_url}?utm_source=${item?.json?.campaign_source}&utm_medium=${item?.json?.campaign_medium}&utm_campaign=${item?.json?.campaign_name}&utm_term=${item?.json?.campaign_term}&utm_content=${item?.json?.campaign_id}`;n item.json.utmUrl = utmUrl;n return item;n});nreturn updatedItems;n"
},
"typeVersion": 2
},
{
"id": "a621984d-eea5-464d-9be3-e620e779abd5",
"name": "Submit UTM Link To Database",
"type": "n8n-nodes-base.airtable",
"position": [
280,
-200
],
"parameters": {
"base": {
"__rl": true,
"mode": "list",
"value": "appIXd8a8JeB9bPaL",
"cachedResultUrl": "https://airtable.com/appIXd8a8JeB9bPaL",
"cachedResultName": "Untitled Base"
},
"table": {
"__rl": true,
"mode": "list",
"value": "tblXyFxXMHraieGCa",
"cachedResultUrl": "https://airtable.com/appIXd8a8JeB9bPaL/tblXyFxXMHraieGCa",
"cachedResultName": "UTM_URL"
},
"columns": {
"value": {
"URL": "={{ $json.utmUrl }}"
},
"schema": [
{
"id": "id",
"type": "string",
"display": true,
"removed": false,
"readOnly": true,
"required": false,
"displayName": "id",
"defaultMatch": true
},
{
"id": "URL",
"type": "string",
"display": true,
"removed": false,
"readOnly": false,
"required": false,
"displayName": "URL",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "defineBelow",
"matchingColumns": [
"id"
],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "upsert"
},
"credentials": {
"airtableTokenApi": {
"id": "0ApVmNsLu7aFzQD6",
"name": "Airtable Personal Access Token account"
}
},
"typeVersion": 2.1
},
{
"id": "19074462-d719-4fdf-bc59-d6b2ecd1ce20",
"name": "Create QR Code With Submitted QR Link",
"type": "n8n-nodes-base.httpRequest",
"position": [
280,
-20
],
"parameters": {
"url": "=https://quickchart.io/qr?text={{ $json.utmUrl }}&size=300&margin=10&ecLevel=H&dark=000000&light=FFFFFFn",
"options": {}
},
"typeVersion": 4.2
},
{
"id": "a8c22bb2-f8eb-4e5f-b288-9c25e0aeb648",
"name": "Schedule Google Analytics Report To Marketing Manager",
"type": "n8n-nodes-base.scheduleTrigger",
"position": [
-460,
280
],
"parameters": {
"rule": {
"interval": [
{}
]
}
},
"typeVersion": 1.2
},
{
"id": "268c110c-2b7c-4450-b5b0-5d5326eac17f",
"name": "Google Analytics Data Analysis Agent",
"type": "@n8n/n8n-nodes-langchain.agent",
"position": [
-100,
280
],
"parameters": {
"text": "={{ $json.timestamp }}",
"options": {
"systemMessage": ""You are an advanced data analytics AI specializing in executive reporting. Your task is to analyze the provided dataset and generate a structured executive summary that highlights key insights, trends, and actionable takeaways. Structure your summary in the following format:nnOverview u2013 Briefly describe the dataset and its significance.nKey Performance Indicators (KPIs) u2013 Highlight the most important metrics and compare them to previous periods if applicable.nTrends & Insights u2013 Identify patterns, growth areas, declines, and anomalies.nOpportunities & Recommendations u2013 Provide strategic recommendations based on the insights.nConclusion u2013 Summarize the key takeaways concisely.n*Ensure the tone is professional, clear, and tailored for executives who require quick, data-driven insights without unnecessary details.""
},
"promptType": "define"
},
"typeVersion": 1.7
},
{
"id": "1b012731-e67b-4e0d-95b7-a7f587754a05",
"name": "Send Summary Report To Marketing Manager",
"type": "n8n-nodes-base.gmail",
"position": [
300,
280
],
"webhookId": "a9b88615-c7e2-4b56-891a-98f4d6b34220",
"parameters": {
"sendTo": "john@marketingcanopy.com",
"message": "={{ $json.output }}",
"options": {},
"subject": "Google Analytics Metrics Summary Report"
},
"credentials": {
"gmailOAuth2": {
"id": "pIXP1ZseBP4Z5CCp",
"name": "Gmail account"
}
},
"typeVersion": 2.1
},
{
"id": "9da758e1-8aed-446b-a074-8fee5405583f",
"name": "Sticky Note",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
-280
],
"parameters": {
"width": 500,
"height": 400,
"content": "Create a marketing link with UTM parameters. Easily store in database and have QR code created and ready as well.nnType in requirements:nwebsite URLncampaign idncampaign sourcencampaign mediumncampaign namencampaign termnn"
},
"typeVersion": 1
},
{
"id": "92f5df8d-88ca-4b58-b544-c0b2d3578a73",
"name": "Sticky Note1",
"type": "n8n-nodes-base.stickyNote",
"position": [
0,
-380
],
"parameters": {
"color": 4,
"width": 580,
"height": 540,
"content": "Code node creates the URL with UTM parameters. nnIt then sends to your Airtable database to store for records. It also creates a QR code with the embedded link to be used for materials. nnSample Airtable Setup:n-Website Link UTM column"
},
"typeVersion": 1
},
{
"id": "408af10c-4b0e-4d94-b02d-5d887fb150c3",
"name": "Sticky Note2",
"type": "n8n-nodes-base.stickyNote",
"position": [
-540,
180
],
"parameters": {
"color": 5,
"width": 1340,
"height": 460,
"content": "Schedule a Google Analytics Reports with Medium/Source to track UTM link performance. Update the reporting fields to fit your business needs. You can track traffic, conversions and other engagement metrics.nn*Sample Google Report Metrics: Sessions. Update metrics as needed."
},
"typeVersion": 1
}
],
"active": false,
"pinData": {},
"settings": {
"executionOrder": "v1"
},
"versionId": "6e6641fd-a59c-49e9-af43-1b2b9b458544",
"connections": {
"Google Analytics": {
"ai_tool": [
[
{
"node": "Google Analytics Data Analysis Agent",
"type": "ai_tool",
"index": 0
}
]
]
},
"OpenAI Chat Model1": {
"ai_languageModel": [
[
{
"node": "Google Analytics Data Analysis Agent",
"type": "ai_languageModel",
"index": 0
}
]
]
},
"Window Buffer Memory": {
"ai_memory": [
[
{
"node": "Google Analytics Data Analysis Agent",
"type": "ai_memory",
"index": 0
}
]
]
},
"Set UTM Parameters For Link": {
"main": [
[
{
"node": "Create UTM Link With Parameters",
"type": "main",
"index": 0
}
]
]
},
"Submit UTM Link To Database": {
"main": [
[]
]
},
"Create UTM Link With Parameters": {
"main": [
[
{
"node": "Create QR Code With Submitted QR Link",
"type": "main",
"index": 0
},
{
"node": "Submit UTM Link To Database",
"type": "main",
"index": 0
}
]
]
},
"Create UTM Link & Send To Database": {
"main": [
[
{
"node": "Set UTM Parameters For Link",
"type": "main",
"index": 0
}
]
]
},
"Google Analytics Data Analysis Agent": {
"main": [
[
{
"node": "Send Summary Report To Marketing Manager",
"type": "main",
"index": 0
}
]
]
},
"Send Summary Report To Marketing Manager": {
"main": [
[]
]
},
"Schedule Google Analytics Report To Marketing Manager": {
"main": [
[
{
"node": "Google Analytics Data Analysis Agent",
"type": "main",
"index": 0
}
]
]
}
}
}