Problem: I need to keep a comms log for emails sent by my teams to other teams. We are running a multiyear project that has over 150 customers. We often escalate and get responses from directors asking when we have sent past messages, often requiring us to dig back in our emails and figure out who sent 'what' to 'who' and 'when'.
Solution: I created a google form that my team can fill out every time they send a 'comms' email as part of this project. This allows us to track when emails were sent, to whom they were sent to, and when they were sent.
Question: Can I automate this? I would like to avoid having my team fill out this form manually every time. We are on GSuite, so I am wondering if there is potential to use the Gmail API or Google Apps Script to enable the automation of this step. Essentially I would want to capture the From, To, Cc, Subject, and Date Time Stamp of each email. I am also open to some form of group inbox that can be Cc'd that has a listener in it that will fill out the form or even better yet put the data straight into the Google Sheet.
What I have Tried: I have looked over the Google Apps Script API and have not found something that directly helps me. I have looked over the Gmail API but I did not find it very helpful to my query. I have googled a lot, but almost everything is focused on send emails from Google Sheets, not capturing information about sent emails.
Limitations: I am not a GSuite admin. I have limited technology stack to support this so I am stuck with GSuite.