Development of a Python script for automatic processing of official email messages and generating a structured Excel report.
Functionality:
• connection to corporate email via IMAP
• automatic search for new (UNSEEN) emails
• filtering emails by subject and content
• extraction of key data from the text of emails (regex)
• aggregation of data into an Excel file
• appending to an existing report without data loss
• automatic formatting of Excel (column width)
The project works with closed corporate email and personal data, therefore:
• the source code is not published
• examples of emails and finished Excel files are not provided
A screenshot of the script execution process is included in the portfolio.
The project works with internal services. The complete process and logs will be added after a re-run.
Functionality:
• connection to corporate email via IMAP
• automatic search for new (UNSEEN) emails
• filtering emails by subject and content
• extraction of key data from the text of emails (regex)
• aggregation of data into an Excel file
• appending to an existing report without data loss
• automatic formatting of Excel (column width)
The project works with closed corporate email and personal data, therefore:
• the source code is not published
• examples of emails and finished Excel files are not provided
A screenshot of the script execution process is included in the portfolio.
The project works with internal services. The complete process and logs will be added after a re-run.