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.

Create mail tracking row and draft email for stakeholders

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.

Create mail tracking row and draft email for stakeholders