If I understand correctly:
- you have a table with content list, and associated status
- you have a table with categories list
- you have at least one view that displays the content list, grouped by categories
If my understanding is correct, you wish to send report based on status.
What I suggest, is to use Slice.
Slice for status1, slice for status2, etc.
To do so, please go in the Data/Slice panel, and type in the “Row filter condition”:
[Status]=“Status1” ==> for slice1
[Status]=“Status2” ==> for slice2
Then, create a Automation/bot, that will be based on these slices, to make your report.
Let us know if that’s OK for you !