Google sheets node 'Data mode' parameters not showing in v 1.18.1

Questions
1

Describe the problem/error/question

I have been using an older version of n8n previously and using the google sheet node with no issues. I’m now using an n8n instance of v1.18.1 and the google sheet nodes with operation ‘Append and update’. The credentials are correct as I’m able to select Document & Sheet ‘from list’.

My problem is that it doesn’t allow me to set the mapping rules which used to be under a parameter ‘Data mode’

What is the error message (if any)?

When I try to execute the node I get an error : ERROR: Could not get parameter “columns.matchingColumns”!

Please share your workflow

Share the output returned by the last node

Information on your n8n setup

  • n8n version: 1.18.1
  • Database (default: SQLite): NA
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system:
2

Hi @Ghazz

Thanks for posting here and welcome to the community! :partying_face:

I am just wondering if this could be the same bug, that we fixed in 1.21.1 :face_with_monocle:

In general though, we recommend to keep your instance up to date as much as possible.
You can find our release notes here: Releases · n8n-io/n8n · GitHub

3

Hi @ria,

Yeah, seems so. I’ll upgrade to the latest version & hopefully should be ok.

Thanks

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.