Create mail tracking row and draft email for stakeholders
Create mail tracking row and draft email for stakeholders
Incoming mail files in Drive lack tracking and leave project coordinators without correspondence context. It logs each file to a sheet and drafts an owner email so follow-up occurs same day.
Overview
When physical correspondence becomes a folder full of untracked files, project coordinators lose context and follow-up slips. This flow captures each incoming file into a central register and prepares owner email drafts, so stakeholders act on new mail the same day.