# How to change the value of a cell in Google Spreadsheets by specifying its row and column?

**URL:** <https://discourse.nodered.org/t/how-to-change-the-value-of-a-cell-in-google-spreadsheets-by-specifying-its-row-and-column/85820>\
**Category:** General\
**Created:** [23 February 2024 14:27 UTC](https://discourse.nodered.org/t/how-to-change-the-value-of-a-cell-in-google-spreadsheets-by-specifying-its-row-and-column/85820 "2024-02-23T14:27:37Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![zan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zan/32/88584_2.png) [@zan](https://discourse.nodered.org/u/zan)\
**Post date:** [23 February 2024 14:27 UTC](https://discourse.nodered.org/t/how-to-change-the-value-of-a-cell-in-google-spreadsheets-by-specifying-its-row-and-column/85820/1 "2024-02-23T14:27:37Z")

</div>

Hi!  
Using Apps Script, I'm sending information from Google Spreadsheets to Node-Red about cells that are edited by users (column, row, and the value of the edited cell).

Is there any sensible way to change the value of that cell in Spreadsheets from Node-Red?

I've tried using node-red-contrib-google-sheets, but I don't think it allows editing a cell by specifying its row and column.

Any kind soul willing to help?

---

<div class="post-metadata">

**Author:** ![TotallyInformation](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/totallyinformation/32/31_2.png) [@TotallyInformation](https://discourse.nodered.org/u/TotallyInformation)\
**Post date:** [23 February 2024 17:47 UTC](https://discourse.nodered.org/t/how-to-change-the-value-of-a-cell-in-google-spreadsheets-by-specifying-its-row-and-column/85820/2 "2024-02-23T17:47:27Z")

</div>

> [@zan](#):
>
> node-red-contrib-google-sheets

It absolutely claims to be able to write as well as read.

I don't really use the Google office products so I'm rather rusty - when you define the service account, do you need to give it permissions to make changes?

Also, I note that the node has an example that you can load from the library that includes updating a single cell.

---

<div class="post-metadata">

**Author:** ![zan](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/zan/32/88584_2.png) [@zan](https://discourse.nodered.org/u/zan)\
**Post date:** [23 February 2024 18:33 UTC](https://discourse.nodered.org/t/how-to-change-the-value-of-a-cell-in-google-spreadsheets-by-specifying-its-row-and-column/85820/3 "2024-02-23T18:33:28Z")

</div>

Thanks! I've found comment on github that solves all my problems 🙂

_you can specify the value for Sheet and Cells in the msg.cells property on input and leave the config in the node blank._

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [8 March 2024 18:33 UTC](https://discourse.nodered.org/t/how-to-change-the-value-of-a-cell-in-google-spreadsheets-by-specifying-its-row-and-column/85820/4 "2024-03-08T18:33:38Z")

</div>

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