How to return only a certain amount of rows in Sheets

Questions
1

I’m new to n8n but I use a lot of make.com. They have function that you can return a certain amount of rows. In n8n it will return all the items. How can I specifiy the amount I want it to return?

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:
3

There is a node called “limit” or something similar.
That is the easiest way to limit the nr of items. You can even choose to get the first x amount or last x amount.

1 Like
4

Thank you!

5

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