timetoreply Academy Videos
      Back to home
      1. Help Center
      2. timetoreply Academy Videos

      Using filters to exclude data

      Learn how to apply filters in timetoreply to exclude irrelevant data and focus on the most important insights.

      📊 Step-by-Step in Google Sheets

      1. Open your spreadsheet

      Let’s say your sender addresses are in Column B (starting from B2).

      2. Create a new column next to it called Sender Type

      3. Use this formula to classify the sender

      Paste this formula into the first cell under Sender Type (e.g., C2):

      excel

      CopyEdit

      =IF(REGEXMATCH(LOWER(B2), "noreply|no-reply|do-not-reply|notification|automated"), "System Notification",

       IF(REGEXMATCH(LOWER(B2), "linkedin"), "LinkedIn",

       IF(REGEXMATCH(LOWER(B2), "newsletter|digest|updates|info@|news@"), "Newsletter",

       IF(REGEXMATCH(LOWER(B2), "free|winner|claim|congratulations|promo"), "Spam",

       "Other"))))

      4. Drag the formula down

      Click the little square on the bottom-right of the cell and drag it down to apply it to all rows.

      🔍 What this does:

      • LOWER(B2) makes everything lowercase (to avoid case mismatches).

      • REGEXMATCH looks for specific patterns (like "noreply" or "info@").

      • It then labels them as:
        • System Notification

        • LinkedIn

        • Newsletter

        • Spam

        • Or Other (likely a real person)

      ✅ Bonus Tips

      • Want to filter out all the skewed entries? Just filter the Sender Type column to exclude “Other”.
      • Want to create your own rules? Add more terms in the REGEXMATCH function like this: newsletter|digest|info@|weekly.

      For more information on timetoreply filters, please refer to the below Help Center articles: