AutomationFlowsData & Sheets › Bulk JSON File Downloader From Google Sheet to Local Folders

Bulk JSON File Downloader From Google Sheet to Local Folders

ByRahul Joshi @rahul08 on n8n.io

Description:

Event trigger★★★★☆ complexity16 nodesGoogle SheetsHTTP RequestRead Write File
Data & Sheets Trigger: Event Nodes: 16 Complexity: ★★★★☆ Added:

This workflow corresponds to n8n.io template #6366 — we link there as the canonical source.

This workflow follows the Google Sheets → HTTP Request recipe pattern — see all workflows that pair these two integrations.

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 →

Download .json
{
  "id": "30LBIZdc1EWwxA14",
  "meta": {
    "templateCredsSetupCompleted": true
  },
  "name": "Json Folder Separation",
  "tags": [],
  "nodes": [
    {
      "id": "0fc0a74b-335e-40ea-9528-6fd4996e0054",
      "name": "When clicking \u2018Execute workflow\u2019",
      "type": "n8n-nodes-base.manualTrigger",
      "position": [
        0,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "5ba7a93e-0de3-4f15-b617-dd51fa420f5b",
      "name": "Get row(s) in sheet",
      "type": "n8n-nodes-base.googleSheets",
      "position": [
        224,
        80
      ],
      "parameters": {},
      "typeVersion": 4.6
    },
    {
      "id": "6304e17b-dbe7-4432-adf6-859d478452dc",
      "name": "HTTP Request",
      "type": "n8n-nodes-base.httpRequest",
      "position": [
        1120,
        0
      ],
      "parameters": {},
      "typeVersion": 4.2
    },
    {
      "id": "bb8f9d28-f746-48e7-88a6-332e9ef5fa09",
      "name": "Loop Over Items",
      "type": "n8n-nodes-base.splitInBatches",
      "position": [
        896,
        80
      ],
      "parameters": {},
      "typeVersion": 3
    },
    {
      "id": "1b1dd00f-8b1d-4c7f-821c-800c3071d9e9",
      "name": "Read/Write Files from Disk",
      "type": "n8n-nodes-base.readWriteFile",
      "position": [
        1568,
        80
      ],
      "parameters": {},
      "typeVersion": 1
    },
    {
      "id": "b301e0e4-ab3a-451c-a16d-efc0a5d6de8c",
      "name": "Code2",
      "type": "n8n-nodes-base.code",
      "position": [
        1344,
        0
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "570b681d-f903-4e04-9623-1158158dd29b",
      "name": "Take name and URL",
      "type": "n8n-nodes-base.code",
      "position": [
        448,
        80
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "46ad6abd-0855-4e85-8b8b-ac238c0be541",
      "name": "url to downloadurl",
      "type": "n8n-nodes-base.code",
      "position": [
        672,
        80
      ],
      "parameters": {},
      "typeVersion": 2
    },
    {
      "id": "391c3ba3-b42a-4e37-81ec-40a50bdc1f0c",
      "name": "Sticky Note",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        -272,
        -128
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "40c75f58-29aa-4155-89fd-96ef88f1310c",
      "name": "Sticky Note1",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        112,
        224
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "466c47bf-9d13-4625-b2f8-676de72fe4fd",
      "name": "Sticky Note2",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        256,
        -208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "93cfa4f0-ff84-40fc-87df-513e22a0ef39",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        528,
        208
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "9c3eb039-e5db-4879-9e5e-ea7f7e3adefb",
      "name": "Sticky Note4",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        736,
        -240
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "c1a9dcd0-14e2-4722-be04-bf94cea15e40",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1056,
        160
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "60544704-6597-4e82-93f8-55f505f4ce4c",
      "name": "Sticky Note6",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1216,
        -288
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    },
    {
      "id": "8b68dcbc-c163-4441-b546-6de20117f6db",
      "name": "Sticky Note7",
      "type": "n8n-nodes-base.stickyNote",
      "position": [
        1712,
        -112
      ],
      "parameters": {
        "content": ""
      },
      "typeVersion": 1
    }
  ],
  "active": false,
  "settings": {
    "executionOrder": "v1"
  },
  "versionId": "14a9eb5c-a80e-4d24-92d1-0610f6c0411c",
  "connections": {
    "Code2": {
      "main": [
        [
          {
            "node": "Read/Write Files from Disk",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "HTTP Request": {
      "main": [
        [
          {
            "node": "Code2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Loop Over Items": {
      "main": [
        [],
        [
          {
            "node": "HTTP Request",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Take name and URL": {
      "main": [
        [
          {
            "node": "url to downloadurl",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "url to downloadurl": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Get row(s) in sheet": {
      "main": [
        [
          {
            "node": "Take name and URL",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Read/Write Files from Disk": {
      "main": [
        [
          {
            "node": "Loop Over Items",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "When clicking \u2018Execute workflow\u2019": {
      "main": [
        [
          {
            "node": "Get row(s) in sheet",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  }
}
Pro

For the full experience including quality scoring and batch install features for each workflow upgrade to Pro

About this workflow

Description:

Source: https://n8n.io/workflows/6366/ — 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.

Data & Sheets

This template is only compatible with a self-hosted n8n instance using a community node.

HTTP Request, Google Sheets, Google Drive +2
Data & Sheets

This template is ideal for solo store owners, eCommerce marketers, automation beginners, or anyone using Shopify and Gmail who wants to recover lost revenue without coding.

HTTP Request, Gmail, Twilio +3
Data & Sheets

PCN. Uses googleSheets, httpRequest, @n-octo-n/n8n-nodes-json-database, itemLists. Event-driven trigger; 60 nodes.

Google Sheets, HTTP Request, @N Octo N/N8N Nodes Json Database +3
Data & Sheets

The workflow automates the process of gathering extensive keyword data for a "Main Keyword." It starts by reading initial parameters from a Google Sheets template, creates a new dedicated Google Sheet

Google Sheets, Google Drive, HTTP Request
Data & Sheets

🔥 March Sale – n8n Community Members Get ideoGener8r for Just $27! (Reg. $47) Use Coupon Code: (Valid until 3/31/2025 for n8n community members)

HTTP Request, Google Drive, Google Sheets