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:
https://www.metabase.com/docs/latest/users-guide/dashboard-subscriptions.html
And if you're looking to automate creation of dashboards/etc, then you can use the API:
https://www.metabase.com/learn/developing-applications/advanced-metabase/metabase-api.html

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