Total lines Spreadsheet

Questions
1

Is it possible to get the number of lines it read from the parameters of a Spreadsheet node?

with some javascript code or something like that

for example, to get the total number of lines in a Split In Batches just use the expression {{ $(‘Split In Batches’).context[“maxRunIndex”] }}

2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
1 Like
3

You can get the number of incoming items a node receives with:

{{ $input.all().length }}

and the number of outgoing items of another node with:

{{ $('NodeName').all().length }}
3 Likes
4

Muito Obrigado

1 Like
5

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