Coda Integration [GOT CREATED]

jan · September 8, 2019, 8:44pm

An integration for Coda should be added:

psygen · November 20, 2019, 8:52pm

Same - would instantly switch from Zapier if this was a thing. May even try to make it myself, though I’m not very experienced with this stuff so would be very inefficient.

Is there a guide on creating your own nodes somewhere?

jan · November 20, 2019, 9:12pm

There is documentation about it which can be found here:

github.com

n8n-io/n8n/blob/master/CONTRIBUTING.md

# Contributing to n8n

Great that you are here and you want to contribute to n8n

## Contents

- [Code of Conduct](#code-of-conduct)
- [Directory Structure](#directory-structure)
- [Development Setup](#development-setup)
- [Development Cycle](#development-cycle)
- [Create Custom Nodes](#create-custom-nodes)
- [Create a new node to contribute to n8n](#create-a-new-node-to-contribute-to-n8n)
- [Checklist before submitting a new node](#checklist-before-submitting-a-new-node)
- [Extend Documentation](#extend-documentation)
- [Contributor License Agreement](#contributor-license-agreement)

## Code of conduct

This project and everyone participating in it are governed by the Code of
Conduct which can be found in the file [CODE_OF_CONDUCT.md](CODE_OF_CONDUCT.md).

This file has been truncated. show original

If you have experience with JavaScript or TypeScript you should be good to go.

jan · December 22, 2019, 2:40am

Got created by @RicardoE105 and released with [email protected]

ajayjohn · January 24, 2020, 4:52pm

I am new to n8n and am just discovering available nodes. Was thrilled to see that Coda and ClickUp are supported. @RicardoE105, you just made n8n a whole lot more exciting for me! If possible, it would be great if you supported more triggers/actions in Coda, like being able to push buttons.

RicardoE105 · January 24, 2020, 5:04pm

@ajayjohn glad you liked it. Will check it out the “push button” soon to see what I can do.

ajayjohn · January 30, 2020, 4:50am

@RicardoE105 One more request that I just want to leave here for your consideration…
Could you please add a provision to be able to search/filter rows using Coda formulas, when fetching rows in a table?

RicardoE105 · January 30, 2020, 10:06pm

@ajayjohn just added the push-button operation and added the property query so that you can filter the rows but not sure if that can be used with formulas. The documentation says:

Query is used to filter returned rows, specified as <column_id_or_name>:<value> . If you’d like to use a column name instead of an ID, you must quote it (e.g., "My Column":123 ). Also, note that value is a JSON value; if you’d like to use a string, you must surround it in quotes (e.g., "groceries" ).

There are two more endpoints about formulas but just to retrieve a list of them.

ajayjohn · January 31, 2020, 12:25am

That should be more than sufficient! Thanks again!
Can’t wait for this to be released in the next version.

ajayjohn · February 2, 2020, 6:32pm

@RicardoE105
Could you please clarify how I can pass individual row cell values for Coda, when creating a new row? I was unable to find a parameter for this and setting values as an array and passing it to the node didn’t work either.

RicardoE105 · February 2, 2020, 6:44pm

@ajayjohn the data must come in the input data you provide for that node and using the key Column you reference the property that contains the data.

I Do not have my laptop right know but can send an example when I have it.

jan · February 2, 2020, 7:36pm

Here an example for what @RicardoE105 described which assumes that assumes that you have two columns in the table named “Name” and “Email”:

ajayjohn · February 3, 2020, 12:47am

Thanks a lot for the prompt responses, @RicardoE105 and @jan.
The node works perfectly for me now

ajayjohn · February 3, 2020, 8:06pm

@jan, @RicardoE105,
I am absolutely loving the way I can automate operations in Coda as a platform! In fact using a combination of webhooks, IFTTT and the Coda node, I was just able to add new rows to my tables via voice commands to my Google Home/Assistant

If possible, could you please consider the following calls in your roadmap? I know Update/Insert, Delete rows are possible, but many of the other calls in this list are also immensely useful. It would be fantastic to have them work, in order to get a fully featured Coda integration available.

Coda API (v1) Reference Documentation ()
Coda API (v1) Reference Documentation ()
Coda API (v1) Reference Documentation ()
Coda API (v1) Reference Documentation ()
Coda API (v1) Reference Documentation (some operations here are already supported, but not all)

In the mean time, I am also working with Coda support to get webhooks exposed for events like ‘new row created’. Hopefully that should allow us to have a Coda trigger too.

RicardoE105 · February 4, 2020, 12:42am

@ajayjohn I just finished all the features you asked for above. As always @jan will let you know when is released.

ajayjohn · February 4, 2020, 2:49am

Already?
And here I was, requesting that you add this to your roadmap!

Thanks a ton, @RicardoE105!

ajayjohn · February 7, 2020, 8:01pm

@jan Do you know when the next version of n8n will be released? I am eagerly waiting to use the horde of new features that Ricardo just added to this node

jan · February 7, 2020, 8:45pm

Yes, I try to release it today or tomorrow.

jan · February 8, 2020, 7:57am

Got released with [email protected]

Welley · August 2, 2020, 2:02am

Hi all! I got this announcement from Coda that they launched a new API:

Maybe the implemented integration will be deprecated by August 21, 2020.