How to create a bot based on table but not row

[jmable]

I would like to create a Bot that sends ONE SMS message based on data in the table.

For example, I have a table full of questions. I want to send an alert every night to someone if there is QuestionStatus = "Unanswered" and it's assigned to them. So if they have 5 unanswered questions I only want to send 1 alert. 

If I deselect the ForEachRowInTable I'm not able to build the event condition based on a table (unless I'm missing something). In my mind I check the count of a select statement and if it's > 0 send the SMS just once. 

Any idea if that's possible and if so how?

[SkrOYC]

You need a Users table, that's the one that should be queried