in google sheet trigger column not sending messages to telegram

[Dinesh gupta]

hi , in my google sheet my column which is supposed to send a message to telegram as soon a entry reflects there triggers , but in my case , trigger column is not sending content to telegram , this sheet is updated by googlefinance for stock prices. pl help how to rectify this issue

 

[Dinesh gupta]

is this because the contents in column from which trigger column generates data use a simple google formula =k2 , copy from one field. in background it still uses data formula , is it the reason that when in ui I am seeing a new trigger generated nut no telegram message sent , reason is that actually in back ground there is a formula always so no trigger happened actually , is it such... then if such please help me how to copy data from one cel to another without using formulas... I think this will be a solution...please help

 

[Pabblymember11]

Hey @Dinesh gupta

Could you please tell us if your data is coming from another application or if you are manually feeding it? So if you getting data from a third-party application, in that case, you need to check both the options of "Send On Event" and "Auto Send on Schedule" and by enabling both the options then the data can be forwarded in 1hr. That is something associated with Google API and we cannot change or manipulate it.

And if you are adding the row manually then kindly select "Send on Event" only. Then try adding a new row to test the workflow.

Moreover, you can re-capture the webhook response again and remap the action event if you made any changes in your Google Sheets.