Google Sheet Trigger - Range Error

whne using a google Sheet trigger, and setting the Options → Data location → First Data Raw, the workflow ignores the input number and starts from the beginning.

In my scenario, i have a spreadsheet with about 1300 raws, and i wanted to start the workflow from raw 1250, but the system still started from the beginning

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:

Hey @life.tripod , I believe your concern is the UI message “First row is row 1”. It appears to be misleading. The trigger itself seems to be working fine. Any changes made before the specified data row should not trigger the workflow. If it still is, could you provide the details of your environment, please?

That is exactly the issue: although I have put 1257, the node starts reading the spreadsheet from raw 1.

n8n version: 1.58
environment: docker
OS: ubuntu server
all other options: Default
Workflow:

  1. When a new raw is added start the workflow
  2. Start from raw 1257

Hey @life.tripod , when I tested all the raws where returned too but only at the very first run of the trigger. All the subsequent updated were coming in starting with the actual raw specified.

Are you saying that once the trigger activated all the raws (starting from 1) are return with every update, not just the first one?

Thanks, I bypassed the issue by creating a filter, but the solution is less than optimal

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