Jira Ticket Creation from Google Forms - n8n Workflow

Project Managers needing automated issue intake.
QA Teams tracking bugs submitted via forms.
Developers looking for reliable n8n templates to streamline administrative tasks.
Anyone seeking a no-code solution to synchronize Google Forms and Jira Cloud.

Manual transcription of issue reports from forms into a project management system is slow and prone to error. This sophisticated n8n workflow eliminates that need entirely. Designed for maximum efficiency, this n8n automation template leverages the Google Sheets n8n trigger to monitor new submissions in real-time. It handles crucial data normalization—such as converting human-readable priority levels (High, Medium) into the required Jira ID schema (1, 2, 3)—before creating the issue. By integrating Google Sheets, Jira, and Gmail, this single n8n node sequence ensures traceability, instant ticket creation, and immediate stakeholder notification, drastically improving response times for any project or support organization.

The automation begins with the Google Sheets n8n trigger, configured to fire whenever a new row, representing a fresh form submission, is added to the specified spreadsheet. Once triggered, the data passes to the Code n8n node, which performs essential cleanup, normalization, and data mapping, particularly ensuring that priority levels are correctly converted for Jira's API. Next, the Jira n8n node executes the core action, creating a new issue using the pre-formatted summary and description. Following successful ticket creation, the Google Sheets n8n node updates the originating row with the newly created Jira key and URL, maintaining a bidirectional link. Finally, the Gmail n8n node sends a rich HTML notification email to relevant personnel, confirming the ticket reference, priority, and link. This entire n8n workflow provides robust, end-to-end automation for issue intake.

To deploy this n8n workflow, follow these steps:

1. Import: Copy the JSON data and paste it directly into your n8n canvas via the 'New' menu > 'Import from JSON'.


2. Google Sheets Setup (n8n trigger): Click the 'Trigger when row added' n8n trigger node. Select or create a Google Sheets credential. Configure the node by pointing it to the specific Google Sheet document URL and the sheet name linked to your Google Form.


3. Jira Setup: Update the 'Cretate Jira Ticket' n8n node. Select or create your Jira Software Cloud credential (requires API email and token). Configure the specific Project ID and Issue Type you wish to use.


4. Google Sheets Setup (Update): Configure the 'Update the Google sheet...' n8n node with the same Sheet details. Ensure you define the mapping parameters to update the correct row using a unique identifier (like the timestamp or row index) and provide the Jira key and URL back to the sheet.


5. Gmail Setup: Configure the 'Notification email' n8n node with a Gmail credential and specify the recipient addresses for the notification.


6. Activate: Save the n8n workflow and toggle it to 'Active' to start monitoring new submissions.

Trigger when row added (Google Sheets Trigger): This n8n trigger is the starting point, listening for new row additions in the specified Google Sheet (the form response sheet). It ensures the n8n workflow runs instantly upon submission.
Normalize fields (Code n8n node): This crucial custom n8n node handles data transformation. It maps common priority strings (e.g., 'Highest', 'Low') into the required numeric Jira Priority IDs (1 through 5). It also standardizes the email, context, and creates a detailed description field for Jira.
Cretate Jira Ticket (Jira n8n node): Creates the actual Jira issue. Key configurations include setting the Project ID, Issue Type (e.g., Story), Summary (using the normalized context), and Priority (using the mapped numeric ID).
Update the Google sheet with tickets information (Google Sheets n8n node): Performs an update operation on the original sheet row. Its function is to append the newly generated Jira Ticket Key and URL back into the spreadsheet for traceability.

• Notification email (Gmail n8n node): Sends a confirmation email. The message body dynamically includes details about the new Jira ticket, pulling the reference key, URL, and priority from the previous n8n nodes.