Create daily outstanding external jobs report in sheet

Your external portal's outstanding jobs leave coordinators without a unified list of manual-close candidates. It creates a daily sheet and emails coordinators so issues are fixed same day.