Jira integration with Google Sheet

Jira – Zoho Analytics Integration and Create Reports

One of our clients recently wants to create some reports using his Jira’s (is a proprietary issue tracking product) data.

But unfortunately, Zoho Analytics doesn’t have direct integration with Jira. We were looking for a workaround and after some research, we found a workaround.

Zoho Analytics has integration with Google Sheet (Google Sheet is a spreadsheet program) and Jira has also integration with Google Sheet.

We integrate Jira with Google Sheet and then integrate that Google Sheet with Zoho Analytics. Yes, we got all the Jira data in Zoho Analytics!!!

Goole Sheet with Zoho Analytics Integration
Goole Sheet with Zoho Analytics Integration

We have created some reports and dashboards in analyzing Jira’s data.

Here some report name:

1. Count Of Issue Id By Assignee

Jira Count Of Issue Id By Assignee

2. Count Of Issue Id by Issue Type

Jira Count Of Issue Id by Issue Type

3. Count Of Issue Id By Project Name

Jira Count Of Issue Id By Project Name

4. Count Of Issue Id By State

Jira Count Of Issue Id By State

Dashboard

Zoho Analytics Jira dashboard

Related Posts

Zoho CRM Integration with Marcado Libre

21

Feb
Case Studies

Zoho CRM Integration With Marcado Libre

We have been developing our client’s project on ZOHO CRM for a long time. Following this workflow, we have created an integrated system using ZOHO CRM that helps our client get all the visitor or customer information who has commented on the products or services that belong to mercadolibre.com. Mercado Libre, Inc. is an Argentine company incorporated […]

Zoho CRM Integration with Trello & Slack

21

Feb
Case Studies

ZOHO CRM Integration with Trello & Slack

We have completed a project about our recent work for our clients where we have created a button in ZOHO CRM that will help clients keep update their Trello & Slack accounts. Trello is a famous project management application that is super flexible & easy to use to manage all the project-related work with your team members.[…]