1. Telegram Bot Creation (Example : @Strenure_bot, which you can check on telegram)

• Go to Telegram and search for @BotFather

• Start a chat → Use command /newbot

• Enter your bot name → e.g., @Strenure_bot

• Choose a unique username ending in bot → e.g., strenure_alerts_bot

• BotFather returns:

  ✅ Bot Token (Important – Save this securely)

2. Google Forms Setup (3 Forms)

• Create or open 3 different Google Forms (e.g., Lead Form, Feedback Form, Signup Form)
• Go to Responses → Linked Google Sheets
• Each form should now be tied to its own spreadsheet (one per form)

3. Telegram Bot Integration via Google Apps Script

For Each Form (Repeat 3x):

🔁 Google Sheet → Extensions → Apps Script

Paste the following code (customized for your bot):

function sendTelegramNotification(e) {
  var token = 'YOUR_TELEGRAM_BOT_TOKEN'; // Replace with Strenure.bot token
  var chatId = 'YOUR_TELEGRAM_CHAT_ID'; // Your group/user chat ID
  var formData = e.namedValues;
  
  var message = "🚨 *New Form Submission!*\\n\\n";
  for (var field in formData) {
    message += `*${field}*: ${formData[field]}\\n`;
  }

  var url = `https://api.telegram.org/bot${token}/sendMessage`;
  var payload = {
    'chat_id': chatId,
    'text': message,
    'parse_mode': 'Markdown'
  };
  
  var options = {
    'method': 'post',
    'contentType': 'application/json',
    'payload': JSON.stringify(payload)
  };

  UrlFetchApp.fetch(url, options);
}

4. Script Trigger Setup (Form Submit Trigger)