Parsons authentication training script

script.py

"""
This script was created for the Parsons "All About Authentication" training.
"""

from parsons import Table, Twilio, GoogleSheets

twilio = Twilio()
sheets = GoogleSheets()

# Get data from google sheets

spreadsheet_id = ""   # get from URL 

people = sheets.get_worksheet(spreadsheet_id)

print(f"Got data from Google Sheet {spreadsheet_id} for:")
print(people)

# Send data to Twilio

"""note: the Parsons connector only has a few convenience functions to get data, but we can
access the underlying client"""

for person in people:

    if person['Status'] == "registered":
        message = f"Hi {person['Name']}, please confirm your attendance!"
    elif person['Status'] == "confirmed":
        message = f"Hi {person['Name']}, we're looking forward to seeing you!"
    else:
        continue

    resp = twilio.client.messages.create(
        to=f"{person['Phone #']}", 
        from_="+15005550006",   # magic number from Twilio docs: https://www.twilio.com/docs/iam/test-credentials#test-sms-messages
        body=message)

    print(f"Sent text with id {resp.sid} and message {resp.body} to {person['Name']}")


"""Because we're using test credentials, we can't access our message logs. However if you were
using real credentials you could use the following:

sent_messages = twilio.get_messages()
"""