import requests
import openpyxl
wb_obj = openpyxl.load_workbook("SMS.xlsx")
sheet_obj = wb_obj.active
m_row = sheet_obj.max_row
for i in range(1, m_row):
subscribers = sheet_obj.cell(row=i+1, column=1)
nos = str(subscribers.value)
print(nos)
url = "https://www.fast2sms.com/dev/bulk"
payload = f'''sender_id=FSTSMS&message=Hello and good evening, this is a test message&language=english&route=p&numbers={nos}'''
headers = {
'authorization':"*Your API key from fast2sms.com*",
'Content-Type': "application/x-www-form-urlencoded",
'Cache-Control': "no-cache",
}
response = requests.request("POST", url, data=payload, headers=headers)
print(response.text)