Automation of dashboards in Metabase on daily basis using SQL queries

I have to run SQL queries on daily basis to extract data and use those results to create a dashboard. I would like to automate this process i.e. dashboard should create automatically (on daily basis) and the result should be sent automatically across the team through email. Can I do this in Metabase? If yes, then how?

Hi @rahul2712
Yes, you can use subscriptions on dashboards:
And if you're looking to automate creation of dashboards/etc, then you can use the API:

Thanks, @flamber, this helps me a lot in my work.