# Google Sheet Update ?!

**URL:** <https://community.n8n.io/t/google-sheet-update/18118>\
**Category:** Questions\
**Created:** [September 26, 2022, 4:34pm UTC](https://community.n8n.io/t/google-sheet-update/18118 "2022-09-26T16:34:57Z")\
**Posts on this page:** 15\
**Page:** 1

<div class="post-metadata">

**Author:** ![AnthonyPM](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/anthonypm/32/10871_2.png) [@AnthonyPM](https://community.n8n.io/u/AnthonyPM)\
**Post date:** [September 26, 2022, 4:34pm UTC](https://community.n8n.io/t/google-sheet-update/18118/1 "2022-09-26T16:34:57Z")

</div>

Hi everyone,

I’m n8n begginer.  
I would like to update already existing ID’s row in my gsheet with Notion’s page id !

No errors but it wrotte nothing … Someone can help me pls ?

thx

 ![Capture](https://europe1.discourse-cdn.com/n8n/original/3X/5/c/5c1b52f4ba78e6665eef7e84cfcad5080b421f35.png)

---

<div class="post-metadata">

**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [September 26, 2022, 4:39pm UTC](https://community.n8n.io/t/google-sheet-update/18118/2 "2022-09-26T16:39:24Z")

</div>

Hey @AnthonyPM,

Welcome to the community 🙌

Can you share the output of the Set node and the Google Sheets Update node?

---

<div class="post-metadata">

**Author:** ![AnthonyPM](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/anthonypm/32/10871_2.png) [@AnthonyPM](https://community.n8n.io/u/AnthonyPM)\
**Post date:** [September 26, 2022, 4:44pm UTC](https://community.n8n.io/t/google-sheet-update/18118/3 "2022-09-26T16:44:05Z")

</div>

Hi Jon,

Thx a lot !  
For sur :

 ![Capture2](https://europe1.discourse-cdn.com/n8n/original/3X/5/f/5fadd7e193c88651f82a3dc01833adc4bd0690e8.png)  
 ![Capture](https://europe1.discourse-cdn.com/n8n/original/3X/2/a/2a8c74cbc45b655aa6ebd422998e9d55df04338d.png)

---

<div class="post-metadata">

**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [September 27, 2022, 7:40am UTC](https://community.n8n.io/t/google-sheet-update/18118/4 "2022-09-27T07:40:10Z")

</div>

Hey @AnthonyPM,

Thanks, Can we also get the output data from the 2 nodes?

---

<div class="post-metadata">

**Author:** ![AnthonyPM](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/anthonypm/32/10871_2.png) [@AnthonyPM](https://community.n8n.io/u/AnthonyPM)\
**Post date:** [September 27, 2022, 8:21am UTC](https://community.n8n.io/t/google-sheet-update/18118/5 "2022-09-27T08:21:21Z")

</div>

![Capture2](https://europe1.discourse-cdn.com/n8n/original/3X/4/5/45a3e5337237b24314b297c595531476420dc11b.png)  
 ![Capture](https://europe1.discourse-cdn.com/n8n/original/3X/4/a/4acdc545c7aacceb3d639e34a028786df110a1a9.png)

---

<div class="post-metadata">

**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [September 27, 2022, 9:29am UTC](https://community.n8n.io/t/google-sheet-update/18118/6 "2022-09-27T09:29:35Z")

</div>

Hey @AnthonyPM,

That looks to be the same, To the right of that there should be the output a but like this.

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/1/8/182c41de8ec2cdc33872573652c5e28a3b55039e.png)

---

<div class="post-metadata">

**Author:** ![AnthonyPM](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/anthonypm/32/10871_2.png) [@AnthonyPM](https://community.n8n.io/u/AnthonyPM)\
**Post date:** [September 28, 2022, 6:23am UTC](https://community.n8n.io/t/google-sheet-update/18118/7 "2022-09-28T06:23:55Z")

</div>

i don’t really understand ? i need to use MySQL ? why the update work perfectly with notion and not with Gsheet ?  
I select the right sheet / I find the account with " IF " / I set the string value / Select the same set up in Gsheet update final node … But nothing append … The function append or create works … Give me some light pls --‘’’

---

<div class="post-metadata">

**Author:** ![StocktonF](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/stocktonf/32/15412_2.png) [@StocktonF](https://community.n8n.io/u/StocktonF)\
**Post date:** [September 28, 2022, 6:54am UTC](https://community.n8n.io/t/google-sheet-update/18118/8 "2022-09-28T06:54:18Z")

</div>

I also have a case where there are no errors, but no data is appended to Google Sheets.

 ![image](https://europe1.discourse-cdn.com/n8n/original/3X/9/a/9a5ece6cb2bd7a43f5ab991151494f6522785f49.jpeg)

---

<div class="post-metadata">

**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [September 28, 2022, 8:21am UTC](https://community.n8n.io/t/google-sheet-update/18118/9 "2022-09-28T08:21:31Z")

</div>

Hey @AnthonyPM,

That was just an example of what I meant by the output data, It is the parts on the right side of the node input I was after.

@StocktonF welcome to the community 🙌, In your Google sheet do you have the header row set and is the node enabled?

---

<div class="post-metadata">

**Author:** ![StocktonF](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/stocktonf/32/15412_2.png) [@StocktonF](https://community.n8n.io/u/StocktonF)\
**Post date:** [September 28, 2022, 2:17pm UTC](https://community.n8n.io/t/google-sheet-update/18118/10 "2022-09-28T14:17:22Z")

</div>

@Jon Thank you, happy to be here 🙂

Here are some additional details.

Google Sheet  
 ![Ads Lab - IDR Rhoda Lucas - Google Sheets - Google Chrome 2022-09-28 at 7.14.28 AM](https://europe1.discourse-cdn.com/n8n/optimized/3X/3/5/3532476a4e429c7298af4e14247d8947d94b8abd_2_690x44.jpeg)

Key Row is set to row 1 because that’s where the headers are.

Sorry to hijack this thread, but is this the best place to get some help on my issue (N8N looking successful but Google Sheets is not updating)?

---

<div class="post-metadata">

**Author:** ![Internalit\_Automatio](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/internalit_automatio/32/12481_2.png) [@Internalit\_Automatio](https://community.n8n.io/u/Internalit_Automatio)\
**Post date:** [September 28, 2022, 2:19pm UTC](https://community.n8n.io/t/google-sheet-update/18118/11 "2022-09-28T14:19:50Z")

</div>

@StocktonF Hi!

Use Operation in Google Sheets “Create or Update” and put a key that is only unique, in my case with that operation it has worked

---

<div class="post-metadata">

**Author:** ![StocktonF](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/stocktonf/32/15412_2.png) [@StocktonF](https://community.n8n.io/u/StocktonF)\
**Post date:** [September 28, 2022, 2:22pm UTC](https://community.n8n.io/t/google-sheet-update/18118/12 "2022-09-28T14:22:38Z")

</div>

I actually changed the key to “0” since that’s where it should start (not 1).

But oddly enough, new data was appended to in L:X and not A:M…

So that’s weird. Any thoughts there?

 ![results](https://europe1.discourse-cdn.com/n8n/original/3X/2/0/208f9040396909893b782c7d686f1accac212f11.jpeg)

---

<div class="post-metadata">

**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [September 28, 2022, 3:39pm UTC](https://community.n8n.io/t/google-sheet-update/18118/13 "2022-09-28T15:39:31Z")

</div>

That is very strange, Just for science what happens if you click in A1 then run the workflow or is that what you did?

---

<div class="post-metadata">

**Author:** ![StocktonF](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/stocktonf/32/15412_2.png) [@StocktonF](https://community.n8n.io/u/StocktonF)\
**Post date:** [September 28, 2022, 3:59pm UTC](https://community.n8n.io/t/google-sheet-update/18118/14 "2022-09-28T15:59:21Z")

</div>

That doesn’t make a difference.

The solution for me was actually just to use a different sheet… luckily that was an option for me in this case.

Something must have been weird on that sheet that caused that weird behavior because it’s fine in the new tab.

Thank you so much! 🙂

---

<div class="post-metadata">

**Author:** ![Jon](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/jon/32/40174_2.png) [@Jon](https://community.n8n.io/u/Jon)\
**Post date:** [September 28, 2022, 4:31pm UTC](https://community.n8n.io/t/google-sheet-update/18118/15 "2022-09-28T16:31:54Z")

</div>

Hey @StocktonF,

That is odd, On the plus side we are currently working on making the Sheets node a lot better. After using the new version I actually dislike using the old version so you have that to look forward to soon 🙂
