Any help appreciated.
I don't use Google Sheets API but if you can see clear in the doc:
Then you may be able to just reach the url with specific credentials thanks to
Then build your list.
Many thanks for your help, I'm not sure this is the solution I am looking for and sadly I don't really script web based, so struggling to get the Google Sheets API to work. What I'm after is a script that runs direct from Adobe In-Copy.
Thanks again. Nick