Accessing many spreadsheets from a script

[Keith Winston]

Hello,

I've got thousands of spreadsheets generated by a template process. I expected one day I would want to mine information from them, and here we are.

How can I pull information from them without doing a file-by-file authorization/linking process? That is really slow and troublesome, and might end up being done repeatedly because... life.

If it does come down to that, is there anything I can do at the file-generation stage (they are generated by a script using a template, and their permissions/sharing are set up at that time) that would at least make it easier on future versions?

Thank you.

Regards,
Keith

[Raja Anirudh Reddy Sarikonda]

Hey Keith,

You can capture the spreadsheet id at the creation stage and store them in another spreadsheet. This will make it easier to programmatically access them later on.

[Keith Winston]

Perhaps I wasn't clear:

I can get a list of names, or URL's, or ID's, of the files I want to access. From those files I can attempt to pull data with importrange. However, it asks me to grant permission to access each file individually. There are thousands of files. Is there a better way to do this?