error code: 429 ?

[patrice.lapointe01]

Good day,
this morning I received the followng message. This happened after 300 allerts got triggered in trading view. Out of the 300 alerts, only 60 got transfered. Can anyone explain what happened? Before to register to Pabbly, a customer representative told me there would be no problem with thaat many allerts sent at the same time. thank you.

{
"error > code": 429,
"error > message": "Quota exceeded for quota metric \u0027Write requests\u0027 and limit \u0027Write requests per minute per user\u0027 of service \u0027sheets.googleapis.com\u0027 for consumer \u0027project_number:1011300378975\u0027.",
"error > status": "RESOURCE_EXHAUSTED",
"error > details > 0 > @type": "type.googleapis.com/google.rpc.ErrorInfo",
"error > details > 0 > reason": "RATE_LIMIT_EXCEEDED",
"error > details > 0 > domain": "googleapis.com
",
"error > details > 0 > metadata > quota_location": "global",
"error > details > 0 > metadata > service": "sheets.googleapis.com",
"error > details > 0 > metadata > quota_limit": "WriteRequestsPerMinutePerUser",
"error > details > 0 > metadata > consumer": "projects/1011300378975",
"error > details > 0 > metadata > quota_metric": "sheets.googleapis.com/write_requests",
"error > details > 0 > metadata > quota_limit_value": "60",
"error > details > 1 > @type": "type.googleapis.com/google.rpc.Help",
"error > details > 1 > links > 0 > description": "Request a higher quota limit.",
"error > details > 1 > links > 0 > url": "https://cloud.google.com/docs/quota#requesting_higher_quota"
}

 

[Supreme]

Hey @patrice.lapointe01

As we can see from your shown error, you have exhausted your rate limit to pass the request to write data per minute by "Google Sheets".

Google API documentation for the error which you have got.

Moreover, you are also running the tasks in bulk and because of that, the error has occurred by the Google API. So, we should suggest to us a delay action step to delay the task to run 1 min after every update of value, in that way you wouldn't be exhausting your rate limit.

 

[patrice.lapointe01]

Thank you for your reply.
i’m using the same workflow and webhook on all of those 300 tradingview alerts. If I use a 1 min delay, will they all happen 1 min later at same time and still create the same problem. If so, shoulg I setup multiple identical workflow and webhook with digfferent delays (50 at 1min delay, 50 at 5min delay, etc)?

 

[Supreme]

Hey @patrice.lapointe01

i’m using the same workflow and webhook on all of those 300 tradingview alerts. If I use a 1 min delay, will they all happen 1 min later at same time and still create the same problem. If so, shoulg I setup multiple identical workflow and webhook with digfferent delays (50 at 1min delay, 50 at 5min delay, etc)?

Instead, you can try creating a router in your same workflow with a different delay on it.

 

[patrice.lapointe01]

Do you have instructions about how to do it?

 

[Supreme]

Do you have instructions about how to do it?

You can refer to the following video tutorial here -

 

[patrice.lapointe01]

Thank you