Jira Ticket Creation from Google Forms with Sheet Updates and Email Notifications

This n8n workflow automates the process of creating Jira tickets from new Google Form submissions, updating the Google Sheet with the Jira ticket ID, and sending an email notification to the submitter.

What it does

This workflow streamlines the process of managing incoming requests or issues submitted via Google Forms by:

1. Detecting New Form Submissions: It listens for new rows added to a specified Google Sheet, typically linked to a Google Form.
2. Creating a Jira Ticket: For each new submission, it creates a new issue (ticket) in Jira Software, populating fields with data from the form.
3. Updating Google Sheet: After the Jira ticket is created, the workflow updates the original Google Sheet with the newly generated Jira ticket ID, associating the form submission with its corresponding ticket.
4. Sending Email Notification: Finally, it sends an email notification to the person who submitted the form, confirming the ticket creation and providing the Jira ticket link.

Prerequisites/Requirements

To use this workflow, you will need:

• n8n Instance: A running n8n instance.
• Google Account: A Google account with access to Google Sheets and Gmail.
  • Google Sheets Credential: Configured in n8n for accessing your Google Sheet.
  • Gmail Credential: Configured in n8n for sending email notifications.
• Jira Software Account: An Atlassian Jira Software account.
  • Jira Software Credential: Configured in n8n for creating tickets.
• Google Form: A Google Form configured to record responses in a Google Sheet.

Setup/Usage

1. Import the Workflow: Download the provided JSON and import it into your n8n instance.
2. Configure Credentials:
   • Set up your Google Sheets Trigger node with your Google Sheets credential, pointing it to the specific Google Sheet and worksheet where your Google Form responses are collected.
   • Configure the Google Sheets node with the same Google Sheets credential.
   • Configure the Jira Software node with your Jira Software credential.
   • Configure the Gmail node with your Gmail credential.
3. Customize Nodes:
   • Google Sheets Trigger: Ensure it's configured to trigger on new rows in your desired spreadsheet.
   • Code Node: This node is likely used for data transformation or formatting before sending data to Jira or Gmail. Review and adjust the JavaScript code as needed to map your Google Form fields to Jira ticket properties (e.g., summary, description, issue type, project) and email content.
   • Jira Software Node: Configure the "Create" operation to map the relevant data from your Google Form submission (via the Code node's output) to the Jira issue fields (e.g., Project Key, Issue Type, Summary, Description).
   • Google Sheets Node (Update): Configure this node to update the row in your Google Sheet where the form response originated. You'll typically use the row_index from the trigger and add a new column for the Jira ticket ID, using the output from the Jira Software node.
   • Gmail Node: Configure the "Send Email" operation. Use expressions to dynamically set the recipient (e.g., {{$json.email}} from your form data), subject, and body of the email, including the Jira ticket link (e.g., {{$json.jiraTicketUrl}}).
4. Activate the Workflow: Once all nodes are configured, activate the workflow. It will now automatically process new Google Form submissions.