Yes, you need multiple Merge-Nodes. You merge the first two Sheets, then the result of that two with the third, and so on. In the last node you will then have the data of all the Sheets.
I tried this with Two Google Sheets and It works like a charm.
But It’ll fetch data from Two sheets. It’ll increase the quota used. I’m asking like. Is there any way we can make it to pick from Only one Sheet at a time?
The alternative which requires some custom code but then at least does then only one request to Google sheets would be to randomly select a document and then only select its data. You can then get a random quote of that document with the same code as you currently have in the “Get Random Row” code:
You should however make sure that you do not have a document which has a very low number of entries because the chance that you will get the same result regularly would be very high.