Google Sheets Get Row(s) Returns Multiple Rows Despite "Return Only First Matching Row" When Multiple Filters Are Present

by ADMIN 122 views

Introduction

Google Sheets is a powerful tool for data manipulation and analysis. However, when using the 'Get Row(s)' operation with multiple filters, unexpected behavior can occur. In this article, we will explore a specific issue where the 'Return only First Matching Row' flag is not functioning as expected when multiple filters are present.

Bug Description

The issue at hand is a bug in the 'Get Row(s)' operation of a Google Sheets node. The node is configured to use two filters combined with an OR operator, and the 'Return only First Matching Row' flag is activated. However, instead of returning only one row that matches the combined filters, the operation returns multiple rows.

Debugging Information

The debugging information provided includes a Debug Info.txt file, which can be accessed through the following link: Debug Info.txt. This file contains detailed information about the issue, including the node configuration and the data used for testing.

Expected Behavior

The expected behavior of the 'Get Row(s)' operation is to return only one row that matches the combined filters. In this case, the expected behavior is to return row 2, which has a 'Writing status' of 'Pending' and an 'Image status' of 'Pending'.

Actual Behavior

However, the actual behavior of the operation is to return multiple rows. In this case, the operation returns rows 2 and 6, which both match the combined filters. This behavior is unexpected and does not align with the 'Return only First Matching Row' flag.

To Reproduce

To reproduce this issue, follow these steps:

  1. Setup Node: Create a new node using the 'Get Row(s)' operation. Configure the node to use two filters combined with an OR operator.
  2. Fill Dummy Sheet: Fill a dummy sheet with values as described in the bug description. In this case, the sheet should have 'Done' for the 'Writing status' in rows 2 to 5, and 'Pending' for all other rows. The 'Image status' should be 'Pending' for all rows.
  3. Run Node: Run the node and observe the output.

Operating System

The operating system used for testing is Docker (self-hosted).

n8n Version

The version of n8n used for testing is 1.89.2.

Node.js Version

The version of Node.js used for testing is 20.19.0.

Database

The database used for testing is PostgreSQL.

Execution Mode

The execution mode used for testing is the main (default) mode.

Conclusion

In conclusion, the 'Get Row(s)' operation of a Google Sheets node is not functioning as expected when multiple filters are present. The 'Return only First Matching Row' flag is not being honored, and multiple rows are being returned instead of one. This issue can be reproduced by following the steps outlined in the 'To Reproduce' section. The expected behavior is to return only one row that matches the combined, but the actual behavior is to return multiple rows.

Recommendations

To resolve this issue, we recommend the following:

  • Review Node Configuration: Review the node configuration to ensure that the filters are correctly combined using the OR operator.
  • Verify Filter Logic: Verify the filter logic to ensure that it is correctly implemented and not causing the issue.
  • Test Node: Test the node with different data sets to ensure that the issue is not specific to the test data used.

By following these recommendations, you can help to resolve the issue and ensure that the 'Get Row(s)' operation of the Google Sheets node is functioning as expected.

Future Development

In the future, we recommend that the n8n development team reviews the 'Get Row(s)' operation to ensure that it is functioning correctly when multiple filters are present. This can be achieved by:

  • Implementing Correct Filter Logic: Implementing the correct filter logic to ensure that the 'Return only First Matching Row' flag is honored.
  • Testing Node: Thoroughly testing the node with different data sets to ensure that the issue is not present.
  • Providing Clear Documentation: Providing clear documentation on how to use the 'Get Row(s)' operation with multiple filters, including examples and use cases.

Q: What is the issue with the 'Get Row(s)' operation in Google Sheets?

A: The issue is that the 'Get Row(s)' operation returns multiple rows when multiple filters are present, despite the 'Return only First Matching Row' flag being activated.

Q: What are the expected and actual behaviors of the 'Get Row(s)' operation?

A: The expected behavior is to return only one row that matches the combined filters. However, the actual behavior is to return multiple rows.

Q: What are the steps to reproduce this issue?

A: To reproduce this issue, follow these steps:

  1. Setup Node: Create a new node using the 'Get Row(s)' operation. Configure the node to use two filters combined with an OR operator.
  2. Fill Dummy Sheet: Fill a dummy sheet with values as described in the bug description. In this case, the sheet should have 'Done' for the 'Writing status' in rows 2 to 5, and 'Pending' for all other rows. The 'Image status' should be 'Pending' for all rows.
  3. Run Node: Run the node and observe the output.

Q: What are the operating system, n8n version, Node.js version, database, and execution mode used for testing?

A: The operating system used for testing is Docker (self-hosted). The version of n8n used for testing is 1.89.2. The version of Node.js used for testing is 20.19.0. The database used for testing is PostgreSQL. The execution mode used for testing is the main (default) mode.

Q: What are the recommendations to resolve this issue?

A: To resolve this issue, we recommend the following:

  • Review Node Configuration: Review the node configuration to ensure that the filters are correctly combined using the OR operator.
  • Verify Filter Logic: Verify the filter logic to ensure that it is correctly implemented and not causing the issue.
  • Test Node: Test the node with different data sets to ensure that the issue is not specific to the test data used.

Q: What are the future development recommendations to ensure that the 'Get Row(s)' operation is functioning correctly?

A: In the future, we recommend that the n8n development team reviews the 'Get Row(s)' operation to ensure that it is functioning correctly when multiple filters are present. This can be achieved by:

  • Implementing Correct Filter Logic: Implementing the correct filter logic to ensure that the 'Return only First Matching Row' flag is honored.
  • Testing Node: Thoroughly testing the node with different data sets to ensure that the issue is not present.
  • Providing Clear Documentation: Providing clear documentation on how to use the 'Get Row(s)' operation with multiple filters, including examples and use cases.

Q: What are the benefits of resolving this issue?

A: Resolving this issue will ensure that the 'Get Row(s)' operation of the Google Sheets node is functioning correctly and providing the expected results. This will improve the overall accuracy and reliability of the node, and reduce the risk of errors and inconsistencies.

Q: How can I provide feedback or report issues related to the 'Get Row(s)' operation?

A: You can provide feedback or report issues related to the 'Get Row(s)' operation by submitting a bug report or feature request through the n8n issue tracker. This will help the n8n development team to identify and prioritize issues, and ensure that the node is functioning correctly and meeting the needs of users.