Google Sheets Trigger issue in 1.91.3

[StreamlinedStartup]

Have a Row Updated causing issues (I think). The error is: `There was a problem activating the workflow: “Cannot read properties of undefined (reading ‘!ref’)” anytime I try to activate the workflow. When I manually test it, it works fine.

I decided to use the Data Location on Sheet option, like over here.

I used this same exact workflow many times in previous versions of N8n (1.91.0 also didn’t work).

I duplicated the sheet (left the name unchanged as mentioned in the previous link suggestions as it appears a sheet name-change can cause issue) and was able to immediately save the Workflow. However, it would not trigger when I updated a row in the specified column. I tried deleting the Data Location on Sheet and my flow was disabled and anytime I try to reactivate it, I get the same initial error.

Any idea what is going on? As I said, I’ve ran this same workflow thousands of times previously.

Information on your n8n setup

• n8n version: 1.91.3
• Database (default: SQLite): Default SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): Default (not set in ENV)
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker Compose
• Operating system: Linux Mint 21.2

[Abrar_Sami]

What is the exact trigger mode selected (Row Updated, New Row, etc.)?

Can you try removing the “Data Location on Sheet” option or set it correctly? Sometimes specifying partial or incorrect ranges causes this error cause the range (!ref) tells n8n which rows and columns to watch for updates.

Try clearing this setting so it fetches the whole sheet or manually set the exact range (e.g., A1:Z1000) instead of “Specify Range (Rows)” if you’re using that.

If that doesn’t work, confirm Google Sheet has a proper header row and data range (like no hidden rows, columns, or weird formatting)

You also mentioned duplicating the sheet with the same name worked once but didn’t trigger on updates. Try duplicating the sheet but give it a fresh new name. This refreshes the reference and sometimes fixes hidden sync issues.

Hope this helps!

[StreamlinedStartup]

Trigger is rowUpdate.

The behavior is the same (initially built without Data Location on Sheet). The row ranges (A1:Z1000) also produced the same result. I’ve since deleted the Data Location on Sheet option entirely.

Header row and data range doesn’t have any hidden rows, columns or weird formatting. Although, I believe this may be the first time I’ve used $ in cell values.

Just duplicated it again and was immediately able to save (previous attempt also allowed me.). Looks like it IS actually firing now.

Very odd, given that I tried that previously.

Thanks for the help, @Abrar_Sami.