Gmail – Search Emails by Time Period or Week

gmailgmail-filters

Is there any way in Gmail's filtering mechanism to find e-mail messages received or sent:

  • in a given period of a day (each day — only time component of date matters here),
  • in a given period of week (each week).

I need to list (among 26k e-mails) all messages sent or received during nights or weekends.

Any solution suits me:

  • Gmail: temporal filter — list all matching e-mails in main view,
  • Gmail: permanent filter — add specific label to all matching e-mails,
  • non-Gmail: any external tool or solution that can help me achieve above.

If this is possible in Gmail then how should I configure filtering parameters? If this is not possible then is there any tool or solution I should look after?

Best Answer

You can perform searching between two time periods of a day like this:

after:1552896000 before:1552924800

which will list all emails you received between 8:00-16:00 on 18. March 2019
(timestamps were acquired by using https://www.epochconverter.com/)

However, in your case, you will probably need to apply the time interval logic on the far greater time range than a 1 day for which you can try to import all your messages from your Gmail inbox into Google Sheets and then filter out stuff you need by simple QUERY formula. There are various tools and scripts for this task all over the place.

An example would be https://www.integromat.com/en
which comes with a handy tutorial: https://youtu.be/9VNFoxR43II