Update testimonial creative from sheet changes
When testimonial details change in your sheet, send the current row content into its Canva template.
Trigger
Spreadsheet Row Changed
Triggers when a looked-up spreadsheet row changes. This trigger monitors a specific row (located by searching for a query value within a user-specified range) and fires when the row's values change, when the row appears, or when the row disappears.
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
A revised quote or attribution can leave a testimonial design showing stale details.
- React to changes in a specific testimonial record
- Reduce the chance of outdated quote details in creative
- Keep the sheet as the source for the latest available row content
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 updated testimonial row to autofill the chosen Canva testimonial template.
- 4Pick the Google Sheets Spreadsheet Row Changed trigger and choose where run reports go.
- 5Test with one real testimonial row.
Questions about this workflow
Can this find the testimonial row for me?
The trigger monitors a row located by searching for a query value in a user-specified range. Set up that trigger in Notis with the record you want monitored.
Does Canva autofill work for every account?
Canva's autofill API requires Enterprise membership and a suitable brand 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.