n8n - 💡(How to fix) Fix Google Sheets node "Get Row(s)" returns "No output data" - same as issue #18349

Official PRs (…)
ON THIS PAGE

GitHub issue graph ai analysis

Paste a GitHub issue URL. We fetch that issue, discover linked issues from bodies/comments/timeline, collect linked pull requests, and produce a structured English report.

The report is written in English Markdown for sharing and archival.

Helpful · Quick feedback

Loading…

Error Message

What is the error message

No error message. The node just returns "No output data returned" silently.

RAW_BUFFERClick to expand / collapse

Describe the problem

My Google Sheets node with "Get Row(s)" operation always returns "No output data returned" — even with NO filter applied (should return all rows), even when searching with a fixed string that exactly matches the cell content, and even after reconnecting my OAuth2 credential.

The same credential works PERFECTLY with the "Append Row" operation on a different sheet in the same Google Drive.

I also tried bypassing the node entirely with HTTP Request → Google Sheets API v4 endpoint: https://sheets.googleapis.com/v4/spreadsheets/SPREADSHEET_ID/values/Sheet1

Using "Predefined Credential Type → Google Sheets OAuth2 API" — and it STILL returns no output.

This looks identical to the bug already reported in issue #18349.

What is the error message

No error message. The node just returns "No output data returned" silently.

Steps to reproduce

  1. Create a Google Sheets node with "Get Row(s)" operation
  2. Connect a valid OAuth2 credential (same one that works for Append Row on another sheet)
  3. Set a filter (or no filter at all)
  4. Execute → returns "No output data returned"

Environment

  • n8n cloud
  • Workflow URL: https://nexusa2a.app.n8n.cloud
  • Spreadsheet ID that FAILS on Get: 1K1K9InzwbTQPp65CuQgUMQ2p_s0NSIpvQ0fVjQglYPE
  • Spreadsheet ID that WORKS on Append: 1jdlvzZh2eS2S9eJuH_cTjEOiekkLZ5WJHnlTpEsEQDQ

Time spent debugging

9 hours. Tried: cleaning invisible characters in cells, apostrophe prefix, different filter values, no filter, different columns, Specify Range mode, reconnecting OAuth2, and HTTP Request bypass to Google Sheets API directly.

Could you please check if there's an issue with OAuth2 credential scopes for Read operations on n8n cloud?

Thank you.

Vote matrix · Quick signals

Works
Did the solution work? Tap to confirm.
Easy Fix
Was it a quick fix?
Time Saver
Did it save you time?
Blocking
Was it severely blocking?
Common Issue
Are others likely hitting this too?
Flaky / Intermittent
Is it intermittent?
Verified / Reproducible
Can you reproduce it reliably?
Loading…

Still need to ship something?

×6

Another batch ranked right after the header list — different links, same matching logic.

Back to top recommendations

TRENDING

n8n - 💡(How to fix) Fix Google Sheets node "Get Row(s)" returns "No output data" - same as issue #18349