How do you create a site workflow to check a list field monthly and email the results

I attempted to create a monthly site workflow that would check items in a list that have not been approved to a "yes" status. Column is a choice field.  The column is either "no" or blank by default however, our team needs a monthly email with the titles, point of contact name, and the approval status of the "no" or blank approval statuses within the entire list.