{
  "name": "Aggregate marketing spend data with custom pivots & VLOOKUPs in Google Sheets",
  "nodes": [
    {
      "id": "5432b2ed-adde-4021-b6b3-e75e43bd102c",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1744,
        4816
      ]
    },
    {
      "id": "20d77255-29ba-45aa-af1b-ff2b8ba91ef6",
      "name": "Clear sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -240,
        4944
      ]
    },
    {
      "id": "43298259-36ab-403d-91f8-0d0a499b6daf",
      "name": "Pivot",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -464,
        5040
      ]
    },
    {
      "id": "ea502cf7-be4a-41ac-a1e0-38f73398c95e",
      "name": "Get Marketing Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1008,
        4944
      ]
    },
    {
      "id": "896e5698-f99a-4e1b-ad4c-f5c4c07e847e",
      "name": "Vlookup Data",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -1280,
        5408
      ]
    },
    {
      "id": "4178ff0a-9cbb-4eef-93d8-2a012471f0ed",
      "name": "Merge Tables (Vlookup)",
      "type": "n8n-nodes-base.merge",
      "position": [
        -688,
        5040
      ]
    },
    {
      "id": "3e622961-1081-40cd-870e-c3b0d114d3c0",
      "name": "Create \"Pivot Table\" Kindof",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -224,
        5152
      ]
    },
    {
      "id": "c007458e-07ec-4b25-b898-272ce0fcde8f",
      "name": "Sticky Note55",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1808,
        4608
      ],
      "parameters": {
        "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 tab"
      }
    },
    {
      "id": "d004d740-9e2d-409a-b5df-960bd28482a7",
      "name": "Sticky Note3",
      "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 Sh"
      }
    },
    {
      "id": "2694e9b7-3405-4139-99bc-5ffd735f33a8",
      "name": "Sticky Note65",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1344,
        4880
      ],
      "parameters": {
        "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 **S"
      }
    }
  ],
  "connections": {
    "Pivot": {
      "main": [
        [
          {
            "node": "Clear sheet",
            "type": "main",
            "index": 0
          },
          {
            "node": "Create \"Pivot Table\" Kindof",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Vlookup Data": {
      "main": [
        [
          {
            "node": "Merge Tables (Vlookup)",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "Get Marketing Data": {
      "main": [
        [
          {
            "node": "Merge Tables (Vlookup)",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Merge Tables (Vlookup)": {
      "main": [
        [
          {
            "node": "Pivot",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Get Marketing Data",
            "type": "main",
            "index": 0
          },
          {
            "node": "Vlookup Data",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}