Administration and setup of the Smartsheet Jira Connector

This article explains how to set up the Smartsheet Jira Connector with both Jira Cloud and Jira Self-hosted Server.

Who can use this?

Plans:

  • Business
  • Advanced Work Management

The Smartsheet Jira Connector is a premium add-on. Contact the Smartsheet sales team for pricing.

The Smartsheet Jira Connector syncs data between Smartsheet and one or more Jira instances. Use it to create workflows that link Jira issues to rows, columns, and cells in Smartsheet.

If the Jira Connector is already on your plan, sign in to the Smartsheet Jira Connector to get started.

Sign in to the Smartsheet Jira Connector

Terminology and permission types

Two terms define how the Jira Connector is structured:

  • Connection: The link between Smartsheet and a specific Jira instance.
  • Workflow: The link within the Jira Connector that connects Jira elements to a Smartsheet sheet.

Three permission types control access to the Jira Connector:

  • Smartsheet System Admin: Manages Jira Connector Admins and Jira Connector Users from within Smartsheet. System Admins can also enable a setting to restrict Connector access.
  • Jira Connector Admin: Establishes the connection between a Jira instance and the Smartsheet Jira Connector.
  • Jira Connector User: Creates workflows to sync information between Smartsheet and Jira.

Features by permission type

The following table shows which permissions are required to complete specific tasks using the Jira Connector.

 Smartsheet System AdminJira Connector AdminJira Connector User
Create connectionYesYesNo
Create workflowsYes*Yes*Yes
Edit own workflowsYes*Yes*Yes
Deactivate own workflowsNoNoYes
See all workflows in the organizationYesYesNo
Deactivate any workflow in the organizationYesYesNo
Enable or run any workflow in the organizationNoNoNo
Assign Jira Connector User roleYesYesNo
Assign Jira Connector Admin roleYesNoNo
Enable Restrict Access settingYesYesNo
Add individuals to the Restrict Access list (after restrictions have been enabled)YesYesNo

* Smartsheet System Admins and Connector Admins can create and edit workflows when the restrict access feature is enabled. If your System Admin activates the Restrict Users setting in the Jira Connector, you must also hold the Jira User role in Smartsheet. See Restrict access to the Smartsheet Jira Connector.


Before you begin

Use a shared account for setup

Set up the connection using a shared, licensed email account (for example, smartsheet-jira@yourdomain.com) for both Smartsheet and Jira. Connection ownership can't be transferred. If the person who created the connection leaves your organization, you must rebuild the connection from scratch. A shared account prevents that.

Configure your firewall

Configure your firewall settings before you begin any connection setup.

Required permissions

In Jira:

  • Jira System Admin (Product Admin or Org Admin)

In Smartsheet:

  • Member (user model) or Licensed user (legacy model) 
  • Smartsheet System Admin role, Smartsheet Jira Connector Admin role, or both

Only one of the Smartsheet roles is required, but Smartsheet recommends holding both.

Because the Jira Connector runs automatic workflows, it needs Jira System Administrator credentials to create and configure webhooks via the Jira REST API. Those credentials are used only for webhook setup.

Keep the setup account active. The account used for the connection must stay active and retain Admin rights in both Jira and Smartsheet. If that user loses Admin status, the connection breaks with the error: Missing user credentials for this endpoint. Restoring Admin permissions resumes the sync. If Jira Admin credentials are removed entirely, you must rebuild the application link because the tokens change.


Set up the connection

The Smartsheet Jira Connector is compatible with Jira Cloud and Jira Data Center. The steps vary by deployment type and OAuth version. Use this table to follow the path that matches your setup:

Deployment

Auth type

Steps

Jira Cloud

OAuth 1.0

1. Register new Jira Server → 2. Create Application Link → 3. Edit the App Link → 4. Complete Connection

Jira Cloud

OAuth 2.0

1. Register new Jira Server → 2. Complete Connection

Jira Data Center

OAuth 1.0

1. Register new Jira Server → 2. Create Application Link → 3. Edit the App Link → 4. Complete Connection

Jira Data Center

OAuth 2.0

1. Create App Link → 2. Register new Jira Server → 3. Complete Connection

You can create up to three connections per Jira Cloud instance with OAuth 2.0.


Jira Cloud OAuth 1.0, OAuth 2.0 or Jira Data Center OAuth 1.0

Step 1: Register a new Jira Server in the Smartsheet Jira Connector

  1. Sign in to the Smartsheet Jira Connector. If prompted to allow access to your Smartsheet account, select Allow.
  2. Select the menu in the upper-left corner of the page and then select Account Admin.
  3. Select Register New Jira Server.
  4. On the Settings page:
    • Enter the JIRA Host URL for the Jira environment you want to connect (for example, https://mbfcorp.atlassian.net/). 
    • The JIRA API URL is typically the same as your JIRA Host
    • For Name, accept the default or enter a more descriptive name. 
    • Select your JIRA Version. For Jira Cloud instances, select Jira Server 7 or Cloud.
Brandfolder Image
Jira Connector Settings
  1. Select Continue.
  2. On the Configuration page, copy the Consumer KeyConsumer Name, and Public Key. You use these in the next steps.
  3. Select Continue.

Step 2: Create an Application Link (AppLink) to Smartsheet in Jira

Skip this step if you're using OAuth 2.0.

  1. Sign in to Jira with Jira Administrator permissions.
  2. Go to SettingsProducts.
     

    Brandfolder Image
    Jira product settings
  3. In the Products sidebar, under Integrations, select Application links.

    In earlier self-hosted versions of Jira, go to SettingsApplications, then select Application links.

    Brandfolder Image
    Jira application links
  4. Select Create link. In the dialog that appears, fill in the fields:
    • Jira Cloud: Select Direct application link and enter https://app.smartsheet.com as the Application URL. Select Next.

      Brandfolder Image
      Create a new application link
    • Jira Data Center v9 and later: Select Atlassian product and enter https://app.smartsheet.com as the Application URL. Select Continue.

      Brandfolder Image
      Jira 9 and above verions
  5. When prompted with a redirect or validation warning, select Continue and leave the URL unchanged.
  6. In the Review link or Link applications dialog that appears, fill in the fields:
    • Application Name: Smartsheet.
    • Application Type: Generic Application (accept the default).
    • Jira Data Center v9 and later only: Check Create incoming link.
    • Select Continue.

      Brandfolder Image
      Linked applications

 

Step 3: Edit the Application link

Skip this step if you're using OAuth 2.0.

  1. Find the Application Link you created in Step 2. Select the three-dot menu (hover to reveal it) or the Edit icon (version dependent). 
  2. In the Configure dialog, select Incoming Authentication.
     

    Brandfolder Image
    Configuring Smartsheet authentication
  3. Fill in the fields: 
    • Service Provider Name (if shown): Smartsheet
    • Consumer Name: Paste in the Consumer Name you copied in Step 1
    • Consumer Key: Paste in the Consumer Key you copied in Step 1
    • Public Key/Shared Secret: Paste in the Public Key you copied in Step 1
    • Description: Optional
    • If Request Token URL, Access Token URL, or Authorize URL are required in your Jira environment, enter https://api.smartsheet.com/2.0/token in each field.
  4. Select Save, then Close.

Step 4: Complete the Smartsheet Jira Connection

  1. Return to the Smartsheet Jira Connector configuration.
  2. On the Connect screen, select Connect.

    A dialog asks you to allow Smartsheet to read and write to your Jira environment. 

  3. If you're using OAuth 2.0, select the host from the Use app on dropdown. Is not, skip to step 4. 
Brandfolder Image
Complete Jira Connector set up
  1. Select Allow

The connection is now active. Members (licensed users in the legacy model) can create workflows between Jira and Smartsheet.

To connect additional Jira environments, repeat these steps for each additional instance. 


Jira Data Center OAuth 2.0

Step 1: Create an Application Link (AppLink) to Smartsheet in Jira
  1. Sign in to Jira.
  2. Go to Settings > Applications.
  3. In the Applications sidebar, under Integrations, select Application links.

    If Applications doesn't appear under Settings, go to Products instead. Look for Application links under Integrations in the Products sidebar.

  4. Select Create link. In the dialog that appears, fill in the fields:
    • Application Type: External Application
    • Direction: Incoming
    • Select Continue
Brandfolder Image
Jira 9 and above verions
  1. Configure the incoming link:
  2. Select Save.

When the step completes, Jira displays a Client ID and Client Secret. Copy both values, as you need them in Step 2.

Step 2: Register a new Jira Server in the Smartsheet Jira Connector

  1. Sign in to the Smartsheet Jira Connector. If prompted to allow access to your Smartsheet account, select Allow.
  2. Select the menu in the upper-left corner of the page and then select Account Admin.
  3. Select Register New Jira Server.
  4. On the Settings page:
    • Enter the JIRA Host URL for the environment you want to connect (for example, https://mbfcorp.atlassian.net/).
    • The JIRA API URL is typically the same as your JIRA Host.
    • For Name, accept the default or enter a more descriptive name.
    • Select your JIRA Version.
  5. Select Continue.
  6. On the Configuration page, enter the Client ID and Client Secret you copied in Step 1.

Step 3: Complete the Smartsheet Jira Connection

  1. Select Continue.
  2. On the Connect screen, select Connect.

    A dialog asks you to allow Smartsheet to read and write to your Jira environment.

  3. Select Allow.

The connection is now active. Members (licensed users in the legacy model) can create workflows between Jira and Smartsheet.


Restrict access to the Smartsheet Jira Connector

Permissions in both Smartsheet and Jira always control what a user can do in the Connector, regardless of whether additional restrictions are enabled. For example, if the person who created a workflow doesn't have permission to edit specific project data in Jira, the workflow can't edit that data through the Connector.

To limit which users can build workflows, the Smartsheet System Admin or Jira Connector Admin can turn on the Restrict Access setting.

Turn on Restrict Access

  1. Sign in to the Smartsheet Jira Connector with your Smartsheet credentials.
  2. Select the menu icon in the upper-left corner and select User Management.
  3. Check Restrict which users can access the Smartsheet JIRA Integration

    Brandfolder Image
    restrict access to the Smartsheet Jira Connector
  4. Add the email address of each user who should have access.

Remove a user

Users removed from the list lose the ability to create or edit workflows.

  1. Sign in to the Smartsheet Jira Connector with your Smartsheet credentials.
  2. Go to User Management.
  3. Select the Delete icon to the right of that user's account information.