Featured image with Logos for Airtable and Trello, representing Unito's guide to syncing Airtable and Trello work items with a 2-way integration.
How to Sync Trello Cards and Airtable Records with Automated 2-Way Updates
Featured image with Logos for Airtable and Trello, representing Unito's guide to syncing Airtable and Trello work items with a 2-way integration.

How to Sync Trello Cards and Airtable Records with Automated 2-Way Updates

How many Trello cards or Airtable records are you managing on a daily basis? 50? 500? 5000? The more you have, the harder it becomes to manage them all and make sure nothing gets missed. Our team at Unito has over one thousand articles between our blog and the Unito knowledge base. How do we manage them, as well as the influx of new content? With Unito, of course!

In our case, freelancers work on content assigned to them in Trello cards, which are then synced to our internal Airtable base (which they don’t have access to). That way, we can always see how things are going without sharing access to the entire database with external contacts. This is just one use case of countless possibilities. However you’re working in Trello and Airtable, you can optimize that process with Unito. That’s what this guide will show you how to do.

Integrating Airtable and Trello with Unito eliminates the need to copy/paste details from one place to the other, drastically reduces the risk of human error, and can help your team work smarter. ou can connect these two powerful tools to achieve all kinds of use cases from reporting on team progress, to building a database of active tasks from which you can delegate new assignments.

If you’re looking for some inspiration, you can start with our Automated Resource Management Report template for Airtable users, which this flow will show you how to implement.

In this article:

Setup in Airtable and Trello

To sync your Trello cards and Airtable records, we’ll show you how to build a flow in Unito. A flow represents the connection between tools in which Unito automatically creates cards or records that update each other automatically whenever changes are made.

A note about permissions: Unito can only operate within the same permissions as the user who authorizes an account in Trello and Airtable.

Questions about security? Unito is SOC 2 Type II certified and compliant with international data privacy regulation including GDPR and CCPA, among others.

Add Unito to your Trello Board (optional)

This step is for users who wish to add Unito as a Power-Up to an existing Trello board. You can skip this process if you’ve already installed Unito or you’ve logged in directly to our app. Otherwise, click here if you need help adding Unito as a Trello Power-Up.

Unito Power-Up Airtable Trello
Pick the Unito Power-Up that best matches your app needs

Add a Last Modified Time field in Airtable

You’ll also need to add a Last Modified Time field as your last column in Airtable (not to be confused with Last Modified By). This sets a boundary for Unito on which columns to include and which to ignore.

Here’s how to add a Last Modified Time field (click to expand)

From your Airtable base, click + to add a column, scroll down the list and look for Last Modified Time.

Last Modified Time field in Airtable
Not to be confused with Last Modified By.

Now you’re ready to build a flow in Unito!

Step 1: Connect Trello and Airtable to Unito

  1. Log in to the Unito App and click +Create Flow.
  2. Then, click Start Here to connect your tools.
  3. Select +Add a tool to this flow in either column, and connect Airtable. Now, +Choose account to specify the Airtable account you want to use.
  4. Pick the Airtable base you want to connect to Unito.
  5. Repeat steps 3 and 4 to connect Trello with Unito.
  6. Click Confirm.
Connecting Airtable and Trello to Unito

If this is your first time connecting Airtable to Unito, you’ll have to go through a quick authorization process:

Step 2. Choose a flow direction for creating new records or cards

Flow direction determines how new work items are created by Unito.

That means we’re deciding how new Trello cards or Airtable records are created through Unito’s automation rules (configured in the next step).

All you have to do now is decide if you want Airtable activity to create cards in Trello, vice versa, or both simultaneously.

Airtable to Trello flow direction with Unito two-way sync
In this example we’re sending newly created cards into Airtable as records. But if we create records in Airtable manually, they won’t sync back to Trello. Updates will still sync bi-directionally though between the records in Airtable created by Unito.

Select Confirm when you’ve chosen a flow direction.

Step 3: Filter out unrelated Trello cards and Airtable records with rules

This is where you can set up triggers to determine which actions taken in one tool will create new work items in the other.

Select Add a new rule to begin setting up your rules. There can be some variability here, depending on your particular setup in each tool.

Setting rules to sync Trello cards to Airtable as records with Unito
In this example, our rule to create new Airtable records based on Trello cards will depend on labels we choose. If a Trello card has any of the labels we select, it will automatically create a linked Airtable record and keep both in sync.

You can learn more about setting up rules here.

Unito turns every detail of your Trello cards and Airtable records into mappable fields that can be synced between tools. In Airtable, these fields are based on the names of each column, while in Trello they can be any card detail: member, card title, board name, description, comments, attachments, etc.

When you first open this screen, you’ll be presented with two options. Select Auto-map to begin with a pre-built template that can later be modified.

Most fields will be automatically mapped for two-way updates, but you can modify each individually if you prefer one-way updates in some cases. With two-way updates, changes made in either tool will automatically update the other. A one-way update restricts changes to a single direction.

Select +Add Mapping, then Select a field in both tools to pair the fields together.

syncing fields between Airtable records and Trello cards with Unito, including label to status.

Any field with a gear/cog icon can be further modified with precise mappings for each value. Usually this relates to a field with multiple options, such as a drop-down list.

Sync custom fields from Trello to maximize your workflow

Here’s a closer look at a re-creation of a Unito power user’s field mappings between Trello and Airtable. To emulate that user’s workflow, our team created 20 new custom fields in Trello and synced them all into our database in Airtable.

This is where Unito truly shines:

Syncing Trello custom fields to Airtable with Unito

Click confirm when you’re satisfied with your field mappings.

Step 5: Launch your new Trello Airtable integration!

And that’s it! You’ve just build a flow between Airtable and Trello. Congratulations!

If you followed the steps above, your flow will now:

  • Automatically create new Airtable records and Trello cards based on specific activity in the other.
  • Keep fields up to date in both tools.
Airtable records synced to Trello cards through Unito 2-way sync
Every category or column in our tools becomes a field that Unito can map to any other. Since every column in Airtable is a custom field, we can choose names that intuitively match those in Trello: task name to card title, assignee to member, due date to due date, etc.

What’s next after setting up a two-way integration between Trello and Airtable?

Try out these Airtable templates and sync them with Unito to match your use case:

If you want to know what else you can do with Unito, here’s some inspiration to help you power up your workflows.

Why sync Airtable and Trello with Unito?

In this guide, you’ll learn how to sync Trello cards with Airtable records through Unito’s two-way no-code integration. Airtable and Trello are both versatile, intuitive tools that serve very different purposes. The former is fantastic for record-keeping and building comprehensive databases. Although it does offer task management functionality, that’s not its primary purpose.

Get the best of both worlds with simple automation

With Trello, the opposite is true: it’s incredibly easy and intuitive when you want to build out boards with detailed cards full of task information. But reviewing everything in a single view requires some skill and effort. Unito gives you the best of both worlds with the help of two-way automation and a simple set of rules.

That’s because Unito is the only solution that can sync data between Airtable and Trello in both directions. So Trello cards can turn into Airtable records and Airtable records can turn into Trello cards, while details in both can update in the other in real-time.

Also, just FYI: the steps included in this guide easily apply to other project management integrations with Airtable, including Asana, Wrike, monday.com, ClickUp and more.