Very interesting, good to see such use-cases around google sheets, much needed. I'm building an open-source Reverse ETL tool to run SQL query from data warehouse and send results into Google Sheets and many more.
(https://github.com/Multiwoven/multiwoven)
All the best :)