Can't change or add anything to a google sheet

Questions
1

Describe the problem/error/question

No matter how I try to do it (through an agent, directly using the node, append, update) I can’t not get information to populate inside of a google sheet. I have even tried using the data to just create a new file and I will create the file and even the different sheets inside of it, but won’t populate any of the cells.

What is the error message (if any)?

None. It’s acting as if everything if functioning correctly

Please share your workflow

(Select the nodes on your canvas and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow.)

n8nscreenshot
n8nscreenshot1898×935 176 KB

Share the output returned by the last node

Information on your n8n setup

  • **n8n version:**1.78.1
  • **Database (default: SQLite):**none
  • **n8n EXECUTIONS_PROCESS setting (default: own, main):**I don’t know what this is (treat me like I know nothing, because I don’t know much more than that)
  • **Running n8n via (Docker, npm, n8n cloud, desktop app):**Docker
  • **Operating system:**unraid
2

hello @Michael_Dibert

so what is the issue? Seems everything is fine. You have 15 items in the input and 15 items in the google sheet output.

3

Nothing is actually showing up in Google Sheets. Either in existing sheets or when it creates a new sheet. It will create the new file and everything, but it won’t fill in any cells.

4

hm.. that’s strange. And is there an empty sheet when you click on that button?

image
image605×497 49.5 KB

5

Not that one in particular, but I spent the better part of a week trouble shooting so I have tried all kinds of combinations and completely blank was one of them. All other sheets functions work correctly except for anything that writes to any cells.

6

Please show us what you see when you click this:

image
image389×263 23.8 KB

Also, if you could share an example Sheet so we can reproduce your workflow, it might help to get to the bottom of this issue.