I would like to get notified in a an intake process when my column named urgent is tagged as Yes

Can you please help provide guidance on how to structure my page to provide emergency slack notifications to a channel when a table column is marked urgent through automation bot?