N8n - How to update a row in Coda?

[ManyQuestions]

Describe the problem/error/question

Hi people,

I tried for days now - can’t make it work. Can someone help / send a video?
All i want to do is update a cell in a document in coda from n8n.

Thx alot

Please share your workflow

Information on your n8n setup

• n8n version: Current
• Database (default: SQLite): SQLite
• n8n EXECUTIONS_PROCESS setting (default: own, main): default
• Running n8n via (Docker, npm, n8n cloud, desktop app): Docker
• Operating system: MacOS

[Jon]

Hey @ManyQuestions,

I don’t use Coda myself but are you seeing any errors when trying to update a row?

[ManyQuestions]

Problem is: which action to use…

The only thing that would make sense is:
(a view is like a synced copy of a table, but then i don’t understand why not update a cell in a table)

here i don’t know:

• what Key name means (i tried the column name but didn’t work…)
• what i am doing wrong

[Jon]

Hey @ManyQuestions,

It owuld be update row, The key name field would be the name of the keys from the previous node that you want to send to Coda.

[ManyQuestions]

Hey @Jon, I did update my last comment and explained a little more. Also i don’t really understand your last comment.

[Jon]

Hey @ManyQuestions,

With the coda node we send the data from the node before it, Looking at the node again though unless you are updating a field in a view we don’t have the option to just update a table row only create or delete. I guess the update option was missed when the node was created.

[ManyQuestions]

I can update a field in a view. That’s not a problem. But where can select which column it should update?

[Jon]

Hey @ManyQuestions,

I was setting up a trial account with Coda and it turned out I already had one. I did some looking around and I found that I previously spent some time working this out which can be found here: Seeking Assistance with Key Name Values in Coda's Update Row Operation using n8n - #3 by EmeraldHerald

Let me know if that helps.