Telegram para ingresar y leer datos que tiene en Spreadsheet Excel, Integrar Bot

Telegram para ingresar y leer datos que tiene en Spreadsheet Excel, Integrar Bot

María Eugenia Szwedowski

3 года назад

4,312 Просмотров

¿Cómo publico en Google Sheets desde Telegram?.
Si te has realizado esta pregunta, estas en el lugar indicado. Imagina que otra persona o un bot va enviándote cosas al Google Sheet, tu puedes aplicar todas las funciones e integraciones que normalmente le harías a la Planilla Electrónica pero en esta oportunidad la utilizaras o utilizarán como servidor, como una base de datos, para agregar y extraer información, datos, evaluaciones, funciones, etcétera. Utilizaremos los recursos gratuitos ofrecidos por Telegram y por Google Drive, Google Sheets específicamente. Sé parte de nuestra comunidad de aprendizaje.

🌺 Descargar código : https://docs.google.com/document/d/1PiS1w-fp14xLcy4HU6Hs0DPdm7cpCZnkuT9b3TrHF_c/edit?usp=sharing

🌺 Canal : https://www.youtube.com/watch?v=pV1Jt3fjcq8

⌚Marcas de tiempo:
00:00​ - intro
00:45 - Crear bot en Telegram con BotFather
01:20 - Agradecimiento al Canal Mars Escobin por sus tips de desarrollo
02:18 - Spreadsheet Excel Crear Acceso en Secuencia de COmnados para Codificar
04:33 - Verificar accesos con "//Logger.log(response.getContentText())"
05:10 - Verificación de ingreso de datos desde Telegram a Spreadsheet Excel
07:00 - Tomar datos desde Spreadsheet Excel por Telegram

🌺 Suscríbete al canal aquí:
https://www.youtube.com/channel/UCDgz0olIOtE2G60YXtI_OCA?sub_confirmation=1

--------------------------
CONTACTO / NEGOCIOS
[email protected]
📲 +598 91074131

CONÓZCAME:
👩 https://maria-eugenia-szwedowski.github.io
💻 https://me-webs.github.io

ACERCA DEL CANAL:
Comparto tips de diseño con contenido relacionado a mis áreas de estudio, edición de plataformas CMS y ¡mucho mas!

Тэги:

#diseño_web #diseño_gráfico #excel #excel_avanzado #excel_inmobiliario #telegram_a_excel #leer_datos_con_telegram_de_excel #ingresar_datos_a_excel_desde_telegram #excel_y_telegram #automatizar_datos_con_telegram_y_excel #cómo_ingresar_datos_a_excel_desde_telegram #funciones_spreadsheet_a_telegram #excel_spreadsheet_telegram #spreadsheet_telegram #spreadsheet_bot_telegram #telegram_ingresa_datos_a_spreadsheet #gestionar_datos_desde_telegram #tendencias_diseño_web #me_diseño_web
Ссылки и html тэги не поддерживаются


Комментарии:

The student's perspective
The student's perspective - 24.08.2022 08:40

can you please link it to your source code

Ответить
Трансляции служб — Свято-Eлисаветинский монастырь
Трансляции служб — Свято-Eлисаветинский монастырь - 28.07.2022 19:48

Thanks!

Ответить
Rimaldz
Rimaldz - 26.07.2022 15:28

hi mars
i have problem
ReferenceError: webAppUrl is not defined (ligne 6, fichier "Code")
how i can fix §§

Ответить
Srinithi Nachiyar
Srinithi Nachiyar - 29.06.2022 16:27

Hi. Does this only work for Google Suite or it works for even normal account? I did everything but i get no reply from the telegram bot. I tried everything. I even rerunned the webhook but it still did not work. please help

Ответить
Sally Chan
Sally Chan - 13.05.2022 21:28

Doesn't work for me. I didn't recieved a message back in telegram.
I try debugging by running the sendMessage function alone. I get an error message of "TypeError: Cannot read property 'postData' of undefined"

Ответить
Mario Barretta
Mario Barretta - 08.05.2022 10:46

Thnak You
How to publish on telegram the info received on a google sheet?

Ответить
Tyr
Tyr - 24.04.2022 21:01

TypeError: Cannot read property 'postData' of undefined it doesn't identify post data i think your coding is wrong not working

Ответить
Ma'rufjon Mamatkulov
Ma'rufjon Mamatkulov - 03.04.2022 12:37

in final, my cod is not working

Ответить
Syazwana Ariffin
Syazwana Ariffin - 09.03.2022 10:05

Thank you so much

Ответить
Nam Nguyễn
Nam Nguyễn - 20.02.2022 07:25

thanks for video. I was code like you, but when I run, google Appscript says: "TypeError: Cannot read property 'postData' of undefined (line 17, file "Code")"

Ответить
Exammap
Exammap - 11.02.2022 21:57

How can I send my spreadsheet message to my telegram channel or bot. Please make a video on it.

Ответить
Praveen Bhargava
Praveen Bhargava - 22.01.2022 12:55

I jus followed your instructions and created scrip. It looks like i configured the script exactly the same but I am unable to get the response.

Ответить
Super etc.
Super etc. - 05.12.2021 12:25

i dont get the last part... it says i need do get where you only use do post.. and i dont know what you did at the last part because it was cut on the screen

Ответить
kris riley
kris riley - 25.08.2021 21:25

This is a great tutorial.
How do you add the bot to a Telegram group?

Ответить
hb sr
hb sr - 25.06.2021 08:53

@Mars Escobin - Great Videos. Do you have an email address that you would like to provide for additional questions?

Ответить
Vijay Karthik
Vijay Karthik - 31.05.2021 19:32

Pls make video about how to create bot for share market price

Ответить
Popzmickuu Mickuu
Popzmickuu Mickuu - 20.05.2021 07:24

How can i get code of this

Ответить
Heitor Vida
Heitor Vida - 03.05.2021 15:36

This is brilliant and right what I needed. Thanks Mars!

Ответить
Elias Tan
Elias Tan - 10.04.2021 12:36

Hi, I am unable to have the bot send me back a message even after setting back the web hook.

Ответить
Nath Gomez
Nath Gomez - 05.04.2021 08:29

i followed the instruction but the bot no response. :3

Ответить
No need to know a name
No need to know a name - 21.02.2021 15:21

Thank you Mars, this is exactly the bot I wanted to build. So happy I found your course!

Ответить
Tom Cunningham
Tom Cunningham - 21.01.2021 05:19

Can you release the source code for the bot you've made?

Ответить
Tom Cunningham
Tom Cunningham - 21.01.2021 05:18

Do you freelance. If love a bot making. Message me. Wickr - doubtintom

Ответить
Shakila Banu
Shakila Banu - 13.01.2021 15:23

You should explain right from telegram installation, creation of an account, sending receiving the messages... forming the group , what is bot.... usage of this one and what is broadcasting , then the channel what purpose, it function and how to use the channel ... further usage of it for business communication also

Ответить
mario dragoti
mario dragoti - 05.01.2021 23:45

how i can create a bot to post autopost on group

Ответить
iamyen2
iamyen2 - 25.12.2020 06:59

Thanks for your sharing! It's clear and it works~

Ответить
alchemist 98
alchemist 98 - 21.12.2020 17:05

How do u fix an error 400?

Ответить
ayDTWO
ayDTWO - 14.12.2020 21:23

Looking for a telegram programmer to help build a bot that'll edit telegram message then forward to another group for proprietary reason. I am willing to pay for the service. Regards.

Ответить
Wim's Coding Secrets
Wim's Coding Secrets - 02.12.2020 13:50

Hi Mars, very nice tutorial. Could you mention my video as a source? (assuming you had me as the inspiration)

Ответить
Eugene Christopher
Eugene Christopher - 05.11.2020 12:30

Hi - Is it possible for telegram to retrieve data from google sheets?

Ответить
Alberto
Alberto - 02.10.2020 02:46

Hii , I'm an industrial engineer and I'm interesting in develop one bot to track data from an excel worksheet. Do you have any idea where should I start? I don't have knowledge about programming.

Ответить
Allan Cfc
Allan Cfc - 22.08.2020 09:48

thank you for your tutorial!

Ответить
syahirah shukri
syahirah shukri - 17.08.2020 06:34

Hi, your content is good ! i want to ask, how to delete item on bot using fx deleteMessage?

Ответить
Rafael Bertasso
Rafael Bertasso - 06.08.2020 01:01

Excellent video! But I cant find the code in Medium post

Ответить
Igor Hizhnyak
Igor Hizhnyak - 12.07.2020 22:19

Thank you. Very interesting. But my doPost function never executed. Have you some ideas why it could be?. Webhook was set, I check it using /getWebhookInfo

Ответить
AL MADANI MART
AL MADANI MART - 29.06.2020 20:17

hi, can this method applied in a group ?

Ответить
Lord Heman
Lord Heman - 23.06.2020 03:43

Life is too short and you are so smart....LOL

Ответить
Johan de Bruyn
Johan de Bruyn - 18.06.2020 17:13

Hi when I run the function doPost the script Editor generates this error message TypeError: Cannot read property 'postData' of undefined (line 23, file "Code")  how fix please

Ответить
Bryan Ling
Bryan Ling - 02.06.2020 06:22

i tried rerunning the webhook but didn’t get any reply from the bot

Ответить
sheenng
sheenng - 27.05.2020 11:55

Can this be done for fb messenger or whatsapp?

Ответить
Zhong Ying Hew
Zhong Ying Hew - 26.05.2020 13:38

Unable to get bot to response , tried all the method mentioned below

Ответить
nyujinseu
nyujinseu - 15.05.2020 10:04

Hi!! So i tried the deleteWebhook, and running it again. But my bot still does not respond to me. I have an error which says TypeError: Cannot read property ‘postData’ of undefined (line 16)

Ответить
Fariha Azmi
Fariha Azmi - 10.05.2020 07:39

hey Mars Escobin . I already run it as set webhook and still my bot dont text me back. may i know why ?

Ответить
Sarah Hasran
Sarah Hasran - 08.05.2020 03:21

My bot doesn't response to me :')

Ответить