Refresh a Canva dashboard when a KPI changes
Let a monitored metric change prompt an autofill of your Canva dashboard template.
Trigger
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.
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
Dashboard numbers can drift from the latest spreadsheet calculation when refreshes depend on memory.
- React when a monitored SUM, COUNT, AVG, MIN, or MAX result changes
- Reduce manual transfer of the available metric result
- Keep dashboard refreshes tied to a defined spreadsheet calculation
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 the changed aggregate result to autofill your Canva dashboard template.
- 4Pick the Google Sheets Aggregate Metric Changed trigger and choose where run reports go.
- 5Test with one real metric change.
Questions about this workflow
Will it create a historical chart?
The trigger provides a changed aggregate result. Historical values or a baseline must be supplied in the sheet or another available source.
Is the Canva autofill action available to all users?
Canva's design autofill API requires Enterprise membership and a compatible template.
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.