{
  "name": "Google Sheets duplication & enrichment automation",
  "nodes": [
    {
      "id": "workflow-overview-sheets",
      "name": "Workflow Overview",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1450,
        -50
      ],
      "parameters": {
        "width": 350,
        "height": 320,
        "content": "# 📊 Google Sheets Duplication Workflow\n\n**Purpose:** Duplicate sheets from master spreadsheet to new spreadsheet\n\n**Process Overview:**\n1. Create new spreadsheet\n2. Get all sheets from master\n3. Loop "
      }
    },
    {
      "id": "start-create-note",
      "name": "Start & Create",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -1100,
        -50
      ],
      "parameters": {
        "width": 280,
        "height": 200,
        "content": "## 🚀 Start & Create\n\n**Manual Trigger:**\n- Click to start workflow\n- No scheduling needed\n\n**Create New Spreadsheet:**\n- Creates destination spreadsheet\n- Update title as needed\n- Stores ID for later "
      }
    },
    {
      "id": "discovery-note",
      "name": "Sheet Discovery",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -660,
        -50
      ],
      "parameters": {
        "width": 280,
        "height": 200,
        "content": "## 🔍 Sheet Discovery\n\n**HTTP Request:**\n- Gets spreadsheet metadata\n- Lists all sheets\n- Uses Google Sheets API v4\n\n**Code Node:**\n- Extracts sheet names\n- Formats for processing\n- Creates sheet array"
      }
    },
    {
      "id": "loop-note",
      "name": "Loop Processing",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        -50
      ],
      "parameters": {
        "width": 280,
        "height": 200,
        "content": "## 🔄 Loop Processing\n\n**Split In Batches:**\n- Processes one sheet at a time\n- Prevents API overload\n- Maintains order\n\n**Two outputs:**\n1. Done - Removes default Sheet1\n2. Loop - Creates & copies shee"
      }
    },
    {
      "id": "operations-note",
      "name": "Sheet Operations",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        220,
        -50
      ],
      "parameters": {
        "width": 280,
        "height": 200,
        "content": "## 📝 Sheet Operations\n\n**Create Sheets:**\n- Creates new sheet in destination\n- Uses original sheet names\n\n**Read & Write:**\n- Reads from master sheet\n- Writes to new sheet\n- Preserves all columns"
      }
    },
    {
      "id": "important-notes",
      "name": "Important Notes",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -220,
        420
      ],
      "parameters": {
        "width": 300,
        "height": 150,
        "content": "⚠️ **Important Notes:**\n\n1. Replace spreadsheet ID in HTTP Request\n2. Update credentials for all nodes\n3. Default 'Sheet1' is removed after all sheets are created\n4. Column structure must match betwee"
      }
    },
    {
      "id": "21b7267c-eac9-4f90-b345-614bd6d5a276",
      "name": "When clicking 'Test workflow'",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        -1100,
        200
      ]
    },
    {
      "id": "26e0f233-e990-4b98-8184-599583a64498",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        -660,
        200
      ]
    },
    {
      "id": "d8a02c3f-8b31-4bb1-9052-33963c09da16",
      "name": "Code",
      "type": "n8n-nodes-base.code",
      "position": [
        -440,
        200
      ]
    },
    {
      "id": "d45b8f9a-47ad-4280-ba95-d8b10b0351a2",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        -220,
        200
      ]
    },
    {
      "id": "aaff5289-8658-4f5c-b3de-15630e25c537",
      "name": "Create Sheets",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        200
      ]
    },
    {
      "id": "e33a1701-8a90-4e71-8f1a-f517d26894be",
      "name": "Write sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        440,
        275
      ]
    },
    {
      "id": "a46aad80-34cf-4f19-aec6-1896296b40d3",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        0,
        0
      ]
    },
    {
      "id": "c8439289-b353-4ac5-a0f2-601e66ddf6fb",
      "name": "Read Spreadsheet1",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        220,
        200
      ]
    },
    {
      "id": "2de35627-e071-4f39-9ea7-2e1fa0d56f7c",
      "name": "Create New Spreadsheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        -880,
        200
      ]
    }
  ],
  "connections": {
    "Code": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Write sheet": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Code",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Sheets": {
      "main": [
        [
          {
            "node": "Read Spreadsheet1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [
          {
            "node": "Google Sheets2",
            "type": "main",
            "index": 0
          }
        ],
        [
          {
            "node": "Create Sheets",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read Spreadsheet1": {
      "main": [
        [
          {
            "node": "Write sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create New Spreadsheet": {
      "main": [
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking 'Test workflow'": {
      "main": [
        [
          {
            "node": "Create New Spreadsheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}