Telegram

Google Forms + Telegram Integration

Sends message to Telegram Groups, Channels, Users on Google Form Submission

What is Form Director?

Form Director is a Google Workspace add-on that directs data submitted from Google Forms to applications like Google Docs, Forms, Sheets, Contacts, Calendar, Tasks, Email, Trello, Slack, QuickBooks etc.

Installation:

It is available in the Google workspace Marketplace.

Please check installation instructions to install the add-on.

What is Telegram?

Telegram is a cloud-based instant messaging and voice over IP service. Telegram client apps are available for Android, iOS, Windows Phone, Windows, macOS and Linux. Users can send messages and exchange photos, videos, stickers, audio and files of any type.

Google Forms to Telegram: Use Case(s)

> Sends message to Telegram Groups, Channels, Users

Google Forms

Sends message to Telegram on Form Submit

Form Director

Telegram

Demo Video: How to send messages to Telegram from Google Form submission?

How to set up Telegram

  • Name your service

  • Choose Telegram from the list of Applications

  • Choose Send under services

Configuring Telegram

Telegram uses HTTP API Token for bot authorization

To know how to get HTTP API Token from BotFather, refer next section.

  • Copy the API Token and paste in the key text box and click on 'Connect to Telegram'.

  • On successful connection it will return your details.

  • Choose and Send Message To (group, private, channel)

  • You can click on refresh button to list last 24 hours activities in bot


Note: Only last 24 hrs activities will list. You need to send message to Group, Channel/ bot before refresh.

How to Create Bot and get API Token from Telegram?

You can find 'The Botfather' here https://telegram.me/botfather or by searching for “BotFather” in the Telegram app.

In the chat with The Botfather, enter “/newbot”. It will ask you for a name then a username for your bot.

Once you provide both, the Botfather will provide you with a link to your bot and an API token.

Follow the link to your bot by clicking the link that looks like t.me/{yourBotUsername}. This is where you will receive messages.

Go ahead and send a message to your bot. To prevent spam, bots cannot initiate a chat, so we need to send it a message to enable the bot to message us back.

How to Add Bot to User?

  • Open your bot account and type"/start" to start a conversation.

How to Add Bot to Channels?

  • Create a private channel in Telegram.

  • Open the private channel and click on the channel name.

  • Click on Administrators.

  • Search for the bot name that you have created.

  • Select the bot account so that it will be added as an admin.

  • The added bot will be displayed as the admin of the channel.



Send some text to channel to initiate a chat with bot.

How to Add Bot to Group?

  • Open your bot account in Telegram.

  • Click on the bot name.

  • Click on the menu( 3 dots) on the top right corner.

  • Click on Info

  • Click on the "Add to group" to add your bot account to the group.


  • Once the Add to group is clicked it will display all the groups from your telegram account.

  • Select the required group and click on ADD.

  • Now your bot account will be added to the group.



Send some text to group to initiate a chat with bot.

Note: How to Initiate a chat with bot?

User: Open the bot and type '/start' and send.

Group: After adding bot into group. send some text to group.

Channel: After adding bot into channel. send some text to channel.

Finally click on "Refresh" button in the add-on to see the updated list of user, group, and channel in the list

Mapping

  • Mapping of form fields to that of app fields is to be done in order to send messages with your form data.


  • Click on the edit mapping.


  • Map the corresponding Form fields with the App fields.


  • Once you have done mapping you can save the service


  • Note : Mapping should be done between app field and form field of same type.

Notification

  • Notify your audience with success or error notifications.

  • Switch on Send Email to send email during execution.

Email Template

  • Send your own customized emails on form submission to your audience.


Attachment

  • Select the attachment to email from file upload in Google Form.

  • Click Pick Drive Files to attach files to Email.

Finish setting up

  • Save service

You are all set to send messages to Telegram on your Google Form submission

Submit the Form

  • Submit the Google Form

See Telegram Chat

  • The form response is send to telegram on Google form submission.