{
  "name": "Create automatic pivot tables in Google Sheets with n8n",
  "nodes": [
    {
      "id": "07bc087a-adc5-4094-8236-bf3c90dfc7db",
      "name": "Start Workflow",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1088,
        976
      ]
    },
    {
      "id": "d9c83a60-1d84-4c57-a331-fff2f60bdddc",
      "name": "Sticky Note3",
      "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"
      }
    },
    {
      "id": "7bcd7fa0-c6ef-453d-85a1-e7dd51785e2e",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -512,
        1024
      ],
      "parameters": {
        "width": 684,
        "height": 400,
        "content": "### Aggregate and Combine Data"
      }
    },
    {
      "id": "b26723ad-8a5e-4b7c-b616-5d30cc4a359a",
      "name": "Sticky Note11",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1088,
        1216
      ],
      "parameters": {
        "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 "
      }
    },
    {
      "id": "1c9b0c94-9256-4afe-b852-03ba2201d651",
      "name": "Sum Campaigns1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -464,
        1088
      ]
    },
    {
      "id": "48415cdd-5bd3-4fbd-ba44-0b873c7056f5",
      "name": "Sum Channels1",
      "type": "n8n-nodes-base.summarize",
      "position": [
        -464,
        1248
      ]
    },
    {
      "id": "1c122f43-0f9e-4100-92bc-93ae78985625",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1216,
        784
      ],
      "parameters": {
        "width": 1436,
        "height": 848,
        "content": "## 📊 Create Automatic Pivot Tables in Google Sheets with n8n"
      }
    },
    {
      "id": "f5a176e6-0ee9-41b5-beee-0e2b930ccd73",
      "name": "Get Data From Google",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -896,
        1456
      ]
    },
    {
      "id": "523a8a2b-9bdf-4afd-9361-6c41f88a8616",
      "name": "Clear Campaign Sheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -832,
        848
      ]
    },
    {
      "id": "7fd3cee0-0318-428c-a8ce-c3a952cb46b8",
      "name": "Clear Channel Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -816,
        1040
      ]
    },
    {
      "id": "80f4d3ff-f6dd-4a5f-92e5-bf3c5cb36ee6",
      "name": "Create Campaign Pivot Table",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -208,
        1072
      ]
    },
    {
      "id": "ca072d34-43b2-4df0-9e38-dc1453268fe9",
      "name": "Create Channel Pivot Table",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -224,
        1264
      ]
    }
  ],
  "connections": {
    "Sum Channels1": {
      "main": [
        [
          {
            "node": "Create Channel Pivot Table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Start Workflow": {
      "main": [
        [
          {
            "node": "Get Data From Google",
            "type": "main",
            "index": 0
          },
          {
            "node": "Clear Campaign Sheet1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Clear Channel Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Sum Campaigns1": {
      "main": [
        [
          {
            "node": "Create Campaign Pivot Table",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get Data From Google": {
      "main": [
        [
          {
            "node": "Sum Campaigns1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Sum Channels1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}