Google drive to Google sheets

Thank you! So if I understand correctly there are subfolders in your main drive folder that you want to read correct? Would the Google Drive Folder Reader node not work here? This node outputs all the files in your selected folder which you can connect to a File Reader node to parse the file content.