I am trying to read multiple Google Sheets. I have read all available discussions in community and always batch macro recommended as solution. I created one which accepts workbookID as parameter. It works, by changing workbookID in input batch macro changes file accordingly. But when I put list of workbookID I can get only one file from the top of the list. How can I get all of them?
