{"id":52659,"date":"2025-03-12T14:00:00","date_gmt":"2025-03-12T13:00:00","guid":{"rendered":"https:\/\/blog.sheetgo.com\/?p=52659"},"modified":"2025-06-03T22:02:36","modified_gmt":"2025-06-03T20:02:36","slug":"extraccion-de-datos-de-jira-con-google-apps-script","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/es\/blog\/google-sheets-features\/data-extraction-from-jira-with-google-apps-script\/","title":{"rendered":"Automatizaci\u00f3n de la extracci\u00f3n de datos de JIRA con Google Apps Script"},"content":{"rendered":"\n[et_pb_section fb_built=”1″ theme_builder_area=”post_content” _builder_version=”4.27.2″ _module_preset=”default”][et_pb_row _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content”][et_pb_column _builder_version=”4.27.2″ _module_preset=”default” type=”4_4″ theme_builder_area=”post_content”][et_pb_text _builder_version=”4.27.2″ _module_preset=”default” theme_builder_area=”post_content” hover_enabled=”0″ sticky_enabled=”0″]
\n

Note:<\/strong> This post was originally published in our community forum.<\/p>\n<\/blockquote>\n

Leveraging Google Apps Script to pull data from JIRA into Google Sheets is a powerful technique for teams looking to automate their workflow and enhance project management. This integration simplifies tracking issues, tasks, and progress directly within a familiar spreadsheet environment.<\/p>\n

Quick setup guide<\/h2>\n

1. Create a Google Sheet as your data repository.<\/p>\n

2. Open Script Editor from Google Sheets to write custom functions.<\/p>\n

3. Utilize JIRA\u2019s API within your script to fetch data such as issue details, statuses, and updates.<\/p>\n

4. Write a Script in Apps Script to parse and insert the JIRA data into the Google Sheet.<\/p>\n

5. Set Triggers for automatic updates, ensuring your data remains fresh without manual intervention.<\/p>\n

Benefits at a glance<\/strong><\/h2>\n
    \n
  • Streamlined Project Tracking: Centralize your JIRA data in Google Sheets, making it easier to monitor project timelines, task assignments, and statuses.<\/li>\n<\/ul>\n
      \n
    • Improved Data Analysis: With data in Sheets, leverage built-in tools for deeper insights and reporting, identifying bottlenecks or areas for improvement.<\/li>\n<\/ul>\n
        \n
      • Enhanced Team Collaboration: Share your data-rich Google Sheets with team members, fostering a collaborative environment where information is transparent and accessible.<\/li>\n<\/ul>\n

        This approach not only saves time but also bridges the gap between complex project management data and actionable insights, leading to more informed decision-making and streamlined operations.<\/p>\n

        Here a code sample for google app script<\/p>\n

        \n

        Note:<\/strong> Please replace\u00a0<\/span>yourDomain<\/code><\/strong>,\u00a0<\/span>yourEmail<\/code><\/strong>,\u00a0<\/span>yourApiToken<\/code><\/strong>, and\u00a0<\/span>yourProjectKey<\/code><\/strong>\u00a0<\/span>with your actual JIRA domain, email, API token, and project key. API tokens can be generated from your Atlassian account security settings.<\/p>\n<\/blockquote>\n

        function<\/span> fetchJiraIssues<\/span>(<\/span>) {\n\n  var<\/span> sheet = SpreadsheetApp<\/span>.getActiveSpreadsheet<\/span>().getSheetByName<\/span>(\"Sheet1\"<\/span>);\n\n  var<\/span> url = 'https:\/\/yourDomain.atlassian.net\/rest\/api\/3\/search?jql=project=yourProjectKey'<\/span>;\n\n  \n\n  var<\/span> options = {\n\n    'method'<\/span> : 'get'<\/span>,\n\n    'contentType'<\/span>: 'application\/json'<\/span>,\n\n    \/\/ Replace yourEmail and yourApiToken with your actual email and API token<\/span>\n\n    'headers'<\/span>: {\n\n        'Authorization'<\/span>: 'Basic '<\/span> + Utilities<\/span>.base64Encode<\/span>('yourEmail:yourApiToken'<\/span>)\n\n    },\n\n    'muteHttpExceptions'<\/span>: true<\/span>\n\n  };\n\n  \n\n  var<\/span> response = UrlFetchApp<\/span>.fetch<\/span>(url, options);\n\n  var<\/span> jsonResponse = JSON<\/span>.parse<\/span>(response.getContentText<\/span>());\n\n  \n\n  \/\/ Clear existing content<\/span>\n\n  sheet.clearContents<\/span>();\n\n  \n\n  \/\/ Set headers<\/span>\n\n  sheet.appendRow<\/span>([\"Issue Key\"<\/span>, \"Summary\"<\/span>]);\n\n  \n\n  \/\/ Loop through each issue and append data to the sheet<\/span>\n\n  jsonResponse.issues<\/span>.forEach<\/span>(function<\/span>(issue<\/span>) {\n\n    sheet.appendRow<\/span>([issue.key<\/span>, issue.fields<\/span>.summary<\/span>]);\n\n  });\n\n}<\/code><\/pre>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]\n","protected":false},"excerpt":{"rendered":"
        Note: This post was originally published in our community forum. Leveraging Google Apps Script to pull data from JIRA into Google Sheets is a powerful technique for teams looking to automate their workflow and enhance project management. This integration simplifies tracking issues, tasks, and progress directly within a familiar spreadsheet environment. Quick setup guide 1. […]<\/p>\n","protected":false},"author":49,"featured_media":44470,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[37],"tags":[],"class_list":["post-52659","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-features"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/52659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/49"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=52659"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/52659\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/44470"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=52659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=52659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=52659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}