/mailtools

Tools for working with email: sending bulk mail, extracting email from MacOS address books, and analyzing mail

Primary LanguageHTML

Mail Tools

Right now, this git repository is where we are developing code to process and analyze mail.

What's here?

  • misc -- Miscellaneous tools, including:

Using with GMAIL

  1. Request an App Password https://support.google.com/mail/answer/185833?hl=en
  2. Access GMAIL through imap.gmail.com https://developers.google.com/gmail/imap/imap-smtp

Functionality we want

  • Basic retrieval tools:

    • List email addresses
    • Dates for sender
    • Dates for sender, and # of emails sent/received per day

  • Analytics:

    • Identify cliques
    • Draw a map of what times during the day a person sends and reads mail.
    • Identify where a person is located.

  • parse all iCal entries in mail

  • LDA on email?

  • Top emails every week.

  • Report breaks in mail file. (Days on which mail was not received)

  • Heatmap of when mail is sent

    • weekday / weekend
    • day of week

  • Topic modeling of received messages

    • how many topics?
    • mapping of users to specific topics
    • identify users who email on same topics but do not email each other...?

  • Plug-in to Autopsey

Implementation notes

  • Metadata is stored in an sqlite3 databsae.
  • The schema we use is the same as used by Apple mail client
    • Makes mail tool work with Apple Mail out of the box.
    • Schema is well developed, stored in schema.sql
  • Apple AddressBook groups senders together
    • On non-apple systems, need a tool to do this.

See Also