# import required packages
import pandas as pd
import datetime
import smtplib
import time
import requests
from win10toast import ToastNotifier
# your gmail credentials here
GMAIL_ID = 'your_email_here'
GMAIL_PWD = 'your_password_here'
# for desktop notification
toast = ToastNotifier()
# define a function for sending email
def sendEmail(to, sub, msg):
# connection to gmail
gmail_obj = smtplib.SMTP('smtp.gmail.com', 587)
# starting the session
gmail_obj.starttls()
# login using credentials
gmail_obj.login(GMAIL_ID, GMAIL_PWD)
# sending email
gmail_obj.sendmail(GMAIL_ID, to,
f"Subject : {sub}\n\n{msg}")
# quit the session
gmail_obj.quit()
print("Email sent to " + str(to) + " with subject "
+ str(sub) + " and message :" + str(msg))
toast.show_toast("Email Sent!" ,
f"{name} was sent e-mail",
threaded = True,
icon_path = None,
duration = 6)
while toast.notification_active():
time.sleep(0.1)
# define a function for sending sms
def sendsms(to, msg, name, sub):
url = "https://www.fast2sms.com/dev/bulk"
payload = f"sender_id=FSTSMS&message={msg}&language=english&route=p&numbers={to}"
headers = {
'authorization': "API_KEY_HERE",
'Content-Type': "application/x-www-form-urlencoded",
'Cache-Control': "no-cache",
}
response_obj = requests.request("POST", url,
data = payload,
headers = headers)
print(response_obj.text)
print("SMS sent to " + str(to) + " with subject :" +
str(sub) + " and message :" + str(msg))
toast.show_toast("SMS Sent!" ,
f"{name} was sent message",
threaded = True,
icon_path = None,
duration = 6)
while toast.notification_active():
time.sleep(0.1)
# driver code
if __name__=="__main__":
# read the excel sheet having all the details
dataframe = pd.read_excel("excelsheet.xlsx")
# today date in format : DD-MM
today = datetime.datetime.now().strftime("%d-%m")
# current year in format : YY
yearNow = datetime.datetime.now().strftime("%Y")
# writeindex list
writeInd = []
for index,item in dataframe.iterrows():
msg = "Many Many Happy Returns of the day dear " + str(item['NAME'])
# stripping the birthday in excel
# sheet as : DD-MM
bday = item['Birthday'].strftime("%d-%m")
# condition checking
if (today == bday) and yearNow not in str(item['Year']):
# calling the sendEmail function
sendEmail(item['Email'], "Happy Birthday",
msg)
# calling the sendsms function
sendsms(item['Contact'], msg, item['NAME'],
"Happy Birthday")
writeInd.append(index)
for i in writeInd:
yr = dataframe.loc[i,'Year']
# this will record the years in which
# email has been sent
dataframe.loc[i,'Year'] = str(yr) + ',' + str(yearNow)
dataframe.to_excel('excelsheet.xlsx',
index = False)