Python download and parse email to xls and save attachments
Budget: £20 – £250 GBP
log into microsoft office O365 account (with OAuth workflow) at 5 minute intervals.
Download x days of email (or n most recent emails)
Save details of each email in:
1. Spreadsheet (.xlsx) columns: Message_ID, email_date, email_time, from_email_address, to_email_addresses, cc_emails, email content, number of attachments
2. Spreadsheet 2: Message_ID, email_date, email_time, Attachment_filename
3. Save Attachment files in a folder: filename: Message_ID_Date_Time_Filename
Each time the python script downloads emails, check no duplication. Do not save an email if it is already there.
The Message_ID, should be the microsoft message_ID.
Please tell me how much and what libraries you would use.
Thanks,
Download x days of email (or n most recent emails)
Save details of each email in:
1. Spreadsheet (.xlsx) columns: Message_ID, email_date, email_time, from_email_address, to_email_addresses, cc_emails, email content, number of attachments
2. Spreadsheet 2: Message_ID, email_date, email_time, Attachment_filename
3. Save Attachment files in a folder: filename: Message_ID_Date_Time_Filename
Each time the python script downloads emails, check no duplication. Do not save an email if it is already there.
The Message_ID, should be the microsoft message_ID.
Please tell me how much and what libraries you would use.
Thanks,