All Collections
Integrating with Packs
General Pack info
Connect Coda with other apps using Zapier
Connect Coda with other apps using Zapier

This is a how-to for using the Coda app in Zapier to connect your Coda docs to external data

Updated over a week ago

Coda integrates with Zapier giving you the ability to connect Coda to over 1000 other apps that you work with every day. Zapier is a platform that makes it easy for anyone, not just developers, to build workflows that extend across two or more apps. These workflows are called zaps and they’re composed of triggers and actions. A trigger is an event that starts the zap. An action is the event that the zap performs.

Within this article you'll find...


Set up your account 

With the Coda app for Zapier, you can automate workflows bringing data in and out of Coda.  It's a simple way to integrate with other apps.  In Zapier, workflows are comprised of triggers and actions:

Triggers

  • New Row

Actions

  • Create Row

  • Update Row

  • Upsert Row

  • Find Row

If you are a frequent user of Zapier, you may be familiar with the Find Row & Update Row combination. Upsert Row is similar except that it creates/updates a row in one step instead of two. We recommend you use whichever action is easiest for you. 

Set up your Zapier Account

If you don't have a Zapier account, sign up and create one first at Zapier

Create a new row in a table in a Coda doc

You can create new rows in Coda through Zapier based on a trigger coming from another app.

  1. Start by clicking "Make a Zap" in the top right corner of your Zapier account. 

  2. Connect your trigger app - this will be the source of data that gets pushed into your Coda doc.

  3. Type 'Coda' into the Action App search box.

  4. First, you'll be asked to choose an action - pick "Create Row.

  5. Now, connect to your Coda app. Hit "Connect an Account" and you'll get a pop up asking you for your API Token:

    1. Click the link in the pop-up and you'll be taken to your account settings page with your API token - copy that to your clipboard

    2. Go back to the Zapier pop-up window and paste in your key.

  6. Hit "Save & Continue" to continue the set up.

  7. Using the drop down menus, choose what table you want to write to:

  8. The next step is setting up the row you are inserting. Once you've selected a table, the page will refresh with a list of columns that you can insert data into. Note, if you need to add more columns, go back to the Coda doc to add them and then refresh the Zapier page. It make take a few seconds for the new columns to show up.

Test and set it live! You did it! Zap! (If you don't see it come through, try to refresh your Coda doc) 💫

Trigger an action when row is created or updated

When Coda is a trigger, you can trigger actions in other apps when you create new rows in Coda.

*We've omitted the account set up steps from above

1) Start by clicking "Make a Zap" in the top right corner of your Zapier account. 

2) Type 'Coda' into the Action App search box.

3) First, you'll be asked to choose what your trigger should be within Coda. You can select "New Row” to trigger zaps when a new row is created, or “Updated Row” to trigger a zaps whenever a row is updated in the selected table.

4) Now select from your Coda docs where you would like the trigger to come from, and which table should be the trigger and hit continue. 

5) You can now do something every time a new row has been created in the table.  The data from this new row will be available for you to use in the Zapier action step. Set up your action app and you're all set! 

Upsert a row in a table in a Coda doc

Using Upsert Row, you can create or update new rows in Coda through Zapier in a single step.  Since this is done in a single step, you will NOT have access to the data within existing rows before updating them.

*We've omitted the account set up steps from above

1) Start by clicking "Make a Zap" in the top right corner of your Zapier account. 

2) Connect your trigger app - this will be the source of data that gets pushed into your Coda doc.

3) Type 'Coda' into the Action App search box.

4) You'll be asked to choose an action - pick "Create/Update Row."

5) Using the drop down menus, select the doc and table where new/updated rows will go:

6) You'll be asked about matching columns.

  • Create new rows only:  If you only want to create new rows, leave the "Matching Columns" field blank.

  • Create/update rows:  If you want to update rows through Zapier, you'll need to add the names of your Matching columns.  If you include these, we will use the value(s) in this column(s) to identify a row to update.  If it is left blank or we do not find a match, a new row in your table will be created.

7) The next step is setting up the row you are inserting.  Once you've selected a table, the page will refresh with a list of columns that you can insert data into.  Note, if you need to add more columns, go back to the Coda doc to add them and then refresh the Zapier page.  It make take a few seconds for the new columns to show up.

8)  Test and set it live! You did it! Zap! (If you don't see it come through, try to refresh your Coda doc) 💫

FAQs

Why don't I see formula based columns in the column list in Zapier when I am creating/updating a row?

Since formulas apply to the entire column, we do not allow you to edit them on a per-row basis. For this reason, we do not expose them in the create/update row action in Zapier.

How do I write to people or look up columns?

If you write to a people column or a look up column, we will auto-convert raw text values based on an exact match (eg "Molly" won't map to "Molly Rose" or "Launch Site" won't map to "Launch the Website")

Do you support time stamps in your date-time and date column formats?

Yes, we will automatically convert Unix time stamps to date-time and date column formats. Note that we render these times in Pacific time.

Why do I get a 401 error when trying to connect Coda to Zapier?

Go to coda.io/account, find the API Settings section, and check that there aren’t any restrictions on the API token for Zapier. Zapier can’t connect to Coda with anything less than a full access API token.

What can I do with the Coda Zapier integration? What apps can I connect to?

Here are some of our favorite ways to connect with other apps:

  1. Gmail - Save labeled emails from your Gmail inbox in a Coda doc

  2. Google Forms - Save new Google Form responses to a Table

  3. GitHub - Create rows from new GitHub pull requests

  4. Slack - Create rows when new messages are posted

  5. JIRA - Update and create rows when new issues are created in JIRA

  6. Hubspot - Add new deals from Hubspot to a Coda doc

  7. Twitter - Save new Twitter mentions to Coda

  8. Zoom - Create rows based on meetings

  9. Typeform - Save new entries to Coda

  10. Dropbox - Create rows from new files in Dropbox

  11. Intercom - Add new companies to a Coda doc

  12. Google Calendar - Add new or updated Calendar events as rows in Coda


Related resources

Did this answer your question?