Answer the question
In order to leave comments, you need to log in
How to get a list of files in a Google Sheets folder?
The user uploads xls files to a certain folder.
The task is to read these files.
There is a lot in the documentation about how to work with a particular table, but there is no (or I don’t find) information on how I can get a list of all tables in a folder, then select the last one loaded and read data from it.
I ask for advice where to dig :)
Answer the question
In order to leave comments, you need to log in
You can try to find out the id of the folder and find files with the desired type in it
get files in the folder
On so there is a discussion on how to get all sheets at once, it can help to find the actual method in the api: link
UPD . Concrete method for getting list of sheets - dock
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question