How to get ONLY the first 50 rows from Google Sheets?

Hi!

How to get ONLY the first 50 rows from Google Sheets using Google Sheets node?

Without downloading all the data from the table because there are too many rows there.
It is not possible to request all the data - it throws an error: Problem in node ‘Google Sheets‘ Maximum call stack size exceeded

Information on your n8n setup

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

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:

@Mikhail , you need to use the range as shown in the screenshot below.

4 Likes

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