Create Jira issues from changed spreadsheet query results
If a saved table query surfaces new exceptions or requests, Notis can turn the actionable results into Jira issues.
Trigger
Table Query Result Changed
Triggers when the result set of a saved table query changes in Google Sheets. Detects rows added, removed, or updated in the query output. This trigger monitors the result of a SQL query against a Google Sheets table and fires when changes are detected.
Action
Bulk Create Issues
Creates multiple jira issues (up to 50 per call) with full feature support including markdown, assignee resolution, and priority handling.
Why this helps
A useful change appears in a spreadsheet query, but someone has to find it and decide whether to create a ticket.
- Create issues from rows that meet your action criteria.
- Reduce manual review of changing query output.
- Include the relevant result data in each issue.
Setup
Build it in a few focused steps.
- 1Connect Google Super and Jira once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it for query result intake.
- 3Tell Notis which query changes should become Jira issues and how to describe each qualifying result.
- 4Choose the table query result changed trigger, select a report channel, and test with one real result change.
Questions about this workflow
Does the trigger return the changed query rows?
Yes. It detects rows added, removed, or updated in the query output and emits changes when detected.
Can Notis create one issue for each changed row?
Yes. Describe the criteria for a Jira issue and have Notis create issues for each qualifying changed result.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Jira. A trigger fires from one place; an action lands in another.
Google Super triggers
Jira actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Attachment
Uploads and attaches a file to a jira issue.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Add Comment
Adds a comment using atlassian document format (adf) for rich text to an existing jira issue.
Aggregate Metric Changed
Triggers when an aggregate metric (SUM/COUNT/AVG/MIN/MAX) changes in a Google Sheets spreadsheet. This trigger monitors an aggregate calculation on a target column (optionally filtered by a search column/value) and fires when the calculated result changes.
Add Watcher to Issue
Adds a user to an issue's watcher list by account id.
Attendee Response Changed
Polling trigger that fires when any attendee's RSVP changes to accepted, declined, or tentative. Returns attendee info and current status.
Assign Issue
Assigns a jira issue to a user, default assignee, or unassigns; supports email/name lookup.
Cell Range Values Changed
Triggers when values in a specified A1 range change in Google Sheets. This trigger monitors a specific cell or range of cells and fires when any values change.
Bulk Create Issues
Creates multiple jira issues (up to 50 per call) with full feature support including markdown, assignee resolution, and priority handling.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Create Issue
Creates a new jira issue (e.g., bug, task, story) in a specified project.
Conditional Format Rule Changed
Triggers when conditional formatting rules change in a Google Spreadsheet. Detects when rules are added, updated, or removed. Uses snapshot-based diffing to detect changes between polls.
Link Issues
Links two jira issues using a specified link type with optional comment.
Data Validation Rule Changed
Triggers when data validation rules change (added/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.
Create Project
Creates a new jira project with required lead, template, and type configuration.
Connect any two apps with Notis in the middle.
Google Super and Jira, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Jira.