With Report Pundit, you can schedule reports to Big Query(Beta)
✔ 1) Open the report that needs to be scheduled
✔ 2) Click the button
✔ 3) Select how often you want to run the report like Hourly, Daily, Weekly or Monthly, and proceed to the next step. Click on Save and continue.
✔ 4) Pick the date & time when the reports need to be delivered. Click on Save and continue.
✔ 5) Select the Gmail account for the Big Query schedule, and it will take to the next page. Report Pundit is not verified. So, select the advanced option and click Go to Report Pundit (unsafe)
✔ 6) On the final step, Grant permission to Report Pundit to complete the setup process.