Google Sheet Row Update Issue

Questions
1

Describe the problem/error/question

I’v been trying to follow Text Course Level 2 workflow from here but instead of Airtable I’m using Google Sheets.

image
image1176×584 77.4 KB

The Update Row operation doesn’t seem to be working , if I use the Append I can see the data been added bellow my records…

Am I doing something wrong or there is a limitation with the Google Sheet API ?

image
image2928×1568 397 KB

What is the error message (if any)?

There is no error message

Please share your workflow

Share the output returned by the last node

No output data returned

Information on your n8n setup

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

I got exactly the same issue !

3

@ihortom any idea about it ?

4

from what I can see in your screenshots you are referring to the column “region” to match the row to update in your sheet, but apparently there are no values in that column at all.

I think you probably need to use “customerID” to match your data for updating.

1 Like
5

hey @nabossha

Just checking in, Did @nabossha 's suggestion work for you?

6

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