Update a single cell in a Google spreadsheet

[Robbit]

Hello,

I’d like to update a single cell in a Google spreadsheet (with the timestamp of the most recent data update). This cell is within a big matrix of several data which makes it impossible to update a whole row. The node only offers options to update a whole row. Also this post Update specific cell in Google Sheets based on column and row - #2 by ihortom reads, that there is actually no way to alter a specific cell, only.

I can not believe that there is no way to update a cell (without using a cumbersome extra sheet containing all data by rows. So what is the gold standard to do this?

Thanks and best regards
-Robbit.

Share the output returned by the last node

• n8n version: 1.65.2
• Database (default: SQLite): (where to find out within GUI?)
• n8n EXECUTIONS_PROCESS setting (default: own, main):
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: Windows 11

[alexroot]

Here you go, this should work. Use the HTTP Request node.

[Robbit]

Thank You very much, that will do. However it would be much easier to handle and way better to grasp at a first glance at the workflow if there is a dedicated option for a single cell update within the usual Google Sheets node. We often need to drop a timestamp or a manipulation of an entry. We’d appreciate if this is considered as an extremely valuable feature.

Thanks in advance and best regards
-Robbit.

[ihortom]

You can change a sigle cell with Google Sheets node. Though you do need one more cell to make match and find the row that has the cell you are looking for. So, technically you need 2 cells for this.