N8N - Google Sheet Node is overwhelmed

Fragen
1

Hello everyone, today I had a issue with Google Sheets on N8N. I’m not sure it’s something it can be fixed. But basically I have a client that owns a marketplace (to buy food and other sort of itens) and basically our Agent is meant to read their Google Sheet with a list of all of their available itens and pass to their clients on WhatsApp.

The problem is that the sheet has 9000 itens and when I tried to run my workflow, it crashed my workspace. I believe this happen because the file is too large in content and was hoping for some help on the matter, thanks in advance!

Information on your n8n setup

  • **n8n version:1.78.1
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • **Running n8n via : n8n cloud
  • **Operating system:Windows
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

You can process items per batch, instead of trying to get everything at once:

Using a Loop node achieves this.

In the example below I’m using a variable count to only get information from one day at a time. Starting today and going backwards.

.

If my reply solves your problem, please remember to mark it as a solution.