Sales Goal

Status: Finished ✅

Software designed to read sales tables, check if it has reached the sales goal, identify the salesperson who hit the goal and send a SMS notifying that it has reached the target.

Technologies Used:

Technology	Python	Openpyxl	Pandas	Twilio
Version	3.9.6	3.0.7	1.2.4	6.63.0

How to run the application:

1. Install all dependencies;

2. Add your sales sheets for each month;

   

3. Create a free Twilio account;

4. Get your account_sid, auth_token and your trial phone number;

   # Your Account SID from twilio.com/console
   account_sid = "W"
   
   # Your Auth Token from twilio.com/console
   auth_token = "X"
   
   # Trial phone number
   from_="Z",
   

5. add your phone number to receive the SMS;

   # Your phone number
   to='Y',
   

6. Update the sales target value in code;

   if (sales_table['Sales'] > 55000).any():
       seller = sales_table.loc[sales_table['Sales'] > 55000, "Seller"].values[0]
       sales = sales_table.loc[sales_table['Sales'] > 55000, "Sales"].values[0]
   

7. Run.

SMS Template:

• The software identifies and shows through SMS the salesperson who reached the goal and also how much he made in sales

License

This project is licensed under the MIT License - see the LICENSE page for details.