No this is for customer facing dashboards. We are operating in an agency model, sheets is great because of the flexibility. But for all those traditional time series graphs it is a bit cumbersome when data is across multiple sheets and tabs
In particular, Metabase and Superset can be deployed with DuckDB support. You mentioned customer facing dashboards, note that Metabase embedded is not free. Just to say, our SeekTable also has DuckDB connector (and can be used as an embedded BI).
Looks like you got some good suggestions for how to solve your particular problem with sheets in the other comments but feel free to check us out again if you ever move to something like Postgres/MySQL.