twilio-birthday-bot.py

import datetime
import requests
import pandas as pd
import re
from twilio.rest import Client
import time

# get birthday list
headers = {'Authorization': 'Bearer YOUR-BEARER-TOKEN-HERE'}
uri = 'https://coda.io/apis/v1beta1/docs/Blf1pjHgNu/tables/eq_birthdays/rows'
res = requests.get(uri, headers=headers).json()

# unpack
items = res['items']

rows = []
for item in items:
    name = item['values']['c-IqS2KcMdol']
    birthday = item['values']['c-8q8TXIknjd']
    phone = item['values']['c-7SJl4vYxT3']
    row = [name, birthday, phone]
    rows.append(row)

df = pd.DataFrame(rows)
df.columns = ['name', 'birthday', 'phone']
df = df.sort_values('name')

# clean birthdays
df['birthday'] = pd.to_datetime(df['birthday'])
df['birthday'] = df['birthday'].dt.strftime("%m-%d")

# clean phone numbers
def remove_chars(s):
    return re.sub('[^0-9]+', '', s)
df['phone'] = '+1' + df['phone'].apply(remove_chars)

# determine current date
today = datetime.datetime.now()
today = today.strftime("%m-%d")

# filter
birthdays = df[df.birthday == today]
print(birthdays)

# create client
account_sid = 'YOUR-ACCOUNT-SID-HERE'
auth_token = 'YOUR-AUTH-TOKEN-HERE'
client = Client(account_sid, auth_token)

# define function
def sendMessage(recipient_number):
    message = client.messages.create(
        body = "Happy Birthday! Have a wonderful day",
        from_ = '+YOUR-TWILIO-NUMBER_HERE',
        to = recipient_number
    )

# send messages
for i in range(0, len(birthdays)):
    recipient_number = birthdays.iloc[i, 2]
    sendMessage(recipient_number)
    print(recipient_number)
    time.sleep(5)