Get a weekly view of email activity
Have Notis query your Prisma email event history on a schedule and report a compact summary for your review.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Execute SQL Query
Execute sql select queries against prisma databases. runs read-only queries safely through postgresql driver with automatic type mapping. perfect for data analysis, schema inspection, and reporting operations.
Why this helps
Remembering to check email logs competes with work that has a clearer deadline.
- Turn a recurring check into a scheduled summary.
- Use read-only SQL against the email event history.
- Notice volume changes without opening several dashboards.
Setup
Build it in a few focused steps.
- 1Connect Prisma and Mailtrap to Notis once through the portal; Mailtrap events should already be recorded in your database.
- 2Create an automation with a prompt to query the recent email event records and summarize weekly volume.
- 3Select a weekly recurring schedule as the trigger.
- 4Choose where Notis should report runs and test the query against an existing week of records.
Questions about this workflow
Does the workflow read Mailtrap directly?
The scheduled action queries records in Prisma. Mailtrap event data must already be present in the database.
Can the query modify records?
This workflow is intended to use Prisma's read-only SQL query action.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Mailtrap to Prisma. A trigger fires from one place; an action lands in another.
Mailtrap triggers
Prisma actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create Database Connection
Create new api key connection for database access. creates connection string with embedded credentials for application database access. returns complete connection details ready for immediate use.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Create Project Database
Create new postgres database in an existing prisma project. creates database in specified region with connection strings and api keys. returns complete database details ready for immediate use.
Create Prisma Project
Create new prisma project with managed postgres database. creates project in authenticated user's workspace with postgres database in specified region. returns complete project details including connection strings and api keys.
Delete Database Connection
Permanently delete database connection and revoke api key access. warning: this immediately revokes database access for any applications using this connection string. ensure no critical systems depend on this connection.
Delete Prisma Database
Permanently delete prisma database and all stored data. warning: this action cannot be undone. all data in the database will be permanently destroyed. default databases typically cannot be deleted.
Delete Prisma Project
Permanently delete prisma project and all associated resources. warning: this action cannot be undone. all databases, environments, and project data will be permanently destroyed. use with extreme caution in production environments.
Execute SQL Command
Execute sql commands that modify database data or structure. runs insert, update, delete, create table, and other data modification commands safely through postgresql driver with parameterized query support.
Execute SQL Query
Execute sql select queries against prisma databases. runs read-only queries safely through postgresql driver with automatic type mapping. perfect for data analysis, schema inspection, and reporting operations.
Connect any two apps with Notis in the middle.
Mailtrap and Prisma, 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 Prisma.