How to connect Google Forms to JIRA

Your survey in Google Forms is ready, but what about your data? Google Forms is a great, simple, free tool. But there’s no workflow engine behind it. So how can you make the most of the data that you capture? Outputting your data into JIRA is a good way to make it more usable.

To pipe your data into JIRA, you need to use a third-party tool like Zapier. It will help you to build a workflow and automate tasks. If you are outputting less than 100 submissions, you can take advantage of Zapier’s free plan. Setting up Zapier is easy and allows you to map your survey or questionnaire responses to individual fields in JIRA.

Limitations

Google Forms is a wonderful tool, but there are limitations that you need to keep in mind. These are just a few:

  • Management of multiple forms — Most business processes require multiple forms. Think of the onboarding process in an organization — there are a myriad of forms from HR. There is no easy way to associate two form responses together. Each submission through Google Forms requires the creation of a new issue. You will be left handling the responses manually or copying or pasting information.
  • Complexity in collecting information into specific fields — If you don’t want everything to end up in the description field, you will need to create multiple custom fields, configure the create screen, and adjust screen schemas. This is not an optimal approach for someone without a solid technical understanding and it techies who know understand how to do it may warn against creating too many custom fields.
  • Data Management — Another limitation to consider is managing the multiple copies of data. You will have data in Google Forms, Google Sheets, in the Zapier history and JIRA. You will need to have good data hygiene processes to ensure that the information is secure. There are rules and regulations in managing personal data so check your privacy policy to ensure that you are up to date.

Despite the limitations you may encounter, pairing Google Forms with JIRA’s robust workflow engine will give you a solid system for collecting and handling data. Incorporating forms within JIRA means the following:

  • The capability to use forms to create issues capturing relevant information
  • The ability for anyone in your organization to use it
  • Storing data in a centralized location

How to Pipe Data From Google Forms to JIRA

For the purpose of this article, we assume you have access to the following:

  • A Google account, with access to Google Drive, Sheets and Forms
  • A Zapier account with the Basic plan
  • A JIRA user account with full admin privileges

Create Google Form

How to Pipe Data From Google Forms to JIRA

For the purpose of this article, we assume you have access to the following:

  • A Google account, with access to Google Drive, Sheets and Forms
  • A Zapier account with the Basic plan
  • A JIRA user account with full admin privileges

Create Google Form

  1. Go to docs.google.com/forms.
  2. In the Template Gallery, select Blank + to create a new form.

Collect Data From a Spreadsheet Using Google Sheets

To collect the information from a form using spreadsheets in Google Sheets.

1. Click the Response tab, and then the green box.

2. Select Create a new spreadsheet, and then click Create.

3. Fill in the form by selecting your Feedback Type and entering your answer in the appropriate fields.

4. Click Submit.

5. In the spreadsheet, your answer will be listed and the filename will have the word Responses in the title.

How to Set Up Zapier

To set up Zapier, you need to use at a minimum, their free plan.

To set the Trigger

1. Log into Zapier.

2. Click Make a Zap! to create a new Zap.

3. Select Google Sheets as your Trigger app. This is the app that will start the Zap.

4. Select New Spreadsheet Row.

5. Click Save + Continue.

6. Select the Connect a New Account and log in.

7. Click Continue.

8. Click Save + Continue.

9. Click Fetch & Continue to test your Google Sheet.

10. Click the Spreadsheet dropdown and select the spreadsheet.

11. Select the Worksheet, and then click Continue.

12. Click Re-test Google Sheets to get another spreadsheet row.

13. Click Continue.

To set the action in Zapier

The action in Zapier will tell the app what to do. This is the app that the action will be applied to.

1. Click JIRA.

2. Select Create an issue.

3. Click Save + Continue.

Tip: To use JIRA, you need access to a relevant project and permissions to create issues. Your Admin can add you using Project Settings > Users and roles.

4. Click Connect a New Account.

Tip: Ensure you add the https:// at the start AND a trailing / at the end, otherwise you will get an error. You need to enter the full URL.

5. Click Save + Continue.

6. To set up the JIRA Issue, select Project. This is where you tell Zap what you want to do with the data from the Trigger app. When you click the dropdown, it tells Zap where to pull the data from the Trigger step.

7. Click the Issue Type dropdown, and then select Support.

8. Click Continue.

9. Click the + for a dropdown list of items that you can use to populate the field. If a field is missing, it needs to be in the Create Scheme — JIRA Screen Scheme. If you enter a value, makes sure it is a value that you want created in every Zap.

Tip: Include most of the fields in the description.

10. Click Re-test JIRA to get another issue. Testing the Trigger allows you to see what values will be used in the fields.

11. Click the OFF button to turn on your Zap.

That’s it!

Or the alternative…

If that seemed like a lot to go through, it’s because it is. Combining the data capture power of a form with JIRA’s workflow engine is a great way to stuff done, but the process of adding a Google form to an issue is a bit cumbersome to say the least. Instead, consider the ProForma JIRA add-on. ProForma lets you easily attach forms to JIRA issues or JSD request types. You can create your own forms or modify an existing template. You can create issues from forms whenever needed. All the data you need gets captured in one place and stays attached to the JIRA issue. No data leakage. No complicated third party integration. That’s ProForma.


Originally published at www.thinktilt.com.

Show your support

Clapping shows how much you appreciated Jenny Choban’s story.