Skip to content
Notis

Create a decision brief when table query results change

Let changes in a saved table query prompt a concise decision brief, so you can review what shifted without scanning the whole sheet.

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

Generate documents from template

Tool to generate document(s) from a template by merging JSON data or uploading a data file. Use when you need to programmatically produce one or more documents and receive metadata including a download URL.

Why this helps

Reviewing evolving query results row by row makes it harder to spot what needs a decision and what can wait.

  • React to rows added, removed, or updated in query results.
  • Create a document that highlights the decision or follow-up described in your instruction.
  • Keep changed data and its review artifact connected.

Setup

Build it in a few focused steps.

  • 1Connect Google Sheets and Docugenerate once in the Notis portal.
  • 2Create an automation in Automations, New Automation, and give it a clear name.
  • 3In one instruction, tell Notis what decision brief to generate from changed query results and what context to include.
  • 4Pick Table Query Result Changed as the trigger and choose where run reports should go.
  • 5Test with one real query result change and review the brief.

Questions about this workflow

What changes can trigger this workflow?

The trigger detects rows added, removed, or updated in the result set of a saved table query.

Does the query trigger explain what decision to make?

It supplies changed query results. Your instruction should explain how to interpret them and what context is needed.

Can it update an existing brief?

This workflow generates a document from a template. Updating existing documents is a separate action.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Google Sheets to Docugenerate. A trigger fires from one place; an action lands in another.

Google Sheets triggers

Docugenerate actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

Generate documents from template

Tool to generate document(s) from a template by merging JSON data or uploading a data file. Use when you need to programmatically produce one or more documents and receive metadata including a download URL.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Generate documents as ZIP

Tool to bulk generate multiple documents into a ZIP archive. Use when you need a batch of docs packaged as ZIP.

ActionInstant

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.

TriggerPolling

Generate document with attachments

Tool to generate a PDF with embedded attachments. Use when you need to bundle extra files into the PDF output.

ActionInstant

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.

TriggerPolling

Generate document with merge

Tool to generate a PDF and append additional PDF files. Use when you need to merge extra pages into a generated document.

ActionInstant

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.

TriggerPolling

Update Document

Tool to update a document's metadata. Use when renaming an existing document after confirming the document ID.

ActionInstant

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.

TriggerPolling

Get or list templates

Tool to retrieve or list existing templates. Use when needing template IDs and metadata before making updates or generating documents.

ActionInstant

Developer Metadata Changed

Triggers when developer metadata entries change (new/updated/removed) in a Google Spreadsheet. Uses snapshot-based diffing to detect changes between polls.

TriggerPolling

Update Template

Tool to update a template’s file and settings. Use after confirming the template ID and desired inputs.

ActionInstant

Filtered Range Values Changed

Polling trigger that monitors Google Sheets filtered ranges for value changes. Uses snapshot-based diffing to detect when values matching a data filter change. Emits the matched values when changes are detected.

TriggerPolling

Connect any two apps with Notis in the middle.

Google Sheets and Docugenerate, 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 Docugenerate.