With Report Pundit, you can schedule reports to Big Query(Beta)
✔ 1) Open the report that needs to be scheduled
✔ 2) Click the schedule button
✔ 3) Select how often you want to run the report like Hourly, Daily, Weekly or Monthly, and proceed to the next step.
✔ 4) Pick the daily time the reports need to be delivered. Select Save and continue or "Advanced Schedule" for an advanced scheduling option.
✔ 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.