JSON Workflow Template: Get Telegram User info & Save to Google Sheet

[Di_B]

1. Create Google Sheet with the following column names:

• message.from.id
• message.from.is_bot
• message.from.first_name
• message.from.last_name
• message.from.username
• message.from.language_code
• message.from.phone_number

2. Save this text as a JSON file & import to your n8n Workflow:

Get_Telegram_User_Information.json

@Save to a Json File

{
“name”: “Get Telegram User Info”,
“nodes”: [
{
“parameters”: {
“updates”: [
“message”
],
“additionalFields”: {}
},
“name”: “Telegram Trigger”,
“type”: “n8n-nodes-base.telegramTrigger”,
“position”: [
-1460,
60
],
“typeVersion”: 1,
“id”: “3e14da17-46ae-4e4a-b578-3bc938e362be”,
“credentials”: {
“telegramApi”: {
“id”: “3”,
“name”: “Telegram account”
}
}
},
{
“parameters”: {
“chatId”: “={{$node["Telegram Trigger"].json["message"]["chat"]["id"]}}”,
“text”: “=Thanks for sharing your info:\nID: {{ $node.Set1.json.message.from.id }}\nFN: {{ $node.Set1.json.message.from.first_name }}\nLN: {{ $node.Set1.json.message.from.last_name }}\nLANG: {{ $node.Set1.json.message.from.language_code }}\nUSR: {{ $node.Set1.json.message.from.username }}\nPhone: {{ $node.Set1.json.message.contact.phone_number }}”,
“additionalFields”: {}
},
“name”: “Telegram”,
“type”: “n8n-nodes-base.telegram”,
“position”: [
-80,
-620
],
“typeVersion”: 1,
“id”: “2cf05ffa-9980-4447-a44a-c0cbc6abed93”,
“credentials”: {
“telegramApi”: {
“id”: “3”,
“name”: “Telegram account”
}
}
},
{
“parameters”: {
“jsCode”: “// Access your Telegram Bot token from n8n environment variables\n const token = ‘====TELEGRAM_BOT_TOKEN====’ \n\n\n\n\n// Loop over input items and add a new field\n// called ‘myNewField’ to the JSON of each one\nfor (const msg of $input.all()) {\n //msg.json.message.chat.myNewField = 1;\n const chatId = msg.json.message.chat.id;\n\n const text = ‘Please share your phone number:’;\n const replyMarkup = {\n keyboard: [[{\n text: ‘Share Phone Number’,\n request_contact: true\n }]],\n one_time_keyboard: true\n };\n\n const url = https://api.telegram.org/bot${token}/sendMessage;\n const payload = {\n chat_id: chatId,\n text: text,\n reply_markup: replyMarkup\n };\n\n const options = {\n method: ‘POST’,\n headers: {\n ‘Content-Type’: ‘application/json’\n },\n body: JSON.stringify(payload)\n };\n \n msg.json.message.chat.SharePhoneButtonUrl = url;\n msg.json.message.chat.SharePhoneButtonPayload = payload;\n\n}\n\nreturn $input.all();”
},
“id”: “0995a102-46c9-4a9c-9ed5-ac283b2d1e51”,
“name”: “Telegram Share Button”,
“type”: “n8n-nodes-base.code”,
“typeVersion”: 1,
“position”: [
-480,
80
]
},
{
“parameters”: {
“method”: “POST”,
“url”: “={{ $json.message.chat.SharePhoneButtonUrl }}”,
“sendBody”: true,
“specifyBody”: “json”,
“jsonBody”: “={{ $json.message.chat.SharePhoneButtonPayload }}”,
“options”: {}
},
“id”: “394e1768-d19b-4c6e-8eaf-a4e63f71e26c”,
“name”: “HTTP Request”,
“type”: “n8n-nodes-base.httpRequest”,
“typeVersion”: 4,
“position”: [
-240,
80
]
},
{
“parameters”: {
“conditions”: {
“string”: [
{
“value1”: “={{ $json.message.contact.phone_number }}”,
“operation”: “isNotEmpty”
}
]
}
},
“id”: “6d865c7b-f28f-4934-9ae7-7401d48b2e2d”,
“name”: “IF”,
“type”: “n8n-nodes-base.if”,
“typeVersion”: 1,
“position”: [
-840,
60
]
},
{
“parameters”: {
“jsCode”: “// Loop over input items and add a new field\n// called ‘myNewField’ to the JSON of each one\nfor (const msg of $input.all()) {\n if (!msg.json.message.contact) {\n msg.json.message.contact = {};\n }\n \n if (!msg.json.message.contact.phone_number) {\n msg.json.message.contact.phone_number = ‘’;\n }\n if (!msg.json.message.from.last_name) {\n msg.json.message.from.last_name = ‘’;\n }\n if (!msg.json.message.from.first_name) {\n msg.json.message.from.first_name = ‘’;\n }\n if (!msg.json.message.from.username) {\n msg.json.message.from.username = ‘’;\n }\n if (!msg.json.message.from.language_code) {\n msg.json.message.from.language_code = ‘’;\n }\n if (!msg.json.message.from.is_bot) {\n msg.json.message.from.is_bot = ‘’;\n }\n\n \n //msg.json.myNewField = 1;\n}\n\nreturn $input.all();”
},
“id”: “b5b61374-0878-4a53-84ba-1833412d2449”,
“name”: “Set1”,
“type”: “n8n-nodes-base.code”,
“typeVersion”: 1,
“position”: [
-1120,
60
]
},
{
“parameters”: {
“operation”: “appendOrUpdate”,
“documentId”: {
“__rl”: true,
“value”: “====GOOGLE_SHEET_ID====”,
“mode”: “list”,
“cachedResultName”: “n8n.test”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/====GOOGLE_SHEET_ID====/edit?usp=drivesdk”
},
“sheetName”: {
“__rl”: true,
“value”: “gid=0”,
“mode”: “list”,
“cachedResultName”: “Sheet1”,
“cachedResultUrl”: “https://docs.google.com/spreadsheets/d/====GOOGLE_SHEET_ID====/edit#gid=0”
},
“columnToMatchOn”: “message.from.id”,
“valueToMatchOn”: “={{ $json.message.from.id }}”,
“fieldsUi”: {
“values”: [
{
“column”: “message.from.is_bot”,
“fieldValue”: “={{ $json.message.from.is_bot }}”
},
{
“column”: “message.from.first_name”,
“fieldValue”: “={{ $json.message.from.first_name }}”
},
{
“column”: “message.from.last_name”,
“fieldValue”: “={{ $json.message.from.last_name }}”
},
{
“column”: “message.from.username”,
“fieldValue”: “={{ $json.message.from.username }}”
},
{
“column”: “message.from.language_code”,
“fieldValue”: “={{ $json.message.from.language_code }}”
},
{
“column”: “message.from.phone_number”,
“fieldValue”: “={{ $json.message.contact.phone_number }}”
}
]
},
“options”: {}
},
“id”: “d3f47c96-4120-41ba-a815-fa343eb31424”,
“name”: “Google Sheets”,
“type”: “n8n-nodes-base.googleSheets”,
“typeVersion”: 3,
“position”: [
-80,
-440
],
“credentials”: {
“googleSheetsOAuth2Api”: {
“id”: “1”,
“name”: “Google Sheets account”
}
}
}
],
“pinData”: {
“Set1”: [
{
“json”: {
“update_id”: 821844788,
“message”: {
“message_id”: 39,
“from”: {
“id”: 409326512,
“is_bot”: false,
“first_name”: “Q”,
“username”: “qdrddr”,
“language_code”: “en”,
“last_name”: “”
},
“chat”: {
“id”: 409326512,
“first_name”: “Q”,
“username”: “qdrddr”,
“type”: “private”
},
“date”: 1685643461,
“text”: “/start”,
“entities”: [
{
“offset”: 0,
“length”: 6,
“type”: “bot_command”
}
],
“contact”: {
“phone_number”: “”
}
}
}
}
]
},
“connections”: {
“Telegram Trigger”: {
“main”: [
[
{
“node”: “Set1”,
“type”: “main”,
“index”: 0
}
]
]
},
“Code”: {
“main”: [
[
{
“node”: “HTTP Request”,
“type”: “main”,
“index”: 0
}
]
]
},
“HTTP Request”: {
“main”: [

]
},
“IF”: {
“main”: [
[
{
“node”: “Google Sheets”,
“type”: “main”,
“index”: 0
},
{
“node”: “Telegram”,
“type”: “main”,
“index”: 0
}
],
[
{
“node”: “Code”,
“type”: “main”,
“index”: 0
}
]
]
},
“Set1”: {
“main”: [
[
{
“node”: “IF”,
“type”: “main”,
“index”: 0
}
]
]
},
“Telegram”: {
“main”: [

]
}
},
“active”: true,
“settings”: {},
“versionId”: “4cc293b2-8e93-44de-ba77-3f9eeffde7bd”,
“id”: “3”,
“meta”: {
“instanceId”: “d3a890783b6fa26d6ac471e5dfa63c3da2db4cbe73a2914a3e2c4475dfe45e32”
},
“tags”:
}

3. Add Sheet ID: In the n8n workflow editor, open the Google Sheet Node & Update it with your own Sheet ID. Replace the “====GOOGLE_SHEET_ID====”

4. Add Telegram Bot ID: In the n8n workflow editor, open the Telegram Share Button Code node & Update it with your own Telegram Bot Token, instead of “====TELEGRAM_BOT_TOKEN====”