Telegram userbot for google sheets

Create a API account here: https://my.telegram.org/apps.

Install event_handler.gs in "Extensions > Apps Scripts"

Then modify variables:

let domain = "";
let api_key = "";
let spreadsheetId = "";
let sheetName = "Sheet";
let logSheetName = "LogSheet";
let headersRange = "A1:S1";
let onEditRange = [13, 19];
let columnTelegramUsername = ``;
let columnUserProblem = ``;
let notificationMessageColumnRange = [11, 15];

pip install pyrogram

python src/session_maker/maker.py

bash cli.sh startup

cat api_key.txt Copy the string and paste it into let api_key = "value"; in the event_handler.gs.

Application launched on http://127.0.0.1:80.

Example

spreadsheet

Example