FTP to Google Sheets with huge file

Hello, I’ve for some problems with this workflow.

Describe the issue/error/question

The workflow download a 6.6 MB csv file
but I lost the connection

What is the error message (if any)?

n8n may have run out of memory while executing it.

Please share the workflow

type or paste code here

{
  "name": "1.0 SCARICA FILE DA FOCUS ORE 11.20 PM TEST 15.24",
  "nodes": [
    {
      "parameters": {
        "content": "## INVENTARIO",
        "height": 98.92094114635353,
        "width": 200.77076224104445
      },
      "id": "d9fc2d2f-7891-47fa-8048-c3636df436ab",
      "name": "Sticky Note3",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        460,
        460
      ]
    },
    {
      "parameters": {
        "path": "/html/inventory.csv"
      },
      "id": "c55ebeab-bf97-4738-b2e1-fc92602558d3",
      "name": "FTP",
      "type": "n8n-nodes-base.ftp",
      "typeVersion": 1,
      "position": [
        160,
        740
      ],
      "credentials": {
        "ftp": {
          "id": "1",
          "name": "FTP account"
        }
      }
    },
    {
      "parameters": {
        "options": {}
      },
      "id": "fbd9f427-e180-4576-8219-39d2c1f656b4",
      "name": "Spreadsheet File",
      "type": "n8n-nodes-base.spreadsheetFile",
      "typeVersion": 1,
      "position": [
        660,
        740
      ]
    },
    {
      "parameters": {
        "keepOnlySet": true,
        "values": {
          "number": [
            {
              "name": "codice_a_barre",
              "value": "={{ $json[\"codice_a_barre\"] }}"
            },
            {
              "name": "Giacenza",
              "value": "={{ $json[\"Giacenza\"] }}"
            }
          ]
        },
        "options": {
          "dotNotation": false
        }
      },
      "id": "4f252b60-3d6f-4ed0-b827-f0572d85cc1d",
      "name": "Set",
      "type": "n8n-nodes-base.set",
      "typeVersion": 1,
      "position": [
        1200,
        740
      ]
    },
    {
      "parameters": {
        "content": "## OGNI GIORNO ALLLE 11 SI ATTIVA",
        "height": 94.42901892686798,
        "width": 254.52093299468245
      },
      "id": "f2d55b26-7b60-4e1c-bf9a-7f267422be1f",
      "name": "Sticky Note5",
      "type": "n8n-nodes-base.stickyNote",
      "typeVersion": 1,
      "position": [
        -200,
        620
      ]
    },
    {
      "parameters": {
        "rule": {
          "interval": [
            {
              "triggerAtHour": 13,
              "triggerAtMinute": 24
            }
          ]
        }
      },
      "id": "464008aa-aded-4682-ace3-98313e0898f9",
      "name": "Schedule Trigger",
      "type": "n8n-nodes-base.scheduleTrigger",
      "typeVersion": 1,
      "position": [
        -140,
        740
      ]
    },
    {
      "parameters": {
        "batchSize": 100,
        "options": {}
      },
      "id": "31aabd86-fc13-4d36-bc31-0eb32749a2f8",
      "name": "Split In Batches1",
      "type": "n8n-nodes-base.splitInBatches",
      "typeVersion": 1,
      "position": [
        1500,
        740
      ]
    },
    {
      "parameters": {
        "amount": 10,
        "unit": "seconds"
      },
      "id": "b256cd45-7b5d-461f-9886-14996fb8b0e3",
      "name": "Wait1",
      "type": "n8n-nodes-base.wait",
      "typeVersion": 1,
      "position": [
        1880,
        740
      ],
      "webhookId": "9c895425-bb91-4f4e-91dc-5d155697e064"
    },
    {
      "parameters": {
        "operation": "appendOrUpdate",
        "documentId": {
          "__rl": true,
          "value": "10kDkP7cuP-DCJS_M71av_movx8jHCRzMyRWwiRKtG7Q",
          "mode": "id"
        },
        "sheetName": {
          "__rl": true,
          "value": 706694757,
          "mode": "list",
          "cachedResultName": "INVENTORYdef",
          "cachedResultUrl": "https://docs.google.com/spreadsheets/d/10kDkP7cuP-DCJS_M71av_movx8jHCRzMyRWwiRKtG7Q/edit#gid=706694757"
        },
        "columnToMatchOn": "codice_a_barre",
        "valueToMatchOn": "={{ $json[\"codice_a_barre\"] }}",
        "options": {}
      },
      "id": "c5e5aaf3-3361-4a1f-9262-5d047a1b7110",
      "name": "Google Sheets2",
      "type": "n8n-nodes-base.googleSheets",
      "typeVersion": 3,
      "position": [
        1680,
        740
      ],
      "credentials": {
        "googleSheetsOAuth2Api": {
          "id": "3",
          "name": "Google Sheets account"
        }
      }
    }
  ],
  "pinData": {},
  "connections": {
    "FTP": {
      "main": [
        [
          {
            "node": "Spreadsheet File",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Spreadsheet File": {
      "main": [
        [
          {
            "node": "Set",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Set": {
      "main": [
        [
          {
            "node": "Split In Batches1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Schedule Trigger": {
      "main": [
        [
          {
            "node": "FTP",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Wait1": {
      "main": [
        [
          {
            "node": "Split In Batches1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Split In Batches1": {
      "main": [
        [
          {
            "node": "Google Sheets2",
            "type": "main",
            "index": 0
          }
        ]
      ]
    },
    "Google Sheets2": {
      "main": [
        [
          {
            "node": "Wait1",
            "type": "main",
            "index": 0
          }
        ]
      ]
    }
  },
  "active": true,
  "settings": {
    "saveDataSuccessExecution": "all",
    "saveExecutionProgress": true,
    "saveManualExecutions": true,
    "callerPolicy": "workflowsFromSameOwner"
  },
  "versionId": "edf08cf7-dfe6-4dba-9af3-b09ae8ba9274",
  "id": "1",
  "meta": {
    "instanceId": "ebb46392e424e813d78ae514dfe7eadd8e90b222c855f1f0e6bf3986d896df42"
  },
  "tags": []
}
(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

type or paste code here

Information on your n8n setup

  • **n8n version:**0.218.0
  • Database you’re using (default: SQLite):
  • **Running n8n with the execution process [own(default), main]:**own
  • **Running n8n via [Docker, npm, n8n.cloud, desktop app]:**cloud

Hey @Giovanni_Cecchini,

When you say you lost connection what do you mean? Like you lost the connection or the interface said there was no connection on the top right?

Hello Jon,
The interface said there’s no connection on the top right.
the message is There might not be enough memory to finish the execution,
Can you help me?

I forgot to tag you @Jon

Hey @Giovanni_Cecchini,

That would normally point towards the memory limit being hit, Can you drop a mail to our support address and include your cloud username / email used to sign up and we can take a look.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.