Gdrive Aggregator - Setup Folders

The workflow JSON

Copy or download the full n8n JSON below. Paste it into a new n8n workflow, add your credentials, activate. Full import guide →

{
  "name": "GDrive Aggregator - Setup Folders",
  "nodes": [
    {
      "parameters": {},
      "id": "manual-trigger",
      "name": "Run Once to Setup",
      "type": "n8n-nodes-base.manualTrigger",
      "typeVersion": 1,
      "position": [
        240,
        300
      ]
    },
    {
      "parameters": {
        "operation": "createFolder",
        "name": "File-Aggregator",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "folderId": {
          "__rl": true,
          "mode": "list",
          "value": "root"
        },
        "options": {}
      },
      "id": "create-parent",
      "name": "Create Parent Folder",
      "type": "n8n-nodes-base.googleDrive",
      "typeVersion": 3,
      "position": [
        460,
        300
      ]
    },
    {
      "parameters": {
        "operation": "createFolder",
        "name": "master",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "folderId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.id }}"
        },
        "options": {}
      },
      "id": "create-master",
      "name": "Create Master Folder",
      "type": "n8n-nodes-base.googleDrive",
      "typeVersion": 3,
      "position": [
        680,
        200
      ]
    },
    {
      "parameters": {
        "operation": "createFolder",
        "name": "completed",
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "folderId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('Create Parent Folder').item.json.id }}"
        },
        "options": {}
      },
      "id": "create-completed",
      "name": "Create Completed Folder",
      "type": "n8n-nodes-base.googleDrive",
      "typeVersion": 3,
      "position": [
        680,
        400
      ]
    },
    {
      "parameters": {
        "operation": "create",
        "title": "Master Spreadsheet",
        "options": {}
      },
      "id": "create-master-sheet",
      "name": "Create Master Sheet",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 4.5,
      "position": [
        900,
        200
      ]
    },
    {
      "parameters": {
        "operation": "move",
        "fileId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $json.spreadsheetId }}"
        },
        "driveId": {
          "__rl": true,
          "mode": "list",
          "value": "My Drive"
        },
        "folderId": {
          "__rl": true,
          "mode": "id",
          "value": "={{ $('Create Master Folder').item.json.id }}"
        },
        "options": {}
      },
      "id": "move-sheet-to-master",
      "name": "Move Sheet to Master",
      "type": "n8n-nodes-base.googleDrive",
      "typeVersion": 3,
      "position": [
        1120,
        200
      ]
    },
    {
      "parameters": {
        "jsCode": "const parentId = $('Create Parent Folder').first().json.id;\nconst masterId = $('Create Master Folder').first().json.id;\nconst completedId = $('Create Completed Folder').first().json.id;\nconst sheetId = $('Create Master Sheet').first().json.spreadsheetId;\nreturn [{json: {message: 'Setup Complete!', GDRIVE_PARENT_FOLDER_ID: parentId, GDRIVE_MASTER_FOLDER_ID: masterId, COMPLETED_FOLDER_ID: completedId, MASTER_SHEET_ID: sheetId}}];"
      },
      "id": "output-config",
      "name": "Output Configuration",
      "type": "n8n-nodes-base.code",
      "typeVersion": 2,
      "position": [
        1340,
        300
      ]
    }
  ],
  "connections": {
    "Run Once to Setup": {
      "main": [
        [
          {
            "node": "Create Parent Folder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Parent Folder": {
      "main": [
        [
          {
            "node": "Create Master Folder",
            "type": "main",
            "index": 0
          },
          {
            "node": "Create Completed Folder",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Master Folder": {
      "main": [
        [
          {
            "node": "Create Master Sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Master Sheet": {
      "main": [
        [
          {
            "node": "Move Sheet to Master",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Move Sheet to Master": {
      "main": [
        [
          {
            "node": "Output Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Create Completed Folder": {
      "main": [
        [
          {
            "node": "Output Configuration",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "settings": {
    "executionOrder": "v1"
  },
  "tags": [
    {
      "name": "gdrive-aggregator"
    },
    {
      "name": "setup"
    }
  ],
  "active": false
}

About this workflow

GDrive Aggregator - Setup Folders. Uses googleDrive, googleSheets. Event-driven trigger; 7 nodes.

Source: https://github.com/bermingham85/gdrive-file-aggregator/blob/79524f6a5c3395b1d156b82cb281c993a9b30da1/workflows/setup-folders.json — original creator credit. Request a take-down →

More Data & Sheets workflows → · Browse all categories →

Related workflows

Workflows that share integrations, category, or trigger type with this one. All free to copy and import.