I used to have this problem with French letters in the names of column headings.
For the sheets I use, I cheated and either renamed the column names to “english” names
OR for sheets accessed by my French colleagues, I used specific columns (Col A, Col B etc.) rather than using column name heading.
I just made sure the columns never changed in the google sheets.
I was too lazy to investigate the correct solution for this…!
Hi @whitbym, I am so sorry for the trouble but couldn’t reproduce the behaviour on my own n8n instance (perhaps because I was using the wrong characters or something, I do not speak Russian unfortunately).
Could you perhaps share a dummy Google Sheet using which the error can be reproduced when running your workflow? Also, would I need to run your workflow in production mode in order to see this error or is a manual execution enough?
Thank you so much @Eventurum, I was now able to reproduce the problem when using the Trigger On → Row Added option. I’ll add this to our bug tracker for a closer look and fix. It’d be great if you could keep your example sheet online for a little bit longer so the engineering team can use it to reproduce the problem as well.
That said, polling did work for me when using Trigger On → Row Added or Updated instead: