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:
Watch this Jira Airtable integration in action:
This Jira-Airtable integration has two goals:
- Create new tasks in Jira based on records in Airtable with specific statuses.
- 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.
Set up an application link in Jira
- Log in to Jira through Atlassian.com.
- Click Settings, then select Products.
- 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—–
—–END PUBLIC KEY—–
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.
Now you’re ready to build a flow in Unito!
Connect Jira and Airtable to Unito
- Log in to the Unito App and click +Create Flow.
- Then, click Start Here to connect your tools.
- 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.
- From the next drop-down menu, type in the name of the folder or table you want to connect.
- Repeat steps 3 and 4 to connect your other tool with Unito.
- Click Confirm.
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.
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.
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.
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.
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.
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.
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:
- Plan a project health report
- Organize a marketing budget
- Create a content catalog
- Create an employee resource database
- Report on resource management
- Browse more Airtable templates
If you want to know what else you can do with Unito, here’s some inspiration to help you power up your workflows.
- Duplicate this flow to sync other Jira projects to Airtable.
- Browse our collection of Airtable and Jira integration resources for other use cases.