Created
April 1, 2024 07:49
-
-
Save kuatroestrellas/22867ed5b3fc92ccc04f23c4be1e0399 to your computer and use it in GitHub Desktop.
Envía mensajes de google sheet a whatsapp
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
// tutorial https://youtu.be/jh5-Cc39ovc | |
function senMessage(testo){ | |
var url = 'https://api.callmebot.com/whatsapp.php'; | |
var payload = { | |
"phone": "TU NUMERO", | |
"text": testo, | |
"apikey": "TU API KEY" | |
}; | |
var options = { | |
'method': 'get', // Utiliza el método 'get' para enviar los parámetros en la URL | |
'muteHttpExceptions': true // Opcional: suprime las excepciones HTTP si es necesario | |
}; | |
// Realiza la solicitud HTTP al webhook | |
var response = UrlFetchApp.fetch(url + '?phone=' + payload.phone + '&text=' + encodeURIComponent(payload.text) + '&apikey=' + payload.apikey, options); | |
Logger.log(response.getContentText()); | |
} | |
function onEdit(e){ | |
var sheet = e.source.getActiveSheet(); | |
var range = e.range; | |
var columnB = 2; // Tiene el índice 2 (los índices comienzan desde 1) | |
// Verifica si la celda editada está en la columna F y contiene el valor "SI" | |
if(range.getColumn()===columnB && range.getValue() === "SI"){ | |
var mensaje = sheet.getRange(range.getRow(), 1).getValue(); | |
senMessage(mensaje); | |
} | |
} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment