Welcome to my video
In this video
I show you how to create a ping monitoring tool and send the result message to your phone using Telegram
Let go
First you create your own telegram bot
To create a chat bot on telegram you need to contact the BotFather
which is essentially a bot used to create other bots
The command you need is slash newbot which leads to the following steps to create your bot
Your bot should have two attributes: a name and a username
a name and a username
After choosing your bot name and username, which must end with “bot”
You will get a message containing your access token
and you’ll obviously need to save your access token and username for later
As you will be needing them
Next
Create telegram group and find the ID of that group
Go to web.telegram.org and create a new group
Click on the group you want the chat ID of
use the digits after the g and add dashes before the digits
In the description of this video you will find a link to the video that creates a ping monitoring tool
And I will send the results of that ping monitoring to your phone using Telegram
You will find this ping tool on my YouTube channel or the description of this video
First of all, I create a Sub to test sending messages from Microsoft Excel to Telegram
Here, you need to enter the information you created in the previous step
including chat id, token
Add in the text of the message you want to send
So you have sent a message that says hello to Telegram
So you have sent a message that says Hello to Telegram group using bot
Next you will send a message containing the results of the Ping monitoring to the telegram
You edit a bit to create a function that sends messages to Telegram
You create a new sheet and name it DATA
Here you will save the results of the last ping monitoring attempt
If the ping command is successful
It will return 1
The rest will return 2
This is for the purpose of identifying the outcome change between monitors
Next is the chat id information of your Telegram group
The following commands will help you send the result to Telegram group for each ping command
the result to telegram group for each ping command
The information you get will include your name IP address and the results
Online or offline
As you can see the information you see is too much
This is not necessary
If you only want to receive messages when there is a change do the following
You will only receive a message when there is a change from online to offline or from offline to online
You will compare the two ping monitors to see if there has been a change
thanks for watching don't forget to like and subscribe