Sync JIRA data to Sourcetable
JIRA
Sync JIRA data to Sourcetable
All your business data, synced in a spreadsheet.
Find out how to make the most of your JIRA data with Sourcetable
Sourcetable Benefits
Query cross-channel data quickly & easily
Developers, project managers and designers use JIRA to communicate and collaborate more efficiently with each other on ongoing projects. By syncing JIRA findings to Sourcetable, users can combine findings from these projects with inputs from other key platforms and databases easily and at a glance, without the need for additional coding.
Automation
Sourcetable compiles key findings from JIRA and other platforms quickly and intuitively, automating processes in an easy-to-use spreadsheet, and freeing up time to focus on other important aspects of your business.
Accessibility
Compile key inputs and data from JIRA and multiple other databases and platforms in Sourcetable, without the need for additional coding - making it accessible to everyone on your team, all in one place.
How to get the most of JIRA with Sourcetable
Smart Templates
Use out of the box tried and tested templates in order to cross-reference JIRA findings and data, and improve collaboration across your entire organisation
Quick Analysis
Analyse your JIRA data quickly and easily in intuitive cross-channel reports
Ease Of use
Compile all your JIRA data into a single spreadsheet, identifying key insights behind the numbers in order to confidently assess and improve your collaborations and projects.
Who uses JIRA data in Sourcetable
🎨 Designers
👨💻 Developers
🚀 Founders
👩🏼💼 Product Managers
Here's a sample of JIRA data that will be available in your Sourcetable spreadsheets:
BOARD
A board is place where you can see all the issues which are created
COMMENT
You can add a comment on any issue to give additional information
COMPONENT
A component has project information, a name and a description
EPIC
You can create an EPIC in case you wish to group some issues under a common task
FIELD
A field has a name, it can be of array type or a custom field type
FIELD_OPTION
It has name and a parent id which holds id of field option
ISSUE
An issue is a task which needs to be worked upon and has description associated with it which tells what needs to be accomplished
ISSUE_BOARD
It has associations of issue id and board id
ISSUE_FIELD_HISTORY
It has associations of issue id field id and has fields like time and value
ISSUE_LINK
It has associations of issue id, related issue id and relationship field
ISSUE_MULTISELECT_HISTORY
Contains field id, issue id, time and value
ISSUE_TYPE
It tells the type of the issue whether it is a bug, an improvement or something else
ORGANIZATION
The company that has JIRA account subscription
PERMISSION
A permission is an access right
PERMISSION_HOLDER
Assocaition table that stores permisssion information, permission scheme, user, project role, user custom field
PERMISSION_SCHEME
Contains id, name and description fields
PRIORITY
It defines the priority of the issues
PROJECT
It has fields like project category, permission schedule, user, key, name, and description
PROJECT_BOARD
It has association of project id and board id
PROJECT_CATEGORY
It has name and description
PROJECT_ROLE
It has name and description
PROJECT_ROLE_ACTOR
It has project id, project role id, user group and user
RESOLUTION
Contains name and description
SLA
Contains the Service Level Agreement information
SPRINT
A sprint is a duration in which developers complete some issues, normally used in the Agile methodolgy
STATUS
Contains status category id, name and description
STATUS_CATEGORY
Contains name and id
USER
The user which is using the JIRA software and has fields like name, email, locale, username and timezone
USER_GROUP
Contains associations of user and has a group name
VERSION
Contains project id, arcived, description, name, overdue, released, release date and start date
WORKLOG
Contains the time information which was spent on an issue
Sample companies
Online businesses integrating JIRA with Sourcetable have access to all relevant data on collaborations, issues and ongoing projects.
-
Software as a Service
(SaaS) companies -
Retail online stores
(eCommerce) -
B2B Platforms
-
B2C Marketplaces
Popular Use Reports & Use Cases
Create reports using JIRA data
JIRA + Sourcetable
Get an active list of JIRA commit history
JIRA + Sourcetable
Get a combined list of JIRA issues and Asana Tasks
JIRA + Asana
Get a combined list JIRA issues and tickets
JIRA + Sourcetable
Create a burn chart of active JIRA issues
JIRA + Sourcetable
What makes Sourcetable special?
Interconnectivity
Connect, compile and query your JIRA project management data together with findings from 30+ other sources, to inform decisions and enhance collaboration
Collaboration
Create views and workflow templates based on data from JIRA and other platforms, and share among team members, no SQL knowledge required
Automation
Automate your JIRA data, freeing up time to focus on ongoing projects and business ventures