Skip to content

fix(Google Sheets Node): Return single row in read operation if combine conditions is OR and 'Return only First Matching Row' #15095

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Conversation

michael-radency
Copy link
Contributor

Summary

Return single row in read operation if combine conditions is OR and 'Return only First Matching Row'

Related Linear tickets, Github issues, and Community forum posts

https://linear.app/n8n/issue/NODE-2907/community-issue-google-sheets-get-rows-returns-multiple-rows-despite
closes #14901

Review / Merge checklist

  • PR title and summary are descriptive. (conventions)
  • Docs updated or follow-up ticket created.
  • Tests included.
  • PR Labeled with release/backport (if the PR is an urgent fix that needs to be backported)

@michael-radency michael-radency added n8n team Authored by the n8n team node/issue Issue with a node labels May 5, 2025
Copy link

@cubic-dev-ai cubic-dev-ai bot left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

mrge reviewed 5 files and found no issues. Review this PR in mrge.io.

@dana-gill dana-gill self-requested a review May 5, 2025 07:47
Copy link

codecov bot commented May 5, 2025

Codecov Report

All modified and coverable lines are covered by tests ✅

📢 Thoughts on this report? Let us know!

@ShireenMissi ShireenMissi requested review from ShireenMissi and removed request for dana-gill May 6, 2025 09:33
Copy link
Contributor

@ShireenMissi ShireenMissi left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Tested manually and it works as expected 👌

Copy link
Contributor

github-actions bot commented May 6, 2025

✅ All Cypress E2E specs passed

@ShireenMissi ShireenMissi merged commit e0f5ba2 into master May 6, 2025
47 checks passed
@ShireenMissi ShireenMissi deleted the node-2907-community-issue-google-sheets-get-rows-returns-multiple-rows branch May 6, 2025 17:32
@github-actions github-actions bot mentioned this pull request May 12, 2025
@janober
Copy link
Member

janober commented May 12, 2025

Got released with [email protected]

ozcangungor pushed a commit to ozcangungor/n8n that referenced this pull request May 25, 2025
…ne conditions is OR and 'Return only First Matching Row' (n8n-io#15095)
etobella pushed a commit to etobella/n8n that referenced this pull request May 25, 2025
…ne conditions is OR and 'Return only First Matching Row' (n8n-io#15095)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
n8n team Authored by the n8n team node/issue Issue with a node Released
Projects
None yet
Development

Successfully merging this pull request may close these issues.

Google Sheets Get Row(s) returns multiple rows despite "Return only First Matching Row" when multiple filters are present
3 participants