Retriving and Sending Whatsapp Using BAKWAN and DAWET
pip install -r requirements.txt to using this program :
from lib import dawet, bakwan, mietektek
import time
meet = mietektek.Mietektek()
sending = bakwan.Bakwan()
getNilai = dawet.Dawet("Filename in Google Spreadsheet")
getWa = dawet.Dawet("Filename in Google Spreadsheet")
worksheet_number= 0
#get data wa_ortu, npm, name
wanumortu = getWa.getData("row name", "column name", worksheet_number)
wanumpem = getWa.getData("row name", "column name", worksheet_number)
npmnum = getWa.getData("row name", "column name", worksheet_number)
name = getWa.getData("row name", "column name", worksheet_number)
truemessage = "Anak anda dengan npm : " + npmnum + " " + name + " belum melaksanakan bimbingan!"
falsemessage = "Anak anda dengan npm : " + npmnum + " " + name + " telah melaksanakan bimbingan!"
meet_for_guidance = "column name"
guidance_meet = meet.Bimbingan(meet_for_guidance)
getValue = getNilai.getData("row name", meet_for_guidance, worksheet_number)
if getNilai.getData("row name", "column name", worksheet_number) == "0":
#sending message
sending.sendNumber(wanumortu, truemessage)
time.sleep(1)
sending.sendNumber(wanumpem, truemessage)
else:
#sending message
sending.sendNumber(wanumortu, falsemessage)
time.sleep(1)
sending.sendNumber(wanumpem, falsemessage)- add your client_secret.json for google spreadsheet api
- create lib directory then create __init__.py file in lib directory, then put bakwan.py, dawet.py, and mietektek.py to lib directory