Workflow works manually but silently fails on one step when active

Details as follows:

  • n8n version: 1.81.3 (tried .4 but had an internal error on Google Sheets node)
  • Database (default: SQLite): default
  • n8n EXECUTIONS_PROCESS setting (default: own, main): default, EXECUTIONS_TIMEOUT 800
  • Running n8n via (Docker, npm, n8n cloud, desktop app): n8n cloud
  • Operating system: NA

Status says: Succeeded in 0.113s (which is clearly too short to do anything useful.) Manual execution takes around 5 mins.

This is the screenshot of the automated execution

This is the screenshot of the manual execution

As far as I can tell, it looks like the Google Sheets Trigger at the front is bringing in only empty rows and not the newly added ones.

Is this expected behaviour and are there any recommendations on How I can force the Google Sheet trigger to behave the same way as it does in Test executions?

Looks like I have partially solved the problem myself with a bit of tinkering.

Key change is around how I get updates from the Google Sheet.
Now using a schedule trigger and read node. Not quite as efficient but does the trick.

Would you mind sharing the settings of the filter node and how you got it to only allow new rows through? I’m having the same issues with the Sheets trigger working fine manually but failing constantly when running automatically.