I’ve built a workflow to automatically render many short form content videos. I built it for one google sheet and it all worked fine. But now i’m trying to scale up given there are 4 team members creating videos.
We have 4 templates created on ‘Creatomate’ and hence I want each creator to have their own google sheet document with 4 sheets inside (1 per template), and then 4 folders per creator also. I’ve added 4 google sheets triggers (1 per creator) in one workflow per video template, and it won’t run automatically. Is this due there being too many triggers in 1 workflow? API problems or something?
Hey @walshito !
What about “credentials” ?
I think you must configure separate credentials for each node, even if they use the same GCP client ID/secret…
Hey @Parintele_Damaskin , thanks for your reply.
For credentials i just have my Google Sheets Trigger account connected. I created all the sheets and shared them with them. What do you mean, each creator having their own google sheet credential?
I’m getting mixed responses online as to whether there is a limit on the number of time based triggers in one workflow, do you know anything about this?
Thank you🫡
I think in development (manual execution), only one of trigger can be activated. but in production(when workflow is activated) all of them will work
i just want to be sure. do you expect all of your triggers, execute in a single execusion?
Hi, no i don’t mind if it runs in 4 executions.
In any workflow execution only one trigger node get trigger
so the merge node is not necessary and you do not need those four branches after each trigger. add four trigger and connect all of them to a single if node.
when you activate your workflow, four of them will notified of changes but each execution only one of them will be run
so i don’t know your issue was misunderstanding of n8n mechanism or actually another issue
A mixture of both, only started using n8n very recently. But thanks for that tip, still learning how this works.
I think creating a credential per trigger solved the issue.
1 Like
Hey, so i just checked and some of the triggers do work and some don’t. Just to check, you can have multiple google sheet triggers in one workflow no? Could the problem come from something related to what you said?
Also i’m trying to implement what you said, and i cant figure it out. I have the edit node so i can define each sheet id and each output folder id (given i also want each creator to have their own folders) so i can use throughout the workflow. Is there a way of having only one branch rather than 4 then? Maybe i need 4 triggers and 4 set nodes, and then all into 1?
I actually tested it before reply. i put two sheet trigger and activate my workflow and both of them fired (each of them in a separate execution)
i used same credential for both triggers too
your four nodes after trigger are same and you can definitely avoid duplicating them.
please share your workflow (at least the first part until merge node) so we can help you better
i struggled so much to upload this 
. thing is sometime it works sometimes it doesnt. it always works when executing manually. i have no idea whats going on
You are watching Ejecutar column. Are you updating that column when your trigger do not get fired?
Ejecutar is filled in when we want to run the workflow. And it stays like that.
Thanks for your help! So what would you say is the problem, that it doesnt detect a new row as row updated? Meaning i should change the trigger to ‘On row added or updated’?
that depends on your use case. your trigger fires when Ejecutar column is updated currently. if you want your trigger fire on other cases change it to catch other events
1 Like