Google Analytics : Rapport hebdomadaire

Intermédiaire

Ceci est unAI, Marketingworkflow d'automatisation du domainecontenant 14 nœuds.Utilise principalement des nœuds comme Set, Code, Telegram, EmailSend, Summarize, combinant la technologie d'intelligence artificielle pour une automatisation intelligente. Utiliser l'IA pour créer des rapports de données Google Analytics et les envoyer par e-mail et à Telegram

Prérequis
  • Token Bot Telegram
  • Clé API OpenAI
Aperçu du workflow
Visualisation des connexions entre les nœuds, avec support du zoom et du déplacement
Exporter le workflow
Copiez la configuration JSON suivante dans n8n pour importer et utiliser ce workflow
{
  "id": "AAjX1BuwhyXpo8xP",
  "meta": {
    "instanceId": "558d88703fb65b2d0e44613bc35916258b0f0bf983c5d4730c00c424b77ca36a"
  },
  "name": "Google Analytics: Weekly Report",
  "tags": [],
  "nodes": [
    {
      "id": "91ba5982-e226-4f0b-af0d-8c9a44b08279",
      "name": "Déclencheur programmé",
      "type": "n8n-nodes-base.scheduleTrigger",
      "position": [
        -1740,
        300
      ],
      "parameters": {
        "rule": {
          "interval": [
            {
              "field": "weeks",
              "triggerAtDay": [
                1
              ],
              "triggerAtHour": 7
            }
          ]
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "62c38eaf-2222-4d22-8589-677f36bce10d",
      "name": "Google Analytics Letzte 7 Tage",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        -1540,
        300
      ],
      "parameters": {
        "metricsGA4": {
          "metricValues": [
            {
              "listName": "screenPageViews"
            },
            {},
            {
              "listName": "sessions"
            },
            {
              "listName": "sessionsPerUser"
            },
            {
              "name": "averageSessionDuration",
              "listName": "other"
            },
            {
              "name": "ecommercePurchases",
              "listName": "other"
            },
            {
              "name": "averagePurchaseRevenue",
              "listName": "other"
            },
            {
              "name": "purchaseRevenue",
              "listName": "other"
            }
          ]
        },
        "propertyId": {
          "__rl": true,
          "mode": "list",
          "value": "345060083",
          "cachedResultUrl": "https://analytics.google.com/analytics/web/#/p345060083/",
          "cachedResultName": "https://www.ep-reisen.de  – GA4"
        },
        "dimensionsGA4": {
          "dimensionValues": [
            {}
          ]
        },
        "additionalFields": {}
      },
      "credentials": {
        "googleAnalyticsOAuth2": {
          "id": "onRKXREI8izfGzv0",
          "name": "Google Analytics account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "0a51c2f3-a487-4226-884f-63d4cb2bf4e4",
      "name": "Envoyer un e-mail",
      "type": "n8n-nodes-base.emailSend",
      "position": [
        420,
        80
      ],
      "parameters": {
        "html": "={{ $json.message.content }}",
        "options": {},
        "subject": "Weekly Report: Google Analytics: Last 7 days",
        "toEmail": "friedemann.schuetz@ep-reisen.de",
        "fromEmail": "friedemann.schuetz@posteo.de"
      },
      "credentials": {
        "smtp": {
          "id": "A71x7hx6lKj7nxp1",
          "name": "SMTP account"
        }
      },
      "typeVersion": 2.1
    },
    {
      "id": "04963783-f455-4983-afea-e94b316d8532",
      "name": "Telegram",
      "type": "n8n-nodes-base.telegram",
      "position": [
        420,
        420
      ],
      "parameters": {
        "text": "={{ $json.message.content }}",
        "chatId": "1810565648",
        "additionalFields": {}
      },
      "credentials": {
        "telegramApi": {
          "id": "0hnyvxyUMN77sBmU",
          "name": "Telegram account"
        }
      },
      "typeVersion": 1.2
    },
    {
      "id": "3b6b4902-15b3-4bbc-8427-c35471a7431b",
      "name": "Traitement pour Telegram",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        60,
        420
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o-mini",
          "cachedResultName": "GPT-4O-MINI"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Convert the following text from HTML to normal text:\n\n{{ $json.message.content }}\n\nPlease format the table so that each metric is a separate paragraph!\n\nExample:\n\nTotal views: xx.xxx\nTotal views previous year: xx,xxx\nDifference: x.xx %\n\nTotal users: xx,xxx\nTotal users previous year: xx,xxx\nDifference: -x.xx %"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "niikB3HA4fT5WAqt",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.7
    },
    {
      "id": "d761980c-0327-4d4e-92aa-d0342b2e249e",
      "name": "Calculateur",
      "type": "@n8n/n8n-nodes-langchain.toolCalculator",
      "position": [
        140,
        300
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "ce7ba356-80bb-4b17-9445-fb535267cdf0",
      "name": "Google Analytics : 7 jours passés de l'année précédente",
      "type": "n8n-nodes-base.googleAnalytics",
      "position": [
        -600,
        300
      ],
      "parameters": {
        "endDate": "={{ $json.endDate }}",
        "dateRange": "custom",
        "startDate": "={{ $json.startDate }}",
        "metricsGA4": {
          "metricValues": [
            {
              "listName": "screenPageViews"
            },
            {},
            {
              "listName": "sessions"
            },
            {
              "listName": "sessionsPerUser"
            },
            {
              "name": "averageSessionDuration",
              "listName": "other"
            },
            {
              "name": "ecommercePurchases",
              "listName": "other"
            },
            {
              "name": "averagePurchaseRevenue",
              "listName": "other"
            },
            {
              "name": "purchaseRevenue",
              "listName": "other"
            }
          ]
        },
        "propertyId": {
          "__rl": true,
          "mode": "list",
          "value": "345060083",
          "cachedResultUrl": "https://analytics.google.com/analytics/web/#/p345060083/",
          "cachedResultName": "https://www.ep-reisen.de  – GA4"
        },
        "dimensionsGA4": {
          "dimensionValues": [
            {}
          ]
        },
        "additionalFields": {}
      },
      "credentials": {
        "googleAnalyticsOAuth2": {
          "id": "onRKXREI8izfGzv0",
          "name": "Google Analytics account"
        }
      },
      "typeVersion": 2
    },
    {
      "id": "d2062aaa-e41b-4405-8470-9e7b4cd77245",
      "name": "Synthétiser les données",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -1080,
        300
      ],
      "parameters": {
        "options": {},
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Aufrufe",
              "aggregation": "sum"
            },
            {
              "field": "Nutzer",
              "aggregation": "sum"
            },
            {
              "field": "Sitzungen",
              "aggregation": "sum"
            },
            {
              "field": "Sitzungen pro Nutzer",
              "aggregation": "average"
            },
            {
              "field": "Sitzungsdauer",
              "aggregation": "average"
            },
            {
              "field": "Käufe",
              "aggregation": "sum"
            },
            {
              "field": "Revenue pro Kauf",
              "aggregation": "average"
            },
            {
              "field": "Revenue",
              "aggregation": "sum"
            },
            {
              "field": "date"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "d1f48d36-9f27-4cda-af53-e6d430d1a8db",
      "name": "Synthétiser les données 1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -220,
        300
      ],
      "parameters": {
        "options": {},
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Aufrufe",
              "aggregation": "sum"
            },
            {
              "field": "Nutzer",
              "aggregation": "sum"
            },
            {
              "field": "Sitzungen",
              "aggregation": "sum"
            },
            {
              "field": "Sitzungen pro Nutzer",
              "aggregation": "average"
            },
            {
              "field": "Sitzungsdauer",
              "aggregation": "average"
            },
            {
              "field": "Käufe",
              "aggregation": "sum"
            },
            {
              "field": "Revenue pro Kauf",
              "aggregation": "average"
            },
            {
              "field": "Revenue",
              "aggregation": "sum"
            },
            {
              "field": "date"
            }
          ]
        }
      },
      "typeVersion": 1
    },
    {
      "id": "5b6a0644-3839-4a62-8ff3-bf866aa4568c",
      "name": "Calcul période équivalente année précédente",
      "type": "n8n-nodes-base.code",
      "position": [
        -840,
        300
      ],
      "parameters": {
        "jsCode": "return {\n  // Berechnung des Startdatums: Vorjahr, gleiche Woche, 7 Tage zurück\n  startDate: (() => {\n    const date = new Date();\n    date.setFullYear(date.getFullYear() - 1); // Zurück ins Vorjahr\n    date.setDate(date.getDate() - 7); // 7 Tage zurück\n    return date.toISOString().split('T')[0];\n  })(),\n  \n  // Berechnung des Enddatums: Vorjahr, heutiges Datum\n  endDate: (() => {\n    const date = new Date();\n    date.setFullYear(date.getFullYear() - 1); // Zurück ins Vorjahr\n    return date.toISOString().split('T')[0];\n  })(),\n};\n"
      },
      "typeVersion": 2
    },
    {
      "id": "ab813532-cbe6-4c41-b20b-7efaa1ae4389",
      "name": "Assigner les données",
      "type": "n8n-nodes-base.set",
      "position": [
        -1300,
        300
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9c2f8b9a-e964-49a0-8837-efb0dfd7bcae",
              "name": "Aufrufe",
              "type": "number",
              "value": "={{ $json.screenPageViews }}"
            },
            {
              "id": "8b524518-1268-4971-b5c9-ae7da09d94f9",
              "name": "Nutzer",
              "type": "number",
              "value": "={{ $json.totalUsers }}"
            },
            {
              "id": "ca7279b9-c643-425f-aa99-cb17146e9994",
              "name": "Sitzungen",
              "type": "number",
              "value": "={{ $json.sessions }}"
            },
            {
              "id": "591288f7-e8cf-445e-872a-5b83f997b825",
              "name": "Sitzungen pro Nutzer",
              "type": "number",
              "value": "={{ $json.sessionsPerUser }}"
            },
            {
              "id": "dc1a43da-3f3a-4dca-bbde-904222d7f693",
              "name": "Sitzungsdauer",
              "type": "number",
              "value": "={{ $json.averageSessionDuration }}"
            },
            {
              "id": "eac0b53e-c452-40b8-92bc-8af8ea349984",
              "name": "=Käufe",
              "type": "number",
              "value": "={{ $json.ecommercePurchases }}"
            },
            {
              "id": "b96439be-189d-4ebe-b49e-d5c31fefe9f0",
              "name": "Revenue pro Kauf",
              "type": "number",
              "value": "={{ $json.averagePurchaseRevenue }}"
            },
            {
              "id": "94835d43-2fc8-49c0-97f0-6f0f8699337a",
              "name": "Revenue",
              "type": "number",
              "value": "={{ $json.purchaseRevenue }}"
            },
            {
              "id": "d70f8138-3b84-4b88-a98f-eb929e1cc29a",
              "name": "date",
              "type": "string",
              "value": "={{ $json.date }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "2454fe8a-005d-46dc-ae22-1044c1b793b7",
      "name": "Assigner les données 1",
      "type": "n8n-nodes-base.set",
      "position": [
        -400,
        300
      ],
      "parameters": {
        "options": {},
        "assignments": {
          "assignments": [
            {
              "id": "9c2f8b9a-e964-49a0-8837-efb0dfd7bcae",
              "name": "Aufrufe",
              "type": "number",
              "value": "={{ $json.screenPageViews }}"
            },
            {
              "id": "8b524518-1268-4971-b5c9-ae7da09d94f9",
              "name": "Nutzer",
              "type": "number",
              "value": "={{ $json.totalUsers }}"
            },
            {
              "id": "ca7279b9-c643-425f-aa99-cb17146e9994",
              "name": "Sitzungen",
              "type": "number",
              "value": "={{ $json.sessions }}"
            },
            {
              "id": "591288f7-e8cf-445e-872a-5b83f997b825",
              "name": "Sitzungen pro Nutzer",
              "type": "number",
              "value": "={{ $json.sessionsPerUser }}"
            },
            {
              "id": "dc1a43da-3f3a-4dca-bbde-904222d7f693",
              "name": "Sitzungsdauer",
              "type": "number",
              "value": "={{ $json.averageSessionDuration }}"
            },
            {
              "id": "eac0b53e-c452-40b8-92bc-8af8ea349984",
              "name": "=Käufe",
              "type": "number",
              "value": "={{ $json.ecommercePurchases }}"
            },
            {
              "id": "b96439be-189d-4ebe-b49e-d5c31fefe9f0",
              "name": "Revenue pro Kauf",
              "type": "number",
              "value": "={{ $json.averagePurchaseRevenue }}"
            },
            {
              "id": "94835d43-2fc8-49c0-97f0-6f0f8699337a",
              "name": "Revenue",
              "type": "number",
              "value": "={{ $json.purchaseRevenue }}"
            },
            {
              "id": "dd8255c6-65b1-41ce-b596-70c09108d6e2",
              "name": "=date",
              "type": "string",
              "value": "={{ $json.date }}"
            }
          ]
        }
      },
      "typeVersion": 3.4
    },
    {
      "id": "0a48cbb0-3d4c-4ac8-8dba-08213f7fc430",
      "name": "Note autocollante",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -2220,
        80
      ],
      "parameters": {
        "width": 440,
        "height": 560,
        "content": "Welcome to my Google Analytics Weekly Report Workflow!\n\nThis workflow has the following sequence:\n\n1. time trigger (e.g. every Monday at 7 a.m.)\n2. retrieval of Google Analytics data from the last 7 days\n3. assignment and summary of the data\n4. retrieval of Google Analytics data from the last 7 days of the previous year\n5. allocation and summary of the data\n6. preparation in tabular form and brief analysis by AI.\n7. sending the report as an email\n8. preparation in short form by AI for Telegram (optional)\n9. sending as Telegram message.\n\nThe following accesses are required for the workflow:\n- Google Analytics (via Google Analytics API): https://docs.n8n.io/integrations/builtin/credentials/google/\n- AI API access (e.g. via OpenAI, Anthropic, Google or Ollama)\n- SMTP access data (for sending the mail)\n- Telegram access data (optional for sending as Telegram message): https://docs.n8n.io/integrations/builtin/credentials/telegram/\n\nYou can contact me via LinkedIn, if you have any questions: https://www.linkedin.com/in/friedemann-schuetz"
      },
      "typeVersion": 1
    },
    {
      "id": "c87bc648-8fe8-4cec-84d4-2742060f9c53",
      "name": "Traitement pour e-mail",
      "type": "@n8n/n8n-nodes-langchain.openAi",
      "position": [
        60,
        80
      ],
      "parameters": {
        "modelId": {
          "__rl": true,
          "mode": "list",
          "value": "gpt-4o",
          "cachedResultName": "GPT-4O"
        },
        "options": {},
        "messages": {
          "values": [
            {
              "content": "=Please analyze the following data and output the results in tabular form:\n\n| Metrics | Last 7 days | Previous year | Percentage change |\n|-------------------------------|---------------|---------|\n| Total page views | {{ $('Summarize Data').item.json.sum_Aufrufe }} | {{ $('Summarize Data1').item.json.sum_Aufrufe }} | Percentage change |\n| total users | {{ $('Summarize Data').item.json.sum_Nutzer }} | {{ $('Summarize Data1').item.json.sum_Nutzer }} | Percentage change |\n| Total sessions | {{ $('Summarize Data').item.json.sum_Sitzungen }} | {{ $('Summarize Data1').item.json.sum_Sitzungen }} | Percentage change |\n| Average sessions/user | {{ $('Summarize Data').item.json.average_Sitzungen_pro_Nutzer }} | {{ $('Summarize Data1').item.json.average_Sitzungen_pro_Nutzer }} | Percentage change |\n| Average session duration | {{ $('Summarize Data').item.json.average_Sitzungsdauer }} | {{ $('Summarize Data1').item.json.average_Sitzungsdauer }} | Percentage change |\n| Total purchases | {{ $('Summarize Data').item.json['sum_Käufe'] }} | {{ $('Summarize Data1').item.json['sum_Käufe'] }} | Percentage change |\n| Average revenue/purchase | {{ $('Summarize Data').item.json.average_Revenue_pro_Kauf }} | {{ $('Summarize Data1').item.json.average_Revenue_pro_Kauf }} | Percentage change |\n| Total revenue | {{ $('Summarize Data').item.json.sum_Revenue }} | {{ $('Summarize Data1').item.json.sum_Revenue }} | Percentage change |\n\nFormat for numbers:\n- Dot (.) for numbers in thousands (e.g. 4,000)\n- Comma (,) for decimal numbers (e.g. 3.4)\n- Conversion of average session duration in minutes instead of seconds\n- Average turnover/purchase and total turnover in €\n\nPlease write a short summary of the analyzed data above the table (in a maximum of 3 sentences!)\n\nPlease format to a sleek and modern HTML format so that the result can be sent as HTML mail!\n\nStructure of the e-mail:\n\n“Hello! Here is the Weekly Report: Google Analytics of the last 7 days!\n[Summary]\n[Table]”"
            }
          ]
        }
      },
      "credentials": {
        "openAiApi": {
          "id": "niikB3HA4fT5WAqt",
          "name": "OpenAi account"
        }
      },
      "typeVersion": 1.7
    }
  ],
  "active": false,
  "pinData": {},
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "556c3292-0d40-4c75-8037-90bacf1b2ccb",
  "connections": {
    "04963783-f455-4983-afea-e94b316d8532": {
      "main": [
        []
      ]
    },
    "d761980c-0327-4d4e-92aa-d0342b2e249e": {
      "ai_tool": [
        [
          {
            "node": "c87bc648-8fe8-4cec-84d4-2742060f9c53",
            "type": "ai_tool",
            "index": 0
          }
        ]
      ]
    },
    "ab813532-cbe6-4c41-b20b-7efaa1ae4389": {
      "main": [
        [
          {
            "node": "d2062aaa-e41b-4405-8470-9e7b4cd77245",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "2454fe8a-005d-46dc-ae22-1044c1b793b7": {
      "main": [
        [
          {
            "node": "d1f48d36-9f27-4cda-af53-e6d430d1a8db",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d2062aaa-e41b-4405-8470-9e7b4cd77245": {
      "main": [
        [
          {
            "node": "5b6a0644-3839-4a62-8ff3-bf866aa4568c",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "d1f48d36-9f27-4cda-af53-e6d430d1a8db": {
      "main": [
        [
          {
            "node": "c87bc648-8fe8-4cec-84d4-2742060f9c53",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "91ba5982-e226-4f0b-af0d-8c9a44b08279": {
      "main": [
        [
          {
            "node": "62c38eaf-2222-4d22-8589-677f36bce10d",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "c87bc648-8fe8-4cec-84d4-2742060f9c53": {
      "main": [
        [
          {
            "node": "0a51c2f3-a487-4226-884f-63d4cb2bf4e4",
            "type": "main",
            "index": 0
          },
          {
            "node": "3b6b4902-15b3-4bbc-8427-c35471a7431b",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "3b6b4902-15b3-4bbc-8427-c35471a7431b": {
      "main": [
        [
          {
            "node": "04963783-f455-4983-afea-e94b316d8532",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "62c38eaf-2222-4d22-8589-677f36bce10d": {
      "main": [
        [
          {
            "node": "ab813532-cbe6-4c41-b20b-7efaa1ae4389",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "5b6a0644-3839-4a62-8ff3-bf866aa4568c": {
      "main": [
        [
          {
            "node": "ce7ba356-80bb-4b17-9445-fb535267cdf0",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "ce7ba356-80bb-4b17-9445-fb535267cdf0": {
      "main": [
        [
          {
            "node": "2454fe8a-005d-46dc-ae22-1044c1b793b7",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Foire aux questions

Comment utiliser ce workflow ?

Copiez le code de configuration JSON ci-dessus, créez un nouveau workflow dans votre instance n8n et sélectionnez "Importer depuis le JSON", collez la configuration et modifiez les paramètres d'authentification selon vos besoins.

Dans quelles scénarios ce workflow est-il adapté ?

Intermédiaire - Intelligence Artificielle, Marketing

Est-ce payant ?

Ce workflow est entièrement gratuit et peut être utilisé directement. Veuillez noter que les services tiers utilisés dans le workflow (comme l'API OpenAI) peuvent nécessiter un paiement de votre part.

Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds14
Catégorie2
Types de nœuds10
Description de la difficulté

Adapté aux utilisateurs expérimentés, avec des workflows de complexité moyenne contenant 6-15 nœuds

Liens externes
Voir sur n8n.io

Partager ce workflow

Catégories

Catégories: 34