Broken google sheets node? Potential bug?

Questions
1

Describe the problem/error/question

Everything seems to process fine. It simply does not update my sheets (My update google sheets node I added below). I’ve tried everything I can think of. Tried making a new sheet, making a new tab in the sheet, changing some values to see if it’s just that row. The most interesting Is I have another flow that is EXACTLY the same except it is for a different data base, but all other factors are equal. I even tried hard coding it. I’m at a loss. I also updated my N8N since I self host, which for whatever reason got rid of the non-json header option for HTTP request but that’s a problem for a different post.

What is the error message (if any)?

No error.

Please share your workflow

Share the output returned by the last node

So not the last node, it’s this “Add Company2” node. I see it outputs the correct data. I attached a screenshot below of the output and of the not updated sheets. However my rows never get updated with “Yes” in the processed column…

image
image1650×218 25.5 KB

image
image1851×813 119 KB

Information on your n8n setup

  • n8n version: Latest
  • Running n8n via (Docker/Cloolify, Oracle/cloudflare):
  • Operating system: windows 10
2

Hey, so if I understood correctly, you have another one working that updates a different sheet with the same credentials, correct?

Have you already tried building a new separate workflow from scratch, and testing 2 nodes inside:

  1. Node updating the other sheet that normally works
  2. Node updating the affected sheet

This way we can understand if this is affecting a sheet or the entire workflow becomes somehow corrupted.

3

Quick Debug Checklist

  • Sheet name & tab correct

  • Row ID or unique column matches exactly

  • Credentials have edit permission

  • Hardcoded test works

  • Use “Get Rows” to confirm row exists

  • Node expressions point to correct previous node output

4

Thank you for your reply. I’m testing a solution that there’s some duplicates in my sheets and I think It can’t find the correct person since there’s multiple. I’m trying to do a dedupe flow using the google sheets api, was working but after I updated or maybe google updated I get an error saying i’m not authorized.

I have tried both those unfortunately.