Mail -> Sheets, Google Apps Script

I provide tech support and service to a school district via Google Mail. We call these “Service Requests.” The users fill out a form that adds important info to the SUBJECT of the email message. I now have to provide monthly “Support Reports” to my administrators. What I want: At the beginning of each month I want to open the Support Report Spreadsheet launching a script that pulls data from all the conversations of the previous month and adds them to the Support Report. If all goes well, the support report data will be copied to another document and the data will be deleted to be ready again for next month. The columns should be: SENDER - the email address of the sender SUBJECT - the subject of the first message BODY - the body of the first message (getPlainBody then find and replace “\r\n|\n|\r” with “ “) LABELS - list of any labels I’ve added to the conversations Important issues that need to be addressed in this project: *The sheet must collect data for the previous month. *The SENDER, SUBJECT, and BODY should come from the original message sent. I usually add the LABELS when I send the “Done.” message back. * I DON’T want a record for every message in the conversations. Thanks in advance for your consideration of this project. Please let me know what you expect the charges may be. I understand the complexity involved in projects like this. I am flexible if you are also willing to work with me. Let me know if you can think of any enhancements to this project. You may have great ideas I haven't thought of!