Query from JSON?

Questions
1

Hi everyone

Can I probably get query from a loaded JSON?

In my case:

  • I want to get a table information from google sheets.
  • I want to get query just rows that for example their ID column is 1.
2

Ah yes, you can do that either with a Function-Node and some code or I will release in the next days a new version of n8n with an addition to the Google Sheets-Node. That will then allow returning all matching rows.

1 Like
3

Hi dear@jan
Are there any updates from Google sheets?
Best regards

4

No sadly not yet. Simply way to much stuff to do.

5

@mooghermez Have good news. Now finally found some time to look into that. So it is now possible to add the option “Return All Matches”. If it gets added and set to true it will return all matches.

Got released with [email protected]

6

It’s so fantastic.
It (Return All Matches in Google Sheets) works exactly as I expect.
Thank you dear @jan

7

Thats great to hear! Have fun!