Query D1 data for document operations
Get a clear answer from a supplied D1 query in the same run that handles a document operations request.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Execute D1 Query
Runs SQL on a D1 database; queries may read, change, or permanently delete data or schema.
Why this helps
Answering an operational question can require a founder to leave the document workflow and manually locate and query a separate database.
- Run an explicitly supplied query against the specified D1 database.
- Summarize results alongside the request that prompted the check.
- Avoid inventing schema or SQL when the request lacks either.
Setup
Build it in a few focused steps.
- 1Connect Affinda and Cloudflare once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it.
- 3In one instruction, ask Notis to execute the supplied read-only SQL against the confirmed D1 database for the incoming document operations request and summarize returned results.
- 4Pick the webhook trigger and choose where run reports should go.
- 5Test with one real example using a verified database and read-only query.
Questions about this workflow
Can this query modify or delete data?
The D1 action can read, write, or permanently delete data or schema. This workflow asks for read-only SQL; review the query and database before using it.
Will Notis write SQL if the request only describes a question?
This workflow requires supplied, verified SQL. It should report missing query or database details instead of guessing.
Does Affinda trigger the run directly?
No. A Notis webhook starts the automation. The incoming request can include the Affinda-related context and query details.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Affinda to Cloudflare. A trigger fires from one place; an action lands in another.
Affinda triggers
Cloudflare actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Create DNS record
Create a DNS record that makes live changes to a zone.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Capture Browser Snapshot
Renders a URL or supplied HTML and returns selected page representations.
Create WAF List
Create an empty custom list for WAF rules and filters.
Check Registrar Domains
Checks authoritative domain registration availability and pricing for up to 20 domains.
Create Zone
Create a DNS zone for a domain.
Create Alert Policy
Creates an account-level notification policy.
Delete DNS Record
Delete a DNS record immediately; this action is irreversible.
Delete WAF List
Delete a WAF list.
Connect any two apps with Notis in the middle.
Affinda and Cloudflare, 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 Cloudflare.