Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function substr_count(string,substring,start,length)
- {
- var c = 0;
- if(start) { string = string.substr(start); }
- if(length) { string = string.substr(0,length); }
- for (var i=0;i<string.length;i++)
- {
- if(substring == string.substr(i,substring.length))
- c++;
- }
- return c;
- }
- xxx = "aku sayang kamu";
- function x(){
- const cars = xxx.split(' ');
- let text = "";
- for (let i = 0; i < cars.length; i++) {
- text += cars[i] + "<br>";
- }
- console.log(text);
- }
- // FULL SCRIPT BELOW:
- // How to connect your Telegram Bot to a Google Spreadsheet (Google Apps Script)
- // https://www.youtube.com/watch?v=mKSXd...
- //
- // FILL IN THE GLOBAL VARIABLES token, webAppUrl and ssId
- //
- var token = "1810746550:AAEm7a0NQ6FsBUEMEAtLo-3B7Ul7oacc1u4";
- // FILL IN YOUR OWN TOKEN
- var telegramUrl = "https://api.telegram.org/bot" + token;
- var webAppUrl = "https://script.google.com/macros/s/AKfycbwZ0AWxb6av8VINUkQWmTdY53jt9ljt-GVFEqJmV575zwiGPuLJ/exec";
- // FILL IN YOUR GOOGLE WEB APP ADDRESS
- var ssId = "1sVFpvPk6tPlF7vfD6_68a9AEVvzeiMMjBD9aZ6mx5JE";
- // FILL IN THE ID OF YOUR SPREADSHEET
- function getMe() {
- var url = telegramUrl + "/getMe";
- var response = UrlFetchApp.fetch(url);
- Logger.log(response.getContentText());
- }
- function setWebhook() {
- var url = telegramUrl + "/setWebhook?url=" + webAppUrl;
- var response = UrlFetchApp.fetch(url);
- Logger.log(response.getContentText());
- }
- function sendText(id,text) {
- var url = telegramUrl + "/sendMessage?chat_id=" + id + "&text=" + text;
- var response = UrlFetchApp.fetch(url);
- Logger.log(response.getContentText());
- }
- function doGet(e) {
- return HtmlService.createHtmlOutput("Hi there");
- }
- function doPost(e) {
- // this is where telegram works
- var data = JSON.parse(e.postData.contents);
- var text = data.message.text;
- var id = data.message.chat.id;
- var name = data.message.chat.first_name + " " + data.message.chat.last_name;
- var answer = "Hi " + name + ", thank you for your comment " + text;
- var pesan = "asoe pesan";
- //sendText(id,answer);
- var tixt = data.message.text;
- const cars = tixt.split(' ');
- let balah = "";
- for (let i = 0; i < cars.length; i++) {
- var ss = SpreadsheetApp.getActiveSpreadsheet()
- var sheet = ss.getActiveSheet()
- // Или = ss.getSheets()[0]
- // Или = ss.getSheetByName("nameOfYourSheet")
- var arrData = sheet.getRange(1, 1, sheet.getLastRow(),
- sheet.getLastColumn()).getDisplayValues()
- // Или = sheet.getDataRange().getDisplayValues()
- for(var row = 0; row<arrData.length; row++){
- for(var col = 0; col<arrData[0].length; col++){
- if(arrData[row][col] == cars[i]){
- balah += arrData[row][col+1];
- }
- }
- }
- }
- sendText(id, ''+balah+'')
- if ( /\/start/i.exec(text) ){
- sendText(id, 'halo')
- SpreadsheetApp.openById(ssId).getSheets()[0].appendRow([new Date(),id,name,text,answer]);
- if(/^@/.test(text)) {
- var sheetName = text.slice(1).split(" ")[0];
- var sheet = SpreadsheetApp.openById(ssId).getSheetByName(sheetName) ? SpreadsheetApp.openById(ssId).getSheetByName(sheetName) : SpreadsheetApp.openById(ssId).insertSheet(sheetName);
- var comment = text.split(" ").slice(1).join(" ");
- sheet.appendRow([new Date(),id,name,comment,answer]);
- }
- }
- }
Add Comment
Please, Sign In to add comment