🚀Send Google Form Responses to Telegram Instantly (No Zapier!)

Want to get notified on Telegram the moment someone submits your Google Form? Here’s a quick, no-BS guide to set it up using Google Apps Script + Telegram Bot API — all for free, no third-party tools needed.

🧰 What You’ll Need

• A Google Form
• A Telegram bot (via @BotFather)
• Your Telegram chat ID (user or group)
• 10 minutes tops

📲 Step 1: Create Your Telegram Bot

1. Open @BotFather
2. Send /newbot
3. Give it a name and username (e.g., FormAlertBot)
4. Copy the bot token — it looks like: 123456789:ABCdefGhIJKlmnOPqrsTUVwxyz1234567890

🆔 Step 2: Get Your Telegram Chat ID

• For personal use: Start a chat with your bot, then use @userinfobot to get your User ID.
• For group use:

1. Add your bot to the group.
2. Send a message in the group.
3. Use @getidsbot or Bot API to get the group ID. (Usually starts with -100...)

🧙‍♂️ Step 3: Open Your Google Form’s Spreadsheet

1. Click “Responses” → “View in Sheets”
2. In the linked Sheet, go to Extensions → Apps Script

✍️ Step 4: Add This Script

Replace the token and chat ID in this code with your own:

const telegramBotToken = 'YOUR_BOT_TOKEN_HERE';
const chatId = 'YOUR_CHAT_ID_HERE';

function sendTelegramMessage(e) {
  const responses = e.values;

  const message =
    `📝 *New Google Form Submission:*\n\n` +
    `🕒 *Time:* ${responses[0]}\n` +
    `👤 *Name:* ${responses[1]}\n` +
    `📧 *Email:* ${responses[2]}\n` +
    `💬 *Telegram ID:* @${responses[3]}\n` +
    `📌 *Subject:* ${responses[4]}\n` +
    `📝 *Message:* ${responses[5]}`;

  const url = `https://api.telegram.org/bot${telegramBotToken}/sendMessage`;
  const payload = {
    chat_id: chatId,
    text: message,
    parse_mode: 'Markdown'
  };

  const options = {
    method: 'post',
    contentType: 'application/json',
    payload: JSON.stringify(payload)
  };

  UrlFetchApp.fetch(url, options);
}

⏰ Step 5: Set the Trigger

1. In Apps Script → Click the clock icon ⏰ (Triggers)
2. “Add Trigger”

• Function: sendTelegramMessage
• Event type: On form submit
• Deployment: Headless

✅ You’re Done!

Every time someone submits the form, you’ll get a ping like:

📝 New Google Form Submission:
🕒 Time: 4/4/2025 12:53:46  
👤 Name: user-xyz  
📧 Email: xyz@gmail.com 
💬 Telegram ID: @test-1234
📌 Subject: Try  
📝 Message: Test msg

🛠️ Bonus Tips

• Format using parse_mode: 'HTML' if you prefer HTML-style messages
• Use UrlShortener or message trimming if data is too long
• Want to notify multiple chats? Loop through an array of chat IDs

👋 Final Thoughts

This setup is super useful for:

• Support requests
• Lead capture
• Bug reports
• Feedback collection

No middlemen. No fees. 100% yours.