bot.js

// Created by Evgenii Mironichev, Copyright 2016,
// based on this awesome tutorial: https://mvalipour.github.io/node.js/2015/11/10/build-telegram-bot-nodejs-heroku/

var config = require('./config'); // rename config.js.example into config.js and set keys and tokens inside it

var Bot = require('node-telegram-bot-api');
var bot;

if(process.env.NODE_ENV === 'production') {
  bot = new Bot(config.TelegramToken);
  bot.setWebHook(config.TelegramProductionURL + bot.token);
}
else {
  bot = new Bot(config.TelegramToken, { polling: true });
}

//var Bot = require('node-telegram-bot-api'),
//    bot = new Bot(config.TelegramToken, { polling: true });

console.log('secon-bot server started...');

// Make sure it is public or set to Anyone with link can view 
// "od6" is the fist worksheet in the spreadsheet
var url = "https://spreadsheets.google.com/feeds/list/" + config.googleSheetKey + "/od6/public/values?alt=json";

var moment = require('moment-timezone');

bot.onText(/(.+)$/, function (msg, match) {
    // keywords are anything typed in
  var keywords = match[1];
  var request = require("request");
      
    // send request to retrieve the spreadsheet as the JSON 
    request(url, function (error, response, body) {
        if (error || response.statusCode != 200) {
            console.log('Error: '+error); // Show the error
            console.log('Status code: ' + response.statusCode); // Show the error
            return;
        }
        
        var parsed = JSON.parse(body);
        var targetTime = NaN;
        if (!isNaN(keywords))   // isNaN returns false if the value is number
        {
            try{
                targetTime = parseInt(keywords, 10);
            }
            catch(e){
                targetTime = NaN;
            }
        }
        
        if (isNaN(targetTime))
            targetTime = -1;
        
        var formattedAnswer = "";
        
        // debug purposes: echo from id: 
        // formattedAnswer += "\nMsg.from.id=" + msg.from.id + "\n";
    
        var currentHours = parseInt(moment().tz(config.confTimeZone).format('HH'),10);
        var currentMinutes = parseInt(moment().tz(config.confTimeZone).format('mm'),10);
        // console.log("Current hours: " + currentHours);
        var currentAnswer = "";
        
        var itemsFound = 0;
        // sending answers
        parsed.feed.entry.forEach(function(item){
                // get the time(in hours) from the very first column
                var itemTime = NaN;
                var itemTitle = item.title.$t
                try{
                    itemTime = parseInt(itemTitle, 10);
                }
                catch(e)
                {
                    itemTime = NaN;
                }
                
                if (
                    (!isNaN(itemTime) && itemTime == targetTime) ||
                    (isNaN(itemTime) && itemTitle.toLowerCase().trim() == keywords.toLowerCase().trim())
                    )
                {
                    // add the line break if not the first answer
                    if (itemsFound==0) 
                        formattedAnswer += "At " + targetTime + " these talks will take place:\n\n";
                    else 
                        formattedAnswer += "\n\n";
                        
                    itemsFound++;
                    formattedAnswer += '\u27a1' + item.content.$t; // add item content, '\u27a1' is the arrow emoji
                }
                else if (currentHours == itemTime) // else collect items for the current hour
                {
                    if (currentAnswer == '')
                        currentAnswer == 'Starting from ' + currentHours + " h the following talks are goinf:\n\n";
                    else 
                        currentAnswer += "\n\n"; 
                        
                    currentAnswer += '\u27a1' + item.content.$t; // get item content, '\u27a1' is the arrow emoji
                }
                
                // else doing nothing
        });
        
        // if no items were found for the given time 
        if (itemsFound == 0)
        {
            if (targetTime<0 || targetTime>24)
                formattedAnswer = "Enter the time to show talks or write 'Hi'.\n\n";
            else 
                formattedAnswer = "Can't find events for the given time ( " + targetTime+ " ч)";
                
            // output current answer
            if (currentAnswer != '')
            {
                formattedAnswer += "Hi! As of " + currentHours + ":" + currentMinutes + " " + config.confTimeZone+ " these talks are going:\n";
                formattedAnswer += currentAnswer;
            }
        }
    
        // send message telegram finally
        bot.sendMessage(msg.chat.id, formattedAnswer).then(function () {
            // reply sent!
        });
    
    });

});

module.exports = bot;