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

Low complexity⚡ Trigger5 nodes🏷️ Project Managementby Yassin Zehar

Overview

Description

Automated workflow that creates Jira issues directly from Google Forms. The flow validates and normalizes the data, creates the Jira issue, writes the key back to the Google Sheet, and sends a Gmail notification.

Context

This template bridges lightweight Google Forms with enterprise Jira. It enables instant ticket creation while keeping Jira the single source of truth. The flow is idempotent (no duplicates) and production-friendly, with clean field normalization and safe mappings.

Nodes used

Google SheetsJira SoftwareGmailCode

Workflow Preview

Required
• Google Form + response sheet
• Jira Cloud project (API email + API token)
• Gmail credential
1) Trigger and Normalize
Trigger: New row added to Google Sheets
Data Processing:
- Clean and normalize all fields
- summary: Single-spaced, trimmed text
- description: Preserve paragraphs (trim
2) Create Jira ticket
Action: Call Jira API to create ticket
Key Parameters:
- Project:
- Type: Story
- Priority: Mapped to Jira IDs (1-5)
3) Update the sheet and send Gmail notificati
Action: Update source row with Jira information
Updated Fields:
- jira_key: Ticket reference
- jira_url: Ticket link
- status: "Created"
⚡
T
Trigger when row added
Normalize fields
Cretate Jira Ticket
Update the Google sheet …
Notification email
5 nodes4 edges

How it Works

  1. 1

    Trigger

    The workflow starts with a trigger trigger.

  2. 2

    Process

    Data flows through 5 nodes, connecting code, gmail, googlesheets.

  3. 3

    Output

    The workflow completes its automation and delivers the result to the configured destination.

Node Details (5)

GO

Google Sheets

googleSheets

#1
JI

Jira Software

jira

#2
GM

Gmail

gmail

#3
CO

Code

code

#4

How to Import This Workflow

  1. 1Click Download JSON button on the right to save the workflow file.
  2. 2Open your n8n instance. Go to Workflows → New → Import from file.
  3. 3Select the downloaded jira-ticket-creation-from-google-forms-with-sheet-updates-and-email-notifications file and click Import.
  4. 4Set up credentials for each service node (API keys, OAuth, etc.).
  5. 5Click Test Workflow to verify everything works, then activate it.

Or paste directly in n8n → Import from JSON:

{ "name": "Jira Ticket Creation from Google Forms with Sheet Updates and Email Notifications", "nodes": [...], ...}

Integrations

codegmailgooglesheetsgooglesheetstriggerjira

Get This Workflow

Download and import in one click

Download JSONView on n8n.io
Nodes5
Complexitylow
Triggertrigger
CategoryProject Management

Created by

Yassin Zehar

Yassin Zehar

@yassinzehar

Tags

codegmailgooglesheetsgooglesheetstriggerjira
⚡

New to n8n?

n8n is a free, open-source workflow automation tool. Self-host it or use the cloud version.

Get n8n Free →