Google sheet Telegram - Scenario suddenly stopped working

Hi All.

I run an educational channel and post questions daily from google sheet on my telegram.
It was working fine for last 3 months.

But today it shows error , even though i have not made a single change

Image of my scenario

image

Notification I got =>

Your scenario Integration Google Sheets, Telegram Bot has encountered an error.

The scenario has not been paused and continues to run according to your settings. Nevertheless, you should pay attention to the issue.

Details:

  • Validation failed for 1 parameter(s).
  • Missing value of required parameter 'text'.

If you have questions or need help, please contact us.

Please help…!!

Hi @Shashwat_Chopra,

In the email you get, you can click on the string after Execution: to go to the history log and find the module at which the error occurred, from there you can inspect further.

My guess is the Search Rows module found a row with Status (B) equal to “Ready” but the value in Question (A) was blank → The Telegram Bot returned an error since it had no message to send :face_with_monocle:

If so, in the Filter section of the Search Rows module, you can Add AND rule with Question (A) not equal to {{null}} to avoid finding empty question rows.

Hope this help!

Here is the image of google sheet that is used as question bank. As you can see its not empty.

I also added the rule that you said. It is still not working.

Also thank you for your reply