Fallback route always crashes the scenario (too many requests)

How To
1

Hi folks!

Cracking my head over this one!

Key components in this scenario: Webhook, Google Sheets, Telegram.

This scenario gets data from a webhook (name, email, page_url, etc…)

  • Compares the page_url with columns in the Google Sheet.
  • If page_url exists in Google Sheet, send all the data from the Webhook to Telegram Groups based on various filters & Routers.
  • If page_url does not exist in the Google Sheet, send the Webhook data through the Router’s fallback route to a Telegram Group/s.

Webhook, Google Sheets, Telegram - Fallback Issue A
Webhook, Google Sheets, Telegram - Fallback Issue A990×727 68.9 KB

Everything in the scenario is working as intended except for the Fallback. Whenever the fallback route is enabled, It is always triggered by the Router regardless of the filters. The data is sent to the Fallback Telegram group over 35 times before the scenario times out due to too many requests and is disabled.

This is happening in every scenario I’ve set up with Google Sheets and a fallback route.

All my filter conditions are setup like: Sheets column (A) : contains (case insensitive) : page_url

The fallback is setup like: Whole Sheet : does not contain (case insensitive) : page_url

Can anyone tell me what I’m doing wrong here?

2

Can you share the screenshot of your execution history, plus what is being set in the fallback route? I believe there is nothing set on the fallback, but still I want to check that.

The most probable issue is with the GSheet Module, that you are using to Search for Rows. What is the filter that you are using in that particular module? Seems like there is nothing set, i.e you are not comparing the row column’s against the page_url that you are getting from the Webhooks, and it is returning all the data from the Google Sheets, thus the issue with 35 different calls in fallback route.

1 Like
3

Hi @Runcorn , Thank you so much for looking into my issue.

Screenshots of the execution history:

Webhook, Google Sheets, Telegram - Fallback Issue LOGS
Webhook, Google Sheets, Telegram - Fallback Issue LOGS468×702 84 KB

Here’s what the fallback route’s filter looks like:

Webhook, Google Sheets, Telegram - Fallback Issue B
Webhook, Google Sheets, Telegram - Fallback Issue B1023×788 90.9 KB

And this is what a typical route filter looks like:

Webhook, Google Sheets, Telegram - Fallback Issue C
Webhook, Google Sheets, Telegram - Fallback Issue C976×691 75.8 KB

Detailed log excerpt FYR:

JULY 10, 2023 3:46 PM

Run ID:
3649cf5c01404359b579326972ff4548
Duration:
24 seconds
Operations:
24
Data size:
98.0 KB

Simple logAdvanced log

  • Webhooks - Custom webhook1+0.2s

The operation was completed.

  • Tools - Increment function5

The operation was completed.

  • Google Sheets - Search Rows12+0.3s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+7.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+7.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+7.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.2s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32+0.1s

The operation was completed.

  • SAM Team - Send a Text Message or a Reply10

The bundle did not pass through the filter.

  • KUMAR - Send a Text Message or a Reply20

The bundle did not pass through the filter.

  • Flow Control - Router25

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply13

The bundle did not pass through the filter.

  • SANDIP Team - Send a Text Message or a Reply14

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply18

The bundle did not pass through the filter.

  • SAM Leads - Send a Text Message or a Reply21

The bundle did not pass through the filter.

  • Balu & Devu RR - Router22

The bundle did not pass through the filter.

  • Others Round Robin - Router27

The bundle did not pass through the filter.

  • Telegram Bot - Send a Text Message or a Reply32

The operation failed with an error.

Error

[429] Too Many Requests: retry after 36