How to Sync Airtable to Jira With Automated 2-Way Updates

How to Sync Airtable to Jira With Automated 2-Way Updates

In this guide, we’ll show you how to sync Airtable records to Jira with automated 2-way updates whenever changes occur. This simple Airtable Jira integration takes just minutes to set up and can be performed by anyone on your team, no coding knowledge required. Our demo use case will show you how to send Airtable records into Jira as tasks, but you can apply the same steps and principles to any use case you have in mind between these powerful tools. We’ll connect our Jira instance and Airtable base with Unito’s no-code sync platform.

Note: Unito supports Jira Work Management, Software Cloud, Data Center, and Service Management. If you’re new to Unito you can check out our Airtable + Jira integration overview before coming back here to connect your tools.

Here’s a side-by-side look at an Airtable record synced to a matching Jira task with Unito:

A screenshot of an Airtable record synced to a matching Jira Work Management task with highlights pointing out some of the synced fields.

Watch this Jira Airtable integration in action:

This Jira-Airtable integration has two goals:

  1. Create new tasks in Jira based on records in Airtable with specific statuses.
  2. Keep those tasks and records in a two-way real-time sync so that changes in either tool will appear in the other.

Before you connect Jira and Airtable to Unito

Whether you’re syncing data from Jira Work Management, Software Cloud, Data Center or Service Management, you’ll need to configure Jira for Unito access. Here’s how:

Configure Jira for Unito access:

These steps are only necessary the first time you sync Jira with Unito. First, the Jira account connected to Unito must have administrator access with global permissions.

Set your Jira contact email visibility to anyone from your Jira profile page.

Jira profile page to change email contact visibility
Changing your Jira contact email visibility enables Unito to discover your account and sync Jira issues to Trello.
  1. Log in to Jira through Atlassian.com.
  2. Click Settings, then select Products.
  3. On the next screen, click Application links.

4. Enter https://app.unito.io in the Application field and click Create new link.

5. In the “Link Applications” modal window, complete these fields and leave the others blank.

  • Application Name: Unito
  • Application Type: Generic Application
  • Create incoming link: checked

6. In the second form, complete these fields.

  • Consumer Key: unito (all lower case)
  • Consumer Name: Unito
  • Public Key: copy paste the text below

—–BEGIN PUBLIC KEY—–
MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQDKYFuFsWD7ShJeazewedP2jUZt
ueK30giaA2QSGfhkryQHdwK0YGVGCgJ42muX/Aw53wdpl7g+7Xq8aO/xV7JjO5RG
e3VSBzKUak0/PhHYrg2Cvrj3hws833f3cXSlntMnT7Y/PGfQYyOUmzNBIha1IRrQ
CHeNnq2VbC6N9SL55wIDAQAB
—–END PUBLIC KEY—–

Click Continue.

Add a Last Modified Time field as your last column in Airtable

Data from Airtable can only sync if your table includes a Last Modified Time field, not to be confused with Last Modified By. You can change the name or not, but this field won’t be mapped by Unito. It is required, however, for your flow to function as intended.

Last Modified Time field in Airtable

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

Connect Jira 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 your apps. Now, +Choose account to specify the account you want to use.
  4. From the next drop-down menu, type in the name of the folder or table you want to connect.
  5. Repeat steps 3 and 4 to connect your other tool with Unito.
  6. Click Confirm.
A screenshot showing a user in Unito connecting Jira and Airtable

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

Pick a direction for new Jira tasks or Airtable records

Flow direction determines how new work items (e.g., tasks or records) are created by Unito. That means you can decide whether to new Jira tasks should create Airtable records, vice versa, or both simultaneously.

Screenshot of Unito's flow direction screen between Airtable and Jira to set up a 2-way integration

Select Confirm when you’ve chosen a flow direction.

Set rules to filter data between Jira and Airtable

Your rules determine which records or tasks sync with Unito. If you chose a two-way flow, you’ll have to set rules for both directions. In our demo, we only have one set of rules since we’re sending data from Airtable to Jira.

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

A screenshot of rules in Unito to sync Airtable records to Jira as tasks if those records have the status: Approved, Published, Revisions Needed, or Send for Review.
In this case we’ve chosen to sync Airtable records with the status: Approved, published, revisions needed, or send for review. Those records will then automatically generate synced tasks in Jira. But if their status changes to one not listed above, Unito will no longer keep them in sync.

The easiest way to set a trigger from Airtable is through a single-select field. In our demo, we’ve told Unito to only create new Jira tasks based on the above statuses. We’ve also removed the creation date filter to sync all historical work items.

You can learn more about setting up rules here.

Choose which fields to sync between Airtable and Jira

Unito turns the details of your Jira tasks 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 Jira they can be any task or issue detail: assignee, summary, attachment, description, etc. Even your custom fields can sync with Unito!

First, you’ll be asked whether you want to set up your field mappings from scratch or let Unito do this automatically. Since your fields in Airtable are all custom fields based on your own tagging structure, you’ll have to start from scratch.

Most fields will automatically be mapped for two-way updates, but you can modify them 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.

Screenshot of field mappings between Airtable and Jira

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.

In the above example we’ve told Unito that our “Send for review” status in Airtable equals the “ToReview” label in Jira, “Revisions Needed” equals “Revisions-Requested” and so forth. This way, if we change the status or label in one tool, we’ll see that change reflected in the other.

Click Confirm to proceed.

Find out more about setting field mappings.

Save, close, and launch your flow!

And that’s it! You’ve just build a flow between Airtable and Jira. Congratulations! If you haven’t removed the creation date filter from your rules, you can test your flow with a new task or record to make sure you’ve created the 2-way Jira Airtable integration you expected. Otherwise go ahead and tell Unito to sync all historical work items.

By selecting “include older tasks or records” you’ll be able to sync previously created tasks or records.

If you followed the steps above, your flow will now automatically create new Jira tasks based on specific Airtable records, and keep our chosen fields up to date in both tools.

If you have any questions, please don’t hesitate to reach out and let us know.

What’s next after setting up a two-way integration between Jira 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.