This project allows you to send SMS messages by reading data from an .ods file containing two columns:
- Phone number
- Message text
The script reads each row and sends the corresponding SMS through an HTTP POST request to an SMS gateway (e.g., Smshosting or compatible services).
- Reads
.odsfiles usingpandasandodfpy - Sends SMS messages via HTTP POST
- Uses environment variables for secure credential handling
- Prints the delivery status for each message
Your .ods file must contain two columns:
| phone_number | message_text |
|---|---|
| 393123456789 | Hello, this is a test! |
| 393987654321 | Reminder: meeting at 5pm |
No headers are required; the script reads the first column as the phone number and the second as the message.
To avoid exposing sensitive credentials, the login and password must not be stored in the code.
Set the following environment variables:
export SMS_LOGIN="your_login"
export SMS_PASSWORD="your_password"