8
n8n Deutschamn8n.com

Automatische Pivot-Tabellen in Google Sheets mit n8N erstellen

Fortgeschritten

Dies ist ein Automatisierungsworkflow mit 12 Nodes. Hauptsächlich werden Summarize, GoogleSheets, ManualTrigger und andere Nodes verwendet. Erstelle automatische Pivot-Tabellen in Google Sheets mit n8n

Voraussetzungen
  • •Google Sheets API-Anmeldedaten

Verwendete Nodes (12)

Summarize
StickyNote
GoogleSheets
ManualTrigger

Kategorie

-
Workflow-Vorschau
Visualisierung der Node-Verbindungen, mit Zoom und Pan
React Flow
Workflow exportieren
Kopieren Sie die folgende JSON-Konfiguration und importieren Sie sie in n8n
{
  "meta": {
    "instanceId": "ad0113c344ee237399e44e9f11798b05baeb83a6196d514a9ae9d2ad71c3b5c9",
    "templateCredsSetupCompleted": true
  },
  "nodes": [
    {
      "id": "07bc087a-adc5-4094-8236-bf3c90dfc7db",
      "name": "Workflow starten",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1088,
        976
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "d9c83a60-1d84-4c57-a331-fff2f60bdddc",
      "name": "Notiz3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1808,
        784
      ],
      "parameters": {
        "width": 540,
        "height": 848,
        "content": "\n\nThis n8n workflow pulls campaign data from Google Sheets and creates two pivot tables automatically each time it runs.\n\n\n### ✅ Step 1: Connect Google Sheets\n\n1. In n8n, go to **Credentials** → click **New Credential**\n2. Select **Google Sheets OAuth2 API**\n3. Log in with your Google account and authorize access\n4. Use this sheet: [📄 Campaign Data Sheet](https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?usp=sharing)\n5. Make sure the sheet includes:\n   - A **Data** tab (row 1 = headers, rows 2+ = campaign data)\n   - A tab for each **pivot view** (e.g. by Channel, by Campaign)\n\n---\n\n### 📬 Need Help?\n\nFeel free to reach out:\n\n- 📧 robert@ynteractive.com  \n- 🔗 [LinkedIn](https://www.linkedin.com/in/robert-breen-29429625/)\n"
      },
      "typeVersion": 1
    },
    {
      "id": "7bcd7fa0-c6ef-453d-85a1-e7dd51785e2e",
      "name": "Notiz4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        1024
      ],
      "parameters": {
        "color": 7,
        "width": 684,
        "height": 400,
        "content": "### Aggregate and Combine Data"
      },
      "typeVersion": 1
    },
    {
      "id": "b26723ad-8a5e-4b7c-b616-5d30cc4a359a",
      "name": "Notiz11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        1216
      ],
      "parameters": {
        "color": 3,
        "width": 448,
        "height": 384,
        "content": "### 1. Prepare Your Google Sheet\n\n- Use this sheet: [Campaign Data Sheet](https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?gid=365710158)\n- Must include:\n  - A **Data** tab with campaign metrics (row 1 = headers)\n  - One tab per **pivot view** (e.g. by Channel, Date, Campaign)\n- Connect via **Google Sheets OAuth2** in n8n\n- Optional: You can also use Airtable, Notion, or a database\n"
      },
      "typeVersion": 1
    },
    {
      "id": "1c9b0c94-9256-4afe-b852-03ba2201d651",
      "name": "Kampagnen summieren1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -464,
        1088
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "Campaign",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Spend ($)",
              "aggregation": "sum"
            },
            {
              "field": "Clicks",
              "aggregation": "sum"
            },
            {
              "field": "Conversions",
              "aggregation": "sum"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "48415cdd-5bd3-4fbd-ba44-0b873c7056f5",
      "name": "Kanäle summieren1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -464,
        1248
      ],
      "parameters": {
        "options": {},
        "fieldsToSplitBy": "Channel",
        "fieldsToSummarize": {
          "values": [
            {
              "field": "Spend ($)",
              "aggregation": "sum"
            },
            {
              "field": "Clicks",
              "aggregation": "sum"
            },
            {
              "field": "Conversions",
              "aggregation": "sum"
            }
          ]
        }
      },
      "typeVersion": 1.1
    },
    {
      "id": "1c122f43-0f9e-4100-92bc-93ae78985625",
      "name": "Notiz6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1216,
        784
      ],
      "parameters": {
        "color": 7,
        "width": 1436,
        "height": 848,
        "content": "## 📊 Create Automatic Pivot Tables in Google Sheets with n8n"
      },
      "typeVersion": 1
    },
    {
      "id": "f5a176e6-0ee9-41b5-beee-0e2b930ccd73",
      "name": "Daten aus Google abrufen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -896,
        1456
      ],
      "parameters": {
        "options": {},
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 365710158,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit#gid=365710158",
          "cachedResultName": "Data"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1UDWt0-Z9fHqwnSNfU3vvhSoYCFG6EG3E-ZewJC_CLq4/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - n8n"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "523a8a2b-9bdf-4afd-9361-6c41f88a8616",
      "name": "Kampagnenblatt löschen1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -832,
        848
      ],
      "parameters": {
        "operation": "clear",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 505010778,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit#gid=505010778",
          "cachedResultName": "Campaign Pivot"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - Pivot Tables"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "7fd3cee0-0318-428c-a8ce-c3a952cb46b8",
      "name": "Kanalblatt löschen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        1040
      ],
      "parameters": {
        "operation": "clear",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 335973986,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit#gid=335973986",
          "cachedResultName": "Channel Pivot"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - Pivot Tables"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "80f4d3ff-f6dd-4a5f-92e5-bf3c5cb36ee6",
      "name": "Kampagnen-Pivot-Tabelle erstellen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -208,
        1072
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "sum_Spend_($)",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sum_Spend_($)",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sum_Clicks",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sum_Clicks",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sum_Conversions",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sum_Conversions",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Campaign",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Campaign",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 505010778,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit#gid=505010778",
          "cachedResultName": "Campaign Pivot"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - Pivot Tables"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    },
    {
      "id": "ca072d34-43b2-4df0-9e38-dc1453268fe9",
      "name": "Kanal-Pivot-Tabelle erstellen",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -224,
        1264
      ],
      "parameters": {
        "columns": {
          "value": {},
          "schema": [
            {
              "id": "sum_Spend_($)",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sum_Spend_($)",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sum_Clicks",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sum_Clicks",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "sum_Conversions",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "sum_Conversions",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            },
            {
              "id": "Channel",
              "type": "string",
              "display": true,
              "removed": false,
              "required": false,
              "displayName": "Channel",
              "defaultMatch": false,
              "canBeUsedToMatch": true
            }
          ],
          "mappingMode": "autoMapInputData",
          "matchingColumns": [],
          "attemptToConvertTypes": false,
          "convertFieldsToString": false
        },
        "options": {},
        "operation": "appendOrUpdate",
        "sheetName": {
          "__rl": true,
          "mode": "list",
          "value": 335973986,
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit#gid=335973986",
          "cachedResultName": "Channel Pivot"
        },
        "documentId": {
          "__rl": true,
          "mode": "list",
          "value": "1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/1lUEY6kPQbXizbmszLLNUJ_pBfGIKd75hu4uHj0vGRZQ/edit?usp=drivesdk",
          "cachedResultName": "Sample Marketing Data - Pivot Tables"
        }
      },
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "HlBW2puZbuCCq8jJ",
          "name": "Google Sheets account 3"
        }
      },
      "typeVersion": 4.7
    }
  ],
  "pinData": {},
  "connections": {
    "48415cdd-5bd3-4fbd-ba44-0b873c7056f5": {
      "main": [
        [
          {
            "node": "ca072d34-43b2-4df0-9e38-dc1453268fe9",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "07bc087a-adc5-4094-8236-bf3c90dfc7db": {
      "main": [
        [
          {
            "node": "f5a176e6-0ee9-41b5-beee-0e2b930ccd73",
            "type": "main",
            "index": 0
          },
          {
            "node": "523a8a2b-9bdf-4afd-9361-6c41f88a8616",
            "type": "main",
            "index": 0
          },
          {
            "node": "7fd3cee0-0318-428c-a8ce-c3a952cb46b8",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "1c9b0c94-9256-4afe-b852-03ba2201d651": {
      "main": [
        [
          {
            "node": "80f4d3ff-f6dd-4a5f-92e5-bf3c5cb36ee6",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "f5a176e6-0ee9-41b5-beee-0e2b930ccd73": {
      "main": [
        [
          {
            "node": "1c9b0c94-9256-4afe-b852-03ba2201d651",
            "type": "main",
            "index": 0
          },
          {
            "node": "48415cdd-5bd3-4fbd-ba44-0b873c7056f5",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Häufig gestellte Fragen

Wie verwende ich diesen Workflow?

Kopieren Sie den obigen JSON-Code, erstellen Sie einen neuen Workflow in Ihrer n8n-Instanz und wählen Sie "Aus JSON importieren". Fügen Sie die Konfiguration ein und passen Sie die Anmeldedaten nach Bedarf an.

Für welche Szenarien ist dieser Workflow geeignet?

Fortgeschritten

Ist es kostenpflichtig?

Dieser Workflow ist völlig kostenlos. Beachten Sie jedoch, dass Drittanbieterdienste (wie OpenAI API), die im Workflow verwendet werden, möglicherweise kostenpflichtig sind.

Verwandte Workflows

Aggregation von Marketing-Ausgaben in Google Sheets mithilfe von benutzerdefinierten Pivot-Tabellen und VLOOKUP
Verwenden Sie benutzerdefinierte Pivot-Tables und VLOOKUP in Google Sheets, um Marketing-Ausgabendaten zu aggregieren
Merge
Summarize
Google Sheets
+
Merge
Summarize
Google Sheets
10 NodesRobert Breen
Dokumentenextraktion
Automatisierter E-Mail-Bericht zur Marketingleistung
Automatisierte Erstellung von Marketing-Leistungs-E-Mail-Berichten mit Google Sheets und Outlook
Merge
Summarize
Google Sheets
+
Merge
Summarize
Google Sheets
13 NodesRobert Breen
Dokumentenextraktion
Anfängerdatenanalyse: Kombinieren, Filtern und Zusammenführen in Google Sheets mit GPT-4o
Einsteiger-Datenanalyse: Merge, Filter und Summiere in Google Sheets mit GPT-4o
If
Set
Code
+
If
Set
Code
21 NodesRobert Breen
Dokumentenextraktion
Tägliche Werbeausgabenüberwachung: Google Sheets und Slack-Schwellenwertbenachrichtigungen
Tägliche Werbeausgabenüberwachung mit Google Sheets und Slack-Schwellenwerten
If
Set
Code
+
If
Set
Code
13 NodesRobert Breen
Content-Erstellung
Lokale-Unternehmenskontakt-Extraktion-mit-Google-Sheets,-SerpAPI,-Apify-und-GPT-4o
Verwenden Sie Google Sheets, SerpAPI, Apify und GPT-4o, um lokale Geschäftskontakte zu extrahieren
Code
Filter
Summarize
+
Code
Filter
Summarize
18 NodesRobert Breen
Lead-Generierung
Google Sheets, GPT-4o und E-Mail verwenden, um ROI-Berichte für Marketingkampagnen zu generieren
Marketing-ROI-Berichte mit Google Sheets, GPT-4o und E-Mail generieren
Code
Merge
Aggregate
+
Code
Merge
Aggregate
16 NodesRobert Breen
KI-Zusammenfassung
Workflow-Informationen
Schwierigkeitsgrad
Fortgeschritten
Anzahl der Nodes12
Kategorie-
Node-Typen4
Schwierigkeitsbeschreibung

Für erfahrene Benutzer, mittelkomplexe Workflows mit 6-15 Nodes

Autor
Robert Breen

Robert Breen

@rbreen

Professional 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.

Externe Links
Auf n8n.io ansehen →

Diesen Workflow teilen

Kategorien

Multimodales KI
1540
Künstliche Intelligenz
1108
Content-Erstellung
695
KI-Zusammenfassung
516
Marketing
419
KI-Chatbot
251
Engineering
241
Marktforschung
203
Verschiedenes
193
Sonstiges
176
Vertrieb
162
IT-Betrieb
156
Dokumentenextraktion
147
KI RAG
146
Bausteine
144
Soziale Medien
137
Lead-Generierung
125
Persönliche Produktivität
117
DevOps
111
Personalwesen
101
Support
97
Lead-Pflege
87
Kundenbeziehungsmanagement
82
Finanzen
81
Produkt
77
Support-Chatbot
76
Design
70
Ticketverwaltung
67
Sicherheitsbetrieb
57
Rechnungsverarbeitung
53
Krypto-Handel
49
Dateiverwaltung
39
Projektmanagement
35
Internes Wiki
32

Kategorien: 34