# Update Google sheet - node does not find the right column to update

**URL:** <https://community.n8n.io/t/update-google-sheet-node-does-not-find-the-right-column-to-update/25974>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [May 8, 2023, 2:45pm UTC](https://community.n8n.io/t/update-google-sheet-node-does-not-find-the-right-column-to-update/25974 "2023-05-08T14:45:34Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![fxholl](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/fxholl/32/18964_2.png) [@fxholl](https://community.n8n.io/u/fxholl)\
**Post date:** [May 8, 2023, 2:45pm UTC](https://community.n8n.io/t/update-google-sheet-node-does-not-find-the-right-column-to-update/25974/1 "2023-05-08T14:45:34Z")

</div>

I created a simple workflow where I am reading a Google Form spreadsheet and send some of the data to another system called Kiskadi via API. Since I do not want to send the same data twice to Kiskadi, I added a column named “kiskadi-processed”, and I want to update each row after the data has been retrieved and sent to Kiskadi.

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/7/5/7554b9a5af769b40a568811c4ea4d0609fa24403.png)

1. I use a Google Sheet node to filter the rows when the colum “kiskadi-processed” is empty:

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/f/5/f59f2a4f2a73c9164784a0eca1eefde99b92f65c.png)

That works fine.

1. I send some of the data to Kiskadi via HTTPS node, and that works fine too.

2. I want to update the row to mark it as processed using a Google Sheet node Append or update. However under “Values to send”, I am unable to select the column “kiskadi-processed” and update it

 ![n8n - ▶️ Justiceiras - puxar Devolutivas e enviar pro Kiskadi](https://europe1.discourse-cdn.com/n8n/original/3X/a/7/a7888c43d12e48bbdd92713ef3a63bf86f7e80b7.png)

Any sugestion?

## Please share your workflow

## Share the output returned by the last node

## Information on your n8n setup

- **n8n version:** 0.225.2
- **Database (default: SQLite):** postgres
- **n8n EXECUTIONS\_PROCESS setting (default: own, main):** main
- **Running n8n via (Docker, npm, n8n cloud, desktop app):** docker
- **Operating system:** linux

---

<div class="post-metadata">

**Author:** ![fxholl](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/fxholl/32/18964_2.png) [@fxholl](https://community.n8n.io/u/fxholl)\
**Post date:** [May 8, 2023, 3:02pm UTC](https://community.n8n.io/t/update-google-sheet-node-does-not-find-the-right-column-to-update/25974/2 "2023-05-08T15:02:23Z")

</div>

I found out what I did wrong: the “Column to match on” is where the node will find the unique ID for the row to be updated.

I changed this column to match on to another column, and then I was able to select the “kiskadi-processed” as the column for "Values to send "

---

<div class="post-metadata">

**Author:** ![EmeraldHerald](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/emeraldherald/32/35355_2.png) [@EmeraldHerald](https://community.n8n.io/u/EmeraldHerald)\
**Post date:** [May 8, 2023, 3:02pm UTC](https://community.n8n.io/t/update-google-sheet-node-does-not-find-the-right-column-to-update/25974/3 "2023-05-08T15:02:55Z")

</div>

Thanks for posting your solution, @fxholl !

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [May 15, 2023, 3:03pm UTC](https://community.n8n.io/t/update-google-sheet-node-does-not-find-the-right-column-to-update/25974/4 "2023-05-15T15:03:35Z")

</div>

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