I haven't found a free solution to do it on a schedule (And I just have a few of the tables to load eg once a week to pay for it)

So I am just using this extension from OWOX because it has the Truncate / Overwrite option, which is necessary for me. And they don't charge for it.

However, my task is to be able to query that data in sheets to use in another data mart, which is why I am looking for a suitable solution to not populate data in BigQuery, but make my google sheet SQL accessible...