Hi! I am trying to build a workflow that takes in messages from telegram and adds an entry in a google sheet per received message.
I am expecting to get between 1000 and 3000 messages per day, so would it be that number of executions per day? If that is the case, I will be exceeding the monthly quota during the first day. Am I getting it right? what happens when that limit is reached?
Hello @Lisandro_Scofano1,
i believe that reaching the n8n quota does not block executions until the following month.
You should find ways to decrease workflow executions to optimize the process.
Or find other ways to store this data with AppScript for example.
Have you considered this option yet?
Yes, I could use AppScript, but in that case. I could do it all in AppScript without a need for n8n.
I am exploring how to get batches of messages from Telegram every some hours instead of instantly pulling any new received message.
i was thinking about it too if there is a batch mode but unfortunately I can’t think of anything.
The n8n road processes every single message, app script avoids excessive consumption of executions, you could build an ad hoc webhook for this but it is certainly more complex and anyway you should write somewhere (Google Sheet).
It depends what you need n8n for in this case. Can an n8n stream start after message storage?
Yeah, I tried the self hosted option and I was having too many restarts of the instance, connections lost to the PostgreSQL DB, etc. I was probably not using the right set of env variables. Do you have a good example of how to configure GCP Cloud Run + Cloud SQL to work stable without downtimes?
I do not recommend selfhosted if you do not already have a bit of experience with it.
But there is loads of examples out there. Also in the official docs.
What you could also do is send the webhooks to hookdeck for example. From here you could sent it to some kind of service to list all messages. And from there poll it in n8n at certain times.
What service to use for the message store I am not sure as I never had to. Maybe hookdeck also has a feature or API for it.