APIs would help, but you need to use a set of APIs to achieve this.
GET /networks/{networkId}/clients
GET /networks/{networkId}/wireless/clients/{clientId}/connectionStats
GET /networks/{networkId}/clients/{clientId}/usageHistory
So it will involve programming in the end.
I am not a Cisco Meraki employee. My suggestions are based on documentation of Meraki best practices and day-to-day experience.
Please, if this post was useful, leave your kudos and mark it as solved.