GoogleSheets "Append or Update" Error on N8N Cloudron

[kevin.k]

Hey,

I’m facing an error when using GoogleSheets “Append Or Update” Trigger. I get this error when saving the workflow

" Workflow could not be activated:
There was a problem activating the workflow: “Cannot read properties of undefined (reading ‘!ref’)”

I’m using N8N Version 0.233.0 installed via Cloudron.

Ps : All other Triggers are working well except that one

[girish]

@kevin-k you have to report this upstream in n8n - https://github.com/n8n-io/n8n/issues

[kevin.k]

Okay, thanks.

[girish]

@kevin-k if you report upstream, please do post the issue number here . If it's a packaging issue , we will fix it. But it seems like some n8n node bug.

[kevin.k]

Just posted it on their Community Support Forum. I'll await their response then post their feedback here as well.

[kevin.k]

Solution (more of a workaround) : https://community.n8n.io/t/google-sheets-bug-cant-activate-workflow/27211/6

I believe it's a minor bug on the GoogleSheets Trigger Node