I have 4x Google Sheet Triggers setup. They are set as the below image (to check every 5 mins). Unfortunately, these all do not appear to be checking every 5 minutes. When I check the execution logs, I can see that only one of them checks, rather than all 4. Am I doing something wrong or reaching some sort of limit?
Data is being added to the sheet, and when the trigger is run manually it works fine, it just does not appear to be fetching data on schedule.
Hmm, I’d love to dig into this one a little bit more - could you share your workflow? You can select all from the workflow editor with cmd/ctrl + a, and then copy with cmd/ctrl + c - and paste here between two sets of three backticks (```) to add your workflow to your post. It’d also be really helpful if you have an example sheet - please make sure there’s no sensitive data - that you could share with us where this is happening. I’d be happy to take a deeper look with that information
Hi @dg92 So far, I haven’t been able to break this I created four sheet copies, and have five trigger nodes, each looking for row added on one sheet. I’ve set the polling timer to 60 seconds just for testing purposes, and it’s always firing for me with multiple emails (one for each trigger I’ve, well, triggered) if I add in some dummy text into the row below in the specified columns.
Can you describe how you’re entering in data into this spreadsheet? Are there blank cells or anything like that, for instance?
Since you mentioned latest, I’m testing on 1.5.1 - what version of n8n are you on?
So - I noticed that one of the workflows works and the other three are intermittent, so I deleted those and cloned the one that works. It appears to be working ok now!
Part of the app script deletes all rows in the spreadsheet at 6am, apart from row 1. What I believe is happening is n8n remembers the last new row, and then when a new one is added after the deletion, it doesn’t pick it up as say it’s likely expecting a new row to be added after row 30 for example, however it’s getting added after row 1 instead.
I created four sheet copies, and have five trigger nodes, each looking for row added on one sheet. I’ve set the polling timer to 60 seconds just for testing purposes, and it’s always firing for me with multiple emails (one for each trigger I’ve, well, triggered) if I add in some dummy text into the row below in the specified columns.