When we try to use the Google Sheets node to Get Row(s) with mode than one spreadsheet id input, it always output the data from the first spreadsheet id only as many inputs as we have.
How to run it:
Create two or more spreadsheet files in google drive and create the access credentials in n8n.
Create a Code node to return two or more spreadsheets ids.
Connect it to a Google Sheets node to retrieve data from the previous node spreadsheet id. ({{ $json.id }})
It is odd that the step doesn’t work like this in the first place, but here’s a workaround.
You can use a loop step in between the code and google sheet.
Hope this workflow helps!
If this post resolves your issue, make sure to mark it as the solution so others can benifit from the answer.
Hi, @rbreen , thanks for giving attention to this.
Yes, it works using the loop node. Thank you very much. But I still want to make it with the google sheets node only because I personally think it is a better practice and maybe it is some bug.
Anyway, thank you for your help with a second way of doing it!! I will let the forum open a little bit more to check if it is relly a bug or if I’m doing something wrong.
Solution.