{
  "name": "Create multi-sheet Excel workbooks by merging datasets with Google Drive & Sheets",
  "nodes": [
    {
      "id": "5432b2ed-adde-4021-b6b3-e75e43bd102c",
      "name": "When clicking ‘Execute workflow’",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -576,
        1728
      ]
    },
    {
      "id": "dcdb5d9e-4f54-46af-8f45-b922cad98117",
      "name": "Convert to File",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        288,
        1344
      ]
    },
    {
      "id": "f4bd8d4b-0a5b-457a-819e-1caf7a3c6363",
      "name": "Convert to File1",
      "type": "n8n-nodes-base.convertToFile",
      "position": [
        288,
        1632
      ]
    },
    {
      "id": "f9ab703d-41fb-4e69-841a-62a952644084",
      "name": "Merge1",
      "type": "n8n-nodes-base.merge",
      "position": [
        624,
        1504
      ]
    },
    {
      "id": "021b89d0-278d-4c85-9b67-f51baa3a0231",
      "name": "Sticky Note60",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        880,
        1264
      ],
      "parameters": {
        "width": 224,
        "height": 624,
        "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. **Copy the example sheet referenced in the"
      }
    },
    {
      "id": "dd8fef83-2469-4630-863e-08a307930e8a",
      "name": "Sticky Note62",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -240,
        1424
      ],
      "parameters": {
        "width": 224,
        "height": 544,
        "content": "### 2️⃣ Connect Google Drive (OAuth2)\n1. In **n8n → Credentials → New → Google Drive (OAuth2)**  \n2. Sign in with the Google account that will store your Excel outputs and **allow access**  \n3. In you"
      }
    },
    {
      "id": "b5413d5e-1efe-417e-b7c4-3ae52112d8ee",
      "name": "Sticky Note54",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -736,
        1040
      ],
      "parameters": {
        "width": 2144,
        "height": 1056,
        "content": "### Create multi-sheet Excel workbooks in n8n to automate reporting using Google Drive + Google Sheets\n\nBuild an automated Excel file with **multiple tabs** directly in n8n. Two Code nodes generate da"
      }
    },
    {
      "id": "203a12f7-582d-4664-bbbf-e1f6f3093567",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1184,
        1040
      ],
      "parameters": {
        "width": 400,
        "height": 1056,
        "content": "\n## Setup (only 2 connections)\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. **Copy the"
      }
    },
    {
      "id": "e2a70f89-3424-4518-8bff-68e239b798c8",
      "name": "Data Set 1",
      "type": "n8n-nodes-base.code",
      "position": [
        0,
        1232
      ]
    },
    {
      "id": "a700ca4e-57a2-4a23-ad99-9ad8abcace41",
      "name": "Data Set 2",
      "type": "n8n-nodes-base.code",
      "position": [
        32,
        1520
      ]
    },
    {
      "id": "62762267-68ef-4750-9703-ca9d6a1fe424",
      "name": "Save to google sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        960,
        1744
      ]
    },
    {
      "id": "1cd9ffc5-5a41-4fa6-9a45-0dcade22fd37",
      "name": "Export Excel file",
      "type": "n8n-nodes-base.googleDrive",
      "position": [
        -176,
        1824
      ]
    }
  ],
  "connections": {
    "Merge1": {
      "main": [
        [
          {
            "node": "Save to google sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Set 1": {
      "main": [
        [
          {
            "node": "Convert to File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Data Set 2": {
      "main": [
        [
          {
            "node": "Convert to File1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Convert to File1": {
      "main": [
        [
          {
            "node": "Merge1",
            "type": "main",
            "index": 1
          }
        ]
      ]
    },
    "When clicking ‘Execute workflow’": {
      "main": [
        [
          {
            "node": "Export Excel file",
            "type": "main",
            "index": 0
          },
          {
            "node": "Data Set 1",
            "type": "main",
            "index": 0
          },
          {
            "node": "Data Set 2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}