I’m wondering whether it would be possible to add functionality for dynamic source file names. I currently get this functionality from a Sheetgo competitor called SheetsIE, but I would prefer to have Sheetgo as I’m worried about the long-term support SheetsIE will receive. I’ll elaborate by describing my use case.
Every weekday I get a CSV file from a vendor. This CSV is in a standard format, and the file name is the same except for the date. These files are collected in a folder.
I have a dashboard that I made in a Google Sheet. This dashboard will change according to the date. Because SheetsIE creates its workflow commands from a tab in the sheet (instead of online UI like Sheetgo), I can dynamically specify which file to retrieve from the folder by referencing a cell with the date I want in the SheetsIE workflow instruction tab. I can also query the source file dynamically too, if I wanted.
This is pretty powerful because it creates a true no-code, federated database that can be queried on demand (or a schedule). Yes, it would be much more efficient to create a real database in AWS or Google Cloud, but the learning curve is too high and my use case doesn’t entail a ton of queries, the files being queried aren’t huge (but would be too big if aggregated together), or need low really low execution times.
The closest Sheetgo comes to this is to fetch a file from a folder. But this doesn’t satisfy my use case because I sometimes want to query an older file, and every once in a while, the data files don’t come in the correct order if there’s been delay from the data provider.