Agrégation des données de dépenses marketing dans Google Sheets à l'aide de tableaux croisés dynamiques personnalisés et de VLOOKUP
Intermédiaire
Ceci est unDocument Extraction, Multimodal AIworkflow d'automatisation du domainecontenant 10 nœuds.Utilise principalement des nœuds comme Merge, Summarize, GoogleSheets, ManualTrigger. Agrégation des données de dépenses marketing avec tableaux croisés dynamiques personnalisés et VLOOKUP dans Google Sheets
Prérequis
- •Informations d'identification Google Sheets API
Nœuds utilisés (10)
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
{
"meta": {
"instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
"templateCredsSetupCompleted": true
},
"nodes": [
{
"id": "5432b2ed-adde-4021-b6b3-e75e43bd102c",
"name": "Lors du clic sur 'Exécuter le workflow'",
"type": "n8n-nodes-base.manualTrigger",
"position": [
-1744,
4816
],
"parameters": {},
"typeVersion": 1
},
{
"id": "20d77255-29ba-45aa-af1b-ff2b8ba91ef6",
"name": "Effacer la feuille",
"type": "n8n-nodes-base.googleSheets",
"position": [
-240,
4944
],
"parameters": {
"operation": "clear",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1235077339,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=1235077339",
"cachedResultName": "render pivot"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "43298259-36ab-403d-91f8-0d0a499b6daf",
"name": "Tableau croisé dynamique",
"type": "n8n-nodes-base.summarize",
"position": [
-464,
5040
],
"parameters": {
"options": {},
"fieldsToSplitBy": "Name",
"fieldsToSummarize": {
"values": [
{
"field": "Spend ($)",
"aggregation": "sum"
}
]
}
},
"typeVersion": 1.1
},
{
"id": "ea502cf7-be4a-41ac-a1e0-38f73398c95e",
"name": "Obtenir les données marketing",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1008,
4944
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": "gid=0",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=0",
"cachedResultName": "data"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "896e5698-f99a-4e1b-ad4c-f5c4c07e847e",
"name": "Données VLOOKUP",
"type": "n8n-nodes-base.googleSheets",
"position": [
-1280,
5408
],
"parameters": {
"options": {},
"sheetName": {
"__rl": true,
"mode": "list",
"value": 894339285,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=894339285",
"cachedResultName": "Lookup"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
"name": "Fusionner les tableaux (VLOOKUP)",
"type": "n8n-nodes-base.merge",
"position": [
-688,
5040
],
"parameters": {
"mode": "combine",
"options": {},
"fieldsToMatchString": "Channel"
},
"typeVersion": 3.2
},
{
"id": "3e622961-1081-40cd-870e-c3b0d114d3c0",
"name": "Créer un type de 'Tableau croisé dynamique'",
"type": "n8n-nodes-base.googleSheets",
"position": [
-224,
5152
],
"parameters": {
"columns": {
"value": {},
"schema": [
{
"id": "sum_Spend_($)",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "sum_Spend_($)",
"defaultMatch": false,
"canBeUsedToMatch": true
},
{
"id": "Name",
"type": "string",
"display": true,
"removed": false,
"required": false,
"displayName": "Name",
"defaultMatch": false,
"canBeUsedToMatch": true
}
],
"mappingMode": "autoMapInputData",
"matchingColumns": [],
"attemptToConvertTypes": false,
"convertFieldsToString": false
},
"options": {},
"operation": "append",
"sheetName": {
"__rl": true,
"mode": "list",
"value": 1235077339,
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit#gid=1235077339",
"cachedResultName": "render pivot"
},
"documentId": {
"__rl": true,
"mode": "list",
"value": "1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30",
"cachedResultUrl": "https://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?usp=drivesdk",
"cachedResultName": "Pivot Data"
}
},
"credentials": {
"googleSheetsOAuth2Api": {
"id": "HlBW2puZbuCCq8jJ",
"name": "Google Sheets account 3"
}
},
"typeVersion": 4.7
},
{
"id": "c007458e-07ec-4b25-b898-272ce0fcde8f",
"name": "Note adhésive55",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1808,
4608
],
"parameters": {
"color": 7,
"width": 2144,
"height": 1056,
"content": "### Build a pivot-style marketing spend summary in Google Sheets using n8n (Merge + Summarize + Vlookup)\n\nThis workflow transforms raw marketing data from Google Sheets into a **pivot-like summary table**. It merges lookup data, groups spend by name, and appends the results into a clean reporting tab — all automatically, without needing to manually build pivot tables in Sheets.\n\n\n"
},
"typeVersion": 1
},
{
"id": "d004d740-9e2d-409a-b5df-960bd28482a7",
"name": "Note adhésive3",
"type": "n8n-nodes-base.stickyNote",
"position": [
-2240,
4608
],
"parameters": {
"width": 400,
"height": 1056,
"content": "\n## 🔑 Setup Instructions\n\n### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)** \n2. Sign in with your Google account and grant access \n3. In each Google Sheets node, select your **Spreadsheet** and the appropriate **Worksheet**: \n - **data** (raw spend) \n - **Lookup** (channel reference table) \n - **render pivot** (output tab) \n\nhttps://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?gid=894339285#gid=894339285\n\n## 📬 Contact \nNeed help customizing this (e.g., filtering by campaign, sending reports by email, or formatting your pivot)? \n\n- 📧 **rbreen@ynteractive.com** \n- 🔗 **[Robert Breen](https://www.linkedin.com/in/robert-breen-29429625/)** \n- 🌐 **[ynteractive.com](https://ynteractive.com)** \n"
},
"typeVersion": 1
},
{
"id": "2694e9b7-3405-4139-99bc-5ffd735f33a8",
"name": "Note adhésive65",
"type": "n8n-nodes-base.stickyNote",
"position": [
-1344,
4880
],
"parameters": {
"color": 3,
"width": 224,
"height": 656,
"content": "### 1) Connect Google Sheets (OAuth2)\n1. In **n8n → Credentials → New → Google Sheets (OAuth2)** \n2. Sign in with your Google account and grant access \n3. In each Google Sheets node, select your **Spreadsheet** and the appropriate **Worksheet**: \n - **data** (raw spend) \n - **Lookup** (channel reference table) \n - **render pivot** (output tab) \n\nhttps://docs.google.com/spreadsheets/d/1aO6fhd-P55lXy9QuKs23Eifi1SzZ2GAFj0q0Qx4vl30/edit?gid=894339285#gid=894339285\n"
},
"typeVersion": 1
}
],
"pinData": {},
"connections": {
"43298259-36ab-403d-91f8-0d0a499b6daf": {
"main": [
[
{
"node": "20d77255-29ba-45aa-af1b-ff2b8ba91ef6",
"type": "main",
"index": 0
},
{
"node": "3e622961-1081-40cd-870e-c3b0d114d3c0",
"type": "main",
"index": 0
}
]
]
},
"896e5698-f99a-4e1b-ad4c-f5c4c07e847e": {
"main": [
[
{
"node": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
"type": "main",
"index": 1
}
]
]
},
"ea502cf7-be4a-41ac-a1e0-38f73398c95e": {
"main": [
[
{
"node": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
"type": "main",
"index": 0
}
]
]
},
"4178ff0a-9cbb-4eef-93d8-2a012471f0ed": {
"main": [
[
{
"node": "43298259-36ab-403d-91f8-0d0a499b6daf",
"type": "main",
"index": 0
}
]
]
},
"5432b2ed-adde-4021-b6b3-e75e43bd102c": {
"main": [
[
{
"node": "ea502cf7-be4a-41ac-a1e0-38f73398c95e",
"type": "main",
"index": 0
},
{
"node": "896e5698-f99a-4e1b-ad4c-f5c4c07e847e",
"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 - Extraction de documents, IA Multimodale
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.
Workflows recommandés
Rapport automatisé des performances marketing par e-mail
Génération automatique de rapports de performance marketing par e-mail avec Google Sheets et Outlook
Merge
Summarize
Google Sheets
+
Merge
Summarize
Google Sheets
13 NœudsRobert Breen
Extraction de documents
Utiliser GPT-4 Insights et PDF.co pour générer des rapports marketing à partir de Google Sheets
Générer des rapports marketing à partir de Google Sheets avec insights GPT-4 et PDF.co
Code
Merge
Aggregate
+
Code
Merge
Aggregate
15 NœudsRobert Breen
Extraction de documents
Créer un classeur Excel avec plusieurs feuilles de calcul en utilisant Google Drive et Sheets avec l'union d'ensembles de données
Créer un classeur Excel multi-feuilles en utilisant Google Drive et Sheets via la fusion d'ensembles de données
Code
Merge
Google Drive
+
Code
Merge
Google Drive
12 NœudsRobert Breen
Extraction de documents
Débutant en analyse de données : fusion, filtrage et résumé dans Google Sheets avec GPT-4o
Analyse de données pour débutants : fusion, filtrage et résumé dans Google Sheets avec GPT-4o
If
Set
Code
+
If
Set
Code
21 NœudsRobert Breen
Extraction de documents
Utiliser Google Sheets, GPT-4o et les e-mails pour générer un rapport de ROI de campagne marketing
Générer des rapports de ROI de campagne marketing avec Google Sheets, GPT-4o et e-mail
Code
Merge
Aggregate
+
Code
Merge
Aggregate
16 NœudsRobert Breen
Résumé IA
Enregistrement automatisé des nouveaux e-mails Gmail dans Google Sheets
Enregistrer automatiquement les nouveaux e-mails Gmail dans Google Sheets
Code
Gmail
Merge
+
Code
Gmail
Merge
11 NœudsRobert Breen
CRM
Informations sur le workflow
Niveau de difficulté
Intermédiaire
Nombre de nœuds10
Catégorie2
Types de nœuds5
Description de la difficulté
Auteur
Robert Breen
@rbreenProfessional services consultant with over 10 years of experience solving complex business problems across industries. I specialize in n8n and process automation—designing custom workflows that integrate tools like Google Calendar, Airtable, GPT, and internal systems. Whether you need to automate scheduling, sync data, or streamline operations, I build solutions that save time and drive results.
Liens externes
Voir sur n8n.io →
Partager ce workflow