`npx gmail-mbox-stats mymail="leodevbro@gmail.com" mboxpath="./All mail Including Spam and Trash.mbox"`
the notation `./` means to find the file `All mail Including Spam and Trash.mbox` in the current folder of the terminal.
That's it.
Now just see the results:
It will take probably 5-10-15 seconds to analyze 1000 mails (messages),
about 100 seconds for 10K mails,
about 1000 seconds (10-15-20 minutes) for 100K mails and so on.
- When it finishes, the terminal will log basic information like this: ``` Success. Full count of messages: 18686 Messages where sender is --> me: 495 Count of mails with at least one attachment: 148 Total count of attachments: 231 Total size of attachments: 120.800749 MB => Million Bytes Unique sender addresses: 1 Unique sender domains: 1 Unique receiver addresses: 285 Messages where sender is not me: 18191 Count of mails with at least one attachment: 850 Total count of attachments: 2409 Total size of attachments: 231.40515899999997 MB => Million Bytes Unique sender addresses: 1473 Unique sender domains: 804 Unique receiver addresses: 94 Created new folder "mailStats_2024-11-15_21-28-13" Start datetime: 2024-11-15_21-28-13 ->End datetime: 2024-11-15_21-30-13 Full Execution Time: 2:00.411 (m:ss.mmm) gmail-mbox-stats v1.2.3 Created by leodevbro (Levan Katsadze) * leodevbro@gmail.com * linkedin.com/in/leodevbro * github.com/leodevbro * facebook.com/leodevbro If you feel like donating * buymeacoffee.com/leodevbro * ko-fi.com/leodevbro ``` - Also, there will be a new folder named "mailStats" with execution start datetime,
like this: `mailStats_2024-11-15_21-28-13`
in the same folder where the MBOX file is located.
- In the 'mailStats' folder, there will be `generalStats.csv` file. If you import it in Google Sheets it will look like this:
- In the 'mailStats' folder, there will be also two folders:
`forMailsWhereSenderIsMe` - the stats for only the mails where sender is you.
`forMailsWhereSenderIsNotMeOrIsUnknown` - the stats for only the mails where sender is not you, or sender is unknown.
In both folders, there will be `.csv` files of stats. You can import them one by one in Google Sheets. Here is what the full folder structure looks like: ``` ▨ All mail Including Spam and Trash.mbox 📂 mailStats_2024-11-15_21-28-13 ▦ generalStats.csv 📂 forMailsWhereSenderIsMe ▦ me_attachmSizeReceiver.csv ▦ me_attachmSizeSender.csv ▦ me_attachmSizeSenderDomain.csv ▦ me_freqBcc.csv ▦ me_FreqCc.csv ▦ me_FreqReceiver.csv --- Here you can find the receivers where you sent most mails ▦ me_FreqSender.csv ▦ me_freqSenderDomain.csv ▦ me_freqSenderPlusName.csv 📂 forMailsWhereSenderIsNotMeOrIsUnknown ▦ notMeOrUnkn_attachmSizeReceiver.csv ▦ notMeOrUnkn_attachmSizeSender.csv ▦ notMeOrUnkn_attachmSizeSenderDomain.csv ▦ notMeOrUnkn_freqBcc.csv ▦ notMeOrUnkn_FreqCc.csv ▦ notMeOrUnkn_FreqReceiver.csv ▦ notMeOrUnkn_FreqSender.csv --- Here you can find the senders which sent most mails ▦ notMeOrUnkn_freqSenderDomain.csv ▦ notMeOrUnkn_freqSenderPlusName.csv ```
Now, for example, let's import the file `notMeOrUnkn_freqSender.csv` in Google Sheets:
 Also, some other files: `me_freqReceiver.csv`
`notMeOrUnkn_freqSenderDomain.csv`
`notMeOrUnkn_freqSenderPlusName.csv`
`notMeOrUnkn_freqReceiver.csv`
`notMeOrUnkn_freqCc.csv`
Thank you.
My name is Levan Katsadze (ლევან კაცაძე), 1995-03-03, from Tbilisi, Georgia (Not USA).
