Turn changing Sheet query results into drafts
Make your recurring data signals visible in the newsletter workflow.
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
Create Draft Issue
Tool to create a draft issue for a publication. use after confirming the publication id. applies default settings if optional fields are omitted.
Why this helps
Important changes in a recurring report require manual checking and summarizing.
- Surface meaningful data changes
- Reduce recurring report review
- Create a consistent narrative starting point
Setup
Build it in a few focused steps.
- 1Connect Google Super and Curated in Notis.
- 2Create an automation named Query change to Curated draft.
- 3Tell Notis to summarize added, removed, or updated results and create a draft issue when the change is meaningful.
- 4Pick Table Query Result Changed as the trigger and choose a report channel.
- 5Test with one controlled query change.
Questions about this workflow
Can it ignore small changes?
Tell Notis what counts as meaningful based on the returned result data.
Does the trigger include the changed rows?
It detects changes in the saved query result set, and Notis can summarize the returned data.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Super to Curated. A trigger fires from one place; an action lands in another.
Google Super triggers
Curated actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Draft Issue
Tool to create a draft issue for a publication. use after confirming the publication id. applies default settings if optional fields are omitted.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Collected Link
Tool to create a collected link for a publication. use when you want to add a new link (with url, title, etc.) to a publication's collection.
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.
List Email Subscribers
Tool to list all email subscribers for a publication. use after confirming the publication 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.
List Publications
Tool to list all publications accessible by the api key. use when you need to retrieve your publication ids for further api calls. example prompt: "list my publications".
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.
List Categories
Tool to list all categories for a publication. use after you have the publication id and need to fetch its categories.
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
List Issues
Tool to list all issues for a publication. use after you have the publication id and need to fetch its issues (supports pagination).
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.
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.
Connect any two apps with Notis in the middle.
Google Super and Curated, 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 Curated.