Google Forms + Telegram Integration
Sends message to Telegram Groups, Channels, Users on Google Form Submission
You can integrate Google Forms with Telegram using Form Director. Form Director enables you to connect Google Forms with Telegram, allowing you to sends message to Telegram Groups, Channels, Users based on form responses.Â
When a user submits a Google Form, the responses are automatically sent to Telegram Groups, Channels, Users accordingly.
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.
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.Â
Name your service
Choose Telegram from the list of Applications
Choose Send under services
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.
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.
Open your bot account and type"/start" to start a conversation.
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.
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.
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 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.Â
Notify your audience with success or error notifications.
Switch on Send Email to send email during execution.
Send your own customized emails on form submission to your audience.
Select the attachment to email from file upload in Google Form.
Click Pick Drive Files to attach files to Email.
Save service
You are all set to send messages to Telegram on your Google Form submission
Submit the Google Form
The form response is send to telegram on Google form submission.