Hi all,

I have a folder with several google sheets documents that will be shared with different individuals. I then run a webquery to pull these into excel for some analysis.

The issue I have is that I will need to produce this for many different groups of people and therefore will need to individually publish to web and copy/paste the URL into excel.

What I need is a way of publishing multiple documents and retrieving the URL for each into another sheet.

I'm sure this can be done but I've not managed to muster an answer in two weeks!

Any help would be greatly appreciated.
Thank you,
Tim