Writes every message your Telegram bot receives to a Google Sheet as a row - the time, who sent it and exactly what they typed.
Uses
Google Sheets
Telegram
Log Telegram messages to a spreadsheet
incomingMessage.When a new message is received. Save it as incomingMessage.spreadsheetUrl to blank.Set spreadsheetUrl to blank.sheetName to blank.Set sheetName to blank.messageText to blank.Set messageText to blank.noTextErrorIf a step below fails, save the error as noTextErrorTry
incomingMessage.text and save it as messageText.Trim incomingMessage.text and save it as messageText.On error
No steps
messageText is emptyIf messageText is emptyYes
No
No steps
senderName to blank.Set senderName to blank.noSenderErrorIf a step below fails, save the error as noSenderErrorTry
incomingMessage.from_username and save it as senderName.Trim incomingMessage.from_username and save it as senderName.On error
No steps
senderName is emptyIf senderName is emptyYes
senderName to unknown.Change senderName to unknown.No
No steps
senderId to incomingMessage.from_user_id.Set senderId to incomingMessage.from_user_id.senderId is nullIf senderId is nullYes
senderId to blank.Change senderId to blank.No
No steps
recordedAt.Get the current date and time and save it as recordedAt.sheetName in spreadsheetUrl.Add a row to sheetName in spreadsheetUrl.