I recently put together a simple Google App Script add-on for sheets that retrieves run information from SRA from a GSE, SRP, or PRJNA accession.
The git repository can be found here. All of the code can be found in the Code.gs file.
SRA provides its metadata in XML format, but if you want to create an experimental matrix from public data, you need tabular data. Moreover, going from a GSE accession to a table of run emtadata is non-trivial. This tool allows you to simply pull all run information for a given study with a click of a button.
I'm looking for feedback and future directions for the tool. I'm not bound to the Google App Script platform. I could easily make a web app with this code foundation. I figured a sheets add-on would be very accessible.
Here is an example of output from the script: https://drive.google.com/file/d/1c4_7xwMjuB2de4oJuzhvr2uuODze7UXy/view?usp=sharing