Presensi hanya isi NIS, google form dan kirim WhatsApp ke ortu Contoh form Contoh inputan form di google sheet Sheet data siswa Sheet data presensi Script di apppscript Ganti Device id, nama sheet data siswa dan data presensi disesuaikan
Membuat chatbot whatsapp terintegrasi dengan Chat GPT dan Google Gemini link chatgpt : https://chatgpt.com/ link google gemini : https://gemini.google.com/app link api key chatgpt : https://platform.openai.com/settings/profile?tab=api-keys link api key google gemini : https://aistudio.google.com/app/apikey tool : wa api gateway : https://whacenter.com google script : https://script.google.com appscript :
study kasus form PPDB, insert google form ke sheet create pdf dan kirim ke WA tanpa autocrat, autogenerate nomor pendaftaran. template form https://docs.google.com/forms/d/1Hace4XNqc9_rzla3Cn663LS6Qx1mHBUAN1YkNciEzMU/copy template formulir pdf https://docs.google.com/document/d/1TeTh3EUdrxubpw4YL6iUcjE5OZBkeIKmuV-RnQB2qPw/copy script :
Kirim broadcast pesan whatsapp tiap penerima pesan berbeda file / gambar dari google spreadsheet video appscript
Get file id dan file name dari file di google drive dan insert ke spreadsheet video app script
tool google spreadsheet : https://docs.google.com/spreadsheets/ google apps script : https://script.google.com/ copy spreadsheet https://docs.google.com/spreadsheets/d/1iGn-it6FtzFEwwfmtN3SuIZhhFSN3tCSG1gU9Mv84GA/copy copy template https://docs.google.com/document/d/1phCyvNHwA2L5fFBgMMKiUwTT28Yksa19EBk_aj6BA9g/copy folder hasil file pdf https://drive.google.com/drive/folders/12eNgg6Op1cfRXTzrsurGgvn_dvo4B3OM?usp=sharing script : https://script.google.com/home/projects/1cIqJdQtHR-ibNqkAmG13XF5J4QFu7HKrjVynKxuGb3SzwVJfsy1no2xl/edit
Kirim broadcast pesan WA dari google spreadsheet tool google spreadsheet : https://docs.google.com/spreadsheets/ google apps script : https://script.google.com/ whatsapp api gateway : https://whacenter.com/ Script :