Make payment exception reviews easier to remember
Schedule a regular look at the Appdrag records your team uses to track payment exceptions, then review the returned results in Notis.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Visual SQL SELECT
Tool to execute a Visual SELECT Cloud Backend function. Use when you need to read rows from a database table using a visual SQL function configured in AppDrag.
Why this helps
Payment exceptions can accumulate quietly when review depends on remembering to open a database view.
- Build a dependable review rhythm without calendar overhead.
- See returned exception records in the run report.
- Reduce the need to remember a separate manual database check.
Setup
Build it in a few focused steps.
- 1Connect Appdrag once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3Tell Notis to run your Appdrag Visual SQL SELECT function and summarize the returned payment exception records.
- 4Choose a recurring schedule and where run reports should go.
- 5Test with one real example and confirm the query returns the rows you expect.
Questions about this workflow
Does this create or update exception records?
No. The selected Visual SQL SELECT action reads rows. Use an appropriate update or backend function for changes.
What does the schedule query?
It runs the Visual SQL SELECT function you choose. The function must already be configured to return the records you need.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Stripe to Appdrag. A trigger fires from one place; an action lands in another.
Stripe triggers
Appdrag actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute Cloud Backend function via DELETE
Tool to execute a Cloud Backend API function via DELETE on the default environment. Use when you need to call a function with DELETE parameters and optional APIKey.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Execute Preprod Function (DELETE)
Tool to execute the pre-production version of a Cloud Backend API function via DELETE. Use when you need to test or validate delete operations in the preprod environment before production deployment.
Charge Failed Trigger
Triggered when a direct charge fails in Stripe's legacy Charges API
Execute PROD API Function (GET)
Tool to execute a production Cloud Backend API function via GET. Includes robust URL handling and fallbacks to accommodate management base URLs.
Checkout Session Completed Trigger
Triggered when a checkout session is completed in Stripe
Execute Dev Function (PATCH)
Tool to execute the development version of a Cloud Backend API function via PATCH. Use after deploying or updating your function to the dev environment.
Invoice Payment Succeeded Trigger
Triggered when an invoice payment is successful in Stripe
Execute Cloud Backend function via POST
Tool to execute a Cloud Backend API function via POST on the default environment. Use when you need to call a function with POST parameters and optional APIKey.
Payment Intent Failed Trigger
Triggered when a payment intent fails in Stripe
Execute Function POST (Preprod Env)
Tool to execute a Cloud Backend API function via POST on the preprod environment. Use when you need to test a function in the preprod environment before releasing to production. Include apiKey if your function requires APIKey security.
Product Created Trigger
Triggered when a product is created in Stripe
Execute Cloud Backend function via PUT (default)
Tool to execute a Cloud Backend API function via PUT on the default environment. Use when you need to call a function with PUT parameters and optional APIKey.
Subscription Added Trigger
Triggered when a subscription is added in Stripe
Execute Cloud Backend function via PUT (preprod)
Tool to execute a Cloud Backend API function via PUT on the preprod environment. Use when you need to call a function with PUT parameters and optional APIKey in preprod.
Connect any two apps with Notis in the middle.
Stripe and Appdrag, 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 Appdrag.