Google sheets - append works? but does not append anything

I have been struggling to make this work. In another workflow, I am able to make the ‘Create or Update work’ but not the append. Here goes:

For the sake of simplicity, here are the last two nodes in the workflow in :one:. As you can see it seems to have worked! (see :two:) But the data did not show up in the google sheet

My google sheet has the column names appear in the exact same order :three: (you can see part of the header row), and with the same labels (column names)

I would appreciate any help or pointers to help me fix this

Describe the issue/error/question

What is the error message (if any)?

Please share the workflow

(Select the nodes and use the keyboard shortcuts CMD+C/CTRL+C and CMD+V/CTRL+V to copy and paste the workflow respectively)

Share the output returned by the last node

Information on your n8n setup

  • n8n version:
  • Database you’re using (default: SQLite):
  • Running n8n with the execution process [own(default), main]:
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]:

Hi @sunnym, I am sorry to hear you’re having trouble.

In a first step, you might want to upgrade to a more recent version of n8n and add a fresh Google Sheets node to your workflow. The node got an upgrade recently and should be a bit simpler to use now.

That said, your existing workflow logic using the old version of the node still looks good to me. Can you try if you are also having problems with a brand-new Google sheet document to which you add a type and direction column?

If this works with a new sheet (but not your existing sheet), it could be a simple case of left over data somewhere in your sheet, causing n8n to try and append somewhere beyond that data.

If that’s not it, could you create an example sheet and workflow using which the problem can be reproduced?

Hi @MutedJam : Yes, this was it. Thank you so much for your help and the detailed explanation.

I had kept my version lagging by 2 to avoid any undiscovered issues. This new node is really good and makes the whole process very intuitive.

1 Like

Oh nice, glad to hear this is now working, thanks so much for confirming!

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