I'm trying to generate a dashboard using information from Google Sheets.
I would like to be able to import the sheet ID dynamically (using URL params), but Redash won't allow it (unless the viewer has full database access) because it's a text parameter.
I get that it might be dangerous if you're using a database to import information (SQL injection), but I don't see why it could be dangerous using Google Sheets.
Is there a work around for this? Am I missing something as to why I shouldn't do this?
Cheers!