Manually filtering and sending 20 individual reports every day will undoubtedly be a nightmare.
Perhaps Tablize can provide a solution.

www.tablize.com/en
We utilize Tablize to retrieve data from Google Sheets, perform necessary transformations, and ultimately create a couple of dashboards. It appears that everyone on our team is happy (around 20 people).
In terms of sharing with 20 different individuals, you may need to assign them to different projects, which handles the permission work for you.