S
S
Simon Tis2019-11-09 22:33:51
PHP
Simon Tis, 2019-11-09 22:33:51

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

1 answer(s)
D
Daria Motorina, 2019-11-10
@simon91

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 question

Ask a Question

731 491 924 answers to any question