Resend a published credential after a row update
When a tracked recipient record changes, send the published credential without searching through Certifier by hand.
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
Send a Credential
Tool to send a published credential via email. use after confirming the credential is published.
Why this helps
Corrected recipient details can get lost between a spreadsheet update and the credential resend that should follow.
- React to changes in a specific looked-up row.
- Send a published credential by email after the recipient record is updated.
- Cut down on manual monitoring and repeated credential searches.
Setup
Build it in a few focused steps.
- 1Connect Google Sheets and Certifier once in the Notis portal.
- 2Create an automation and describe sending the relevant published credential when the tracked row changes.
- 3Pick the Spreadsheet Row Changed trigger and choose where run reports go.
- 4Test with one real row update and confirm the matching published credential is identifiable.
Questions about this workflow
What row changes can start this workflow?
The trigger watches a specific row located by searching for a query value in a user-specified range. It fires when that row changes, appears, or disappears.
Can this action create a credential?
No. The selected action sends a credential by email and should be used after confirming the credential is published.
What if the row disappears?
The trigger can report that the looked-up row disappeared. Your instruction should specify whether that event should lead to an action; send only when the published credential and recipient are identifiable.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Sheets to Certifier. A trigger fires from one place; an action lands in another.
Google Sheets triggers
Certifier actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Send a Credential
Tool to send a published credential via email. use after confirming the credential is published.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create, issue, and send credential
Tool to create, issue, and send a credential in a single request. use when group id and recipient details are ready.
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 Credential Interactions
Tool to list credential interactions. use when you need to retrieve interaction events for a specific credential, with optional filtering and pagination.
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 Credentials
Tool to list credentials. use after authentication to retrieve paginated credentials.
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.
List Designs
Tool to list all designs. use after authentication to retrieve certificate and badge designs with pagination.
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.
List Groups
Tool to list all groups. use when you need to retrieve groups with pagination (limit and cursor).
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.
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.
Connect any two apps with Notis in the middle.
Google Sheets and Certifier, 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 Certifier.