Last active
July 24, 2024 01:51
-
-
Save miftahafina/8316958c94f964753e0d91cce3122d19 to your computer and use it in GitHub Desktop.
Input Data dari WhatsApp ke Google Sheet - Full Tutorial: https://youtu.be/UOpdL3wrivg
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
function doPost(e) { | |
// Buka sheet | |
let sheetUrl = "YOUR_SHEET_URL"; | |
let file = SpreadsheetApp.openByUrl(sheetUrl); | |
let sheet = file.getSheetByName("Sheet1"); | |
// Rapikan data | |
let req = JSON.stringify(e).replace(/\\/g, "").replace("}\"", "}").replace("\"{", "{"); | |
let reqJson = JSON.parse(req); | |
let senderMessage = JSON.stringify(reqJson["postData"]["contents"]["senderMessage"]); | |
// Mengurai isi pesan | |
let parsedMessage = senderMessage.split("#"); | |
// ['"daftar', 'afin', '17/08/1945', 'Indonesia'] | |
let nama = parsedMessage[1].trim(); | |
let tanggalLahir = parsedMessage[2].trim(); | |
let alamat = parsedMessage[3].trim().slice(0, -1); | |
// Membuat ID | |
let row = sheet.getLastRow() + 1; | |
let prefixIdPendaftar = 220000; | |
let idPendaftar = `A-${prefixIdPendaftar + row - 1}`; | |
// Insert data | |
sheet.getRange(`A${row}`).setValue(idPendaftar); | |
sheet.getRange(`B${row}`).setValue(nama); | |
sheet.getRange(`C${row}`).setValue(tanggalLahir); | |
sheet.getRange(`D${row}`).setValue(alamat); | |
// Respon | |
let response = { | |
data: [ | |
{ | |
message: `Terima kasih, ananda ${nama} berhasil terdaftar dengan ID ${idPendaftar}.` | |
} | |
] | |
}; | |
return ContentService.createTextOutput(JSON.stringify(response)); | |
} |
Selalu gagal saat simpan, eror line 5
Error
TypeError: Cannot read properties of undefined (reading 'replace')
doPost @ Kode.gs:8
kode script sdh berhasil aq save dan semua settingan sdh aq sesuaikan baik instal auto reply di hp juga sudah, cuma pas ketika aq coba kirim pesen WA dari nomor lain, dengan format: Daftar # Miftah Afina # 17/08/1945 # Pemalang , koq tidak masuk di sheet google drive secara otomatis ya??? mohon arahan dan petunjuknya bang
@ruudv20 boleh liat kodenya? biasanya permasalahan data tidak masuk sheet bisa jadi karena kesalahan sheet yang dituju
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Halo mas,
Bagaimana jika pemisahnya adalah enter tidak pagar.
contoh form
Pesanan
Nama :
Produk :
Jumlah :