We are using N8N and BigQuery to build an in-house database capable of having all of our TAM enriched at real time.
The problem is that we have a lot of workflows linked to the same table and when we make multiple requests at the same time to it it will crash the query and stop the execution.
We needed a way of either re-run these executions until they get approved, or some kind of rate limit that would say to n8n something like: We are already running a query to this table, wait until it gets done.
We already tried the “retry on fail” option, but we can only do that for 5 times with 5 seconds interval and that is not enough.
Do you have some solution for this?
We can’t use the batches option because these are multiple workflows running, and not only once.