Refresh sales report creative from query results
Tie your Canva report template to changes in the spreadsheet query you already rely on.
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
Initiate canva design autofill job
Upcoming brand template id updates require migration within 6 months. canva enterprise users can auto-fill designs using various data types, including experimental chart data. monitor jobs with specific api.
Why this helps
Recurring report preparation can mean finding the right rows and manually moving them into a design.
- React to added, removed, or updated query rows
- Use the saved query output as report input
- Reduce repeated searching and pasting before a report refresh
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Canva once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis in one instruction to use changed query results to autofill your Canva sales report template.
- 4Pick the Google Sheets Table Query Result Changed trigger and choose where run reports go.
- 5Test with one real query result change.
Questions about this workflow
Does this run a query for me?
The trigger watches a saved table query result in Google Sheets and fires when its result set changes.
Can it show trends over time?
Only if historical data or a baseline is available to Notis in the sheet or another source.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Canva. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Canva actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Access user specific brand templates list
This year, brand template ids will change; integrations storing them must update within 6 months. also, api use requires canva enterprise membership.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create canva design with optional asset
Create a new canva design using a preset or custom dimensions, and add an asset with `asset id` from a user's project using relevant apis.
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.
Create comment reply in design
This preview api allows replying to comments within a design on canva, with a limit of 100 replies per comment. users should note potential unannounced changes, and that preview apis are not eligible for public integrations.
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.
Create design comment in preview api
This api is in preview and may change without notice; integrations using it won't pass review. it allows creating comments on a design, with a limit of 1000 comments per design.
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.
Create user or sub folder
This api creates a folder in a canva user's projects at the top level or within another folder, returning the new folder's id and additional details upon success.
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.
Delete asset by id
You can delete an asset by specifying its `assetid`. this operation mirrors the behavior in the canva ui. deleting an item moves it to the trash. deleting an asset doesn't remove it from designs that already use it.
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.
Exchange oauth 2 0 access or refresh token
The oauth 2.0 endpoint issues time-limited (4-hour) access tokens of up to 4kb for user authorization via codes or refresh tokens. it requires client id/secret for authentication.
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.
Fetch asset upload job status
Summarize asset upload outcome by repeatedly calling the endpoint until a 'success' or 'failed' status is received after using the create asset upload job api.
Connect any two apps with Notis in the middle.
Google Sheets and Canva, 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 Canva.