Streaming Results to google Sheets with Authentication

1. What is the issue? Please be detailed.

In short, I want to be able to stream submissions to Google Sheets and allow me to click on any submitted media filenames to download those files without the requirement of having to log in to ODK Central.

I use Google Sheets to run various mailmerges which produce PDF reports so if I can get the

I can workaround the data streaming via various methods but I am stuck on the authentication. I can also generate the full URL to the files using concatenate.

Any assistance would be appreciated

2. What steps can we take to reproduce this issue?

Try to click on an image link in Google Sheets and it asks me to sign in to ODK Central (if my browser auth token has expired)
3. What have you tried to fix the issue?

I think that I have tried everything. I am currently downloading the CSV and media files and then uploading them to a webserver, and then pulling those in to a Google Sheet but this is a long winded approach.