Google sheet node with filter doesn't work and returns more results than in google sheets

Questions
1

Describe the problem/error/question

My triggered workflow is having a problem. The Google Sheets read. node has a filter in it that is not working. Instead of returning the filtered data its returning 9360 rows, where the sheet its reading only has 6095 rows.

Screenshot 2024-11-20 at 09.27.46

I tried to fix it by adding an extra filter node after the Google Sheets read, but its still passing the unfiltered data through.

The weird thing is that it doesn’t happen when I manually trigger the node.

Screenshot 2024-11-20 at 09.27.53

What seems to be the problem?

What is the error message (if any)?

The service is receiving too many requests from you. This error is in a later node and unrelated, as it should give this error if there are that many result going through.

Please share your workflow

The workflow was to big so I will only share the first three nodes.

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.34.2
  • Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
  • **Database (default: SQLite):**SQLite
  • n8n EXECUTIONS_PROCESS setting (default: own, main): own
  • Operating system: Linux
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

Hi @LinkedUp_Online,

Thanks for sharing all the details :muscle:
I’m not being able to reproduce the behaviour…
First thing I would do is update your instance to a later version if you can. Latest one is v.1.67.1 and the Google Sheets node was updated a couple of times since v.1.34.2. Releases · n8n-io/n8n · GitHub

If you’re still seeing the same issue after that could you also share some pinned data in your wf? :raised_hands:

5

Hi!

Thanks for the tips!

I just updated to 1.68.0.

It didn’t fix the problem.

What kind of data do you mean?

Output from the google sheets read node?

Best,

Mark

6

@mariana-na anyway you can help me? :pray:

7

Hi can anyone help me out with this? Its costing me a lot of time to keep running my workflows manually.

8

@jan I am trying to get support here but I am getting no responses. Can you tell what I am doing wrong in my request? :pray:

9

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