Gmail - Clean mailbox

Give Feedback | Bug report

Tags: #gmail #productivity #naas_drivers #operations #automation #scheduler

Author: Florent Ravenel

Last update: 2023-05-12 (Created: 2021-04-14)

Description: This notebook helps you quickly and easily organize your Gmail inbox by removing unwanted emails.

Input

Import libraries

In [ ]:

import naas
from naas_drivers import email
import pandas as pd
import numpy as np
import plotly.express as px

Setup Variables

Create an application password following this procedure

username: This variable stores the username or email address associated with the email account
password: This variable stores the password or authentication token required to access the email account
smtp_server: This variable represents the SMTP server address used for sending emails.
box: This variable stores the name or identifier of the mailbox or folder within the email account that will be accessed.
remove_emails_from: This variable stores the list of emails to be deleted in your email box
cron: CRON to be set to schedule your notebook. More info here

In [ ]:

# Inputs
username = "xxxxx@xxxxx"
password = naas.secret.get("GMAIL_APP_PASSWORD") or "xxxxxxxx"
smtp_server = "imap.gmail.com"
box = "INBOX"
remove_emails_from = ["[email protected]"]

# Outputs
cron = "0 20 * * *" #everyday at 8PM

Model

Connect to email box

In [ ]:

emails = email.connect(username, password, smtp_server=smtp_server)

Get email list

In [ ]:

df_emails = emails.get()
print(f"✅ Emails fetched:", len(df_emails))
df_emails.head(1)

Output

Deleting using email id

In [ ]:

for index, df in enumerate(df_emails["from"]):
    sender_email = df["email"]
    uid = df_emails.loc[index, "uid"]
    subject = df_emails.loc[index, "subject"]
    if sender_email in remove_emails_from:
        emails.set_flag(uid, "DELETED")
        print(f"✅ Email '{subject}' from '{sender_email}' removed from mailbox.")

Schedule notebok

In [ ]:

naas.scheduler.add(cron=cron)