Is there a good documentation for Coda Node in N8N?

1

I want to connect my Coda tables and perform different operations depending on use cases in my N8N workflow, but the documentation feels very non-intuitive.

The documentation link:

Is there clearer documentation available?

2

Not really. Think of each table needing a tool of its own. What are you trying to do?

3

Thanks Doug for the response.

I want to complete 2 types of Operations:

  1. Perform CRUD(Create, Read, Update, Delete) operation on a row within Coda through N8N (was able to do Create operation, but rest feels too complicated)
  2. Trigger and send data to N8N webhook on Button press in Coda (eg. I can Objectify the row into JSON object using formula and then pass that data to N8N on button press)
4

Sorry for the delay – I answered from the wrong mailbox and the system got mad at me…

My experience with this is from the outside. I have an Ai Assistant that writes notes into Coda and gets information out of Coda. As simple as asking for info, like an email address, from Coda through n8n and updating client and company records regarding a meeting I had. Those use n8n tools and GET and POST. Is that the sort of thing you’re interested in?

You may also want to talk to Troy Larson about this. He has an entire wonderful course on building Assistants that do this…

  • Doug

Douglass N. Loud, Esq.

President

Integrated Information Systems, Inc.

305 East 40th Street, Suite 12E

New York, NY 10016

203-952-7108 cell

Email: dloud@integratedinformation.net

WebSite: www.integratedinformation.net

Coda Link: https://coda.partnerlinks.io/dj6ap9gplunv

5

Got it. It would be great help if you can help me in understanding how I can update any cell value of a row in coda.

eg. I have “test” table containing following entries

ID | Col1 | Col2

1 | Dog | Bark
2 | Cat | Meow

Now I want to update my Col1 value for ID=2 to “Cow” using N8N…so that the updated table looks like

ID | Col1 | Col2

1 | Dog | Bark
2 | Cow | Meow

6

Ooops - forgot to ask: are you able to add a record to Coda now through n8n and just want to be able to change them, or are you starting from scratch adding, modifying, deleteing records into Coda. If you have managed to Add Records, what method did you use to do it?

7

I did some digging and also gained some clarity on what I want. What I effectively want is to do a POST request through a button press in Coda. I want to send this data to N8N webhook where it will get processed accordingly.

While, I don’t have javascript coding experience, I created a pack to do POST request using AI.

The issue I am facing now is that this pack is very unreliable. Sometimes it works and some times it doesn’t. I don’t have any clue as to what might the problem be. Attaching the code used to do POST request. Is there something I am missing in the coda to make it more robust.

pack.addNetworkDomain('my domain');

pack.addFormula({
  name: "POST",
  description: "Send a POST request to a specified URL with a JSON payload.",
  isAction: true,
  parameters: [
    coda.makeParameter({ type: coda.ParameterType.String, name: "url", description: "The full URL of the request." }),
    coda.makeParameter({ type: coda.ParameterType.String, name: "payload", description: "A payload object created with an Object() formula." }),
  ],
  resultType: coda.ValueType.String,
  execute: async function ([url, payload], context) {
    const headers: { [key: string]: string } = {
      "Content-Type": "application/json",
    };

    const request: coda.FetchRequest = {
      url,
      method: "POST",
      headers,
      body: payload,
    };

    let response = await context.fetcher.fetch(request);

    if (response.status >= 200 && response.status < 300) {
      return response.body;
    }

    return `Error: ${response.status}`;
  },
});
8

Not sure I can help with this part. I used n8n tools and AI instructions to update Coda fields based on the info in the prompt rather than using a pack (such as talking to my iphone and telling my Coda system that I met with Joe Blow from Widget Corp and we talked about using red pipes for his new project). It was easier than writing a pack. Troy Larson, among others, knows all about this and packs. You could certainly tell n8n tools to get some Coda info and send it over to your other url. I gather you want to do all this from inside Coda.

9

Oh…no worries.
Thanks :slight_smile: