External Events Trigger Your Daily Revenue Refresh
Your accounting system, time-tracking app, or internal dashboard can send a webhook to Notis each morning. Notis responds by querying current revenue from your Airtable invoice table and creating a fresh snapshot—no cron jobs, no scheduled tasks.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
List records
Retrieves records from an airtable table, with options for filtering, sorting, pagination, and specifying returned fields.
Why this helps
Daily revenue reporting is on your mental to-do list but gets pushed back when priorities shift. A cron job isn't flexible enough if you need reporting tied to business events. You want external tools to drive the automation.
- Revenue snapshots are driven by external business logic, not fixed schedules.
- Flexible: pause, resume, or skip reporting without touching Airtable or Notis.
- Integrates with your existing event-driven architecture.
- Reduces scheduler complexity—use webhooks instead of cron jobs.
Setup
Build it in a few focused steps.
- 1Connect Airtable to Notis in the portal.
- 2In Notis, create an automation with trigger type 'Notis Webhook' and tell it: 'When you receive a webhook request, query my Airtable revenue table and create a new snapshot record with today's date and total revenue across all paid invoices.'
- 3Notis will provide a unique webhook URL.
- 4In your external tool (accounting system, dashboard, scheduler), set up an HTTP POST to that URL each morning or on your preferred schedule.
- 5Test by sending a manual webhook request (curl or Postman) and verify the snapshot record appears in Airtable.
Questions about this workflow
How do I get the webhook URL from Notis?
After creating the automation, Notis displays the unique webhook URL. Copy it and paste it into your external tool's integration settings.
Can I send custom data through the webhook?
Yes. You can include JSON data in the webhook payload, and Notis will extract and use it—e.g., include a custom date or tag and Notis will add that to the snapshot record.
What if the webhook is called multiple times per day?
Notis will create a new snapshot each time. If you want to deduplicate (only one snapshot per day), tell Notis: 'If a snapshot already exists for today, update it instead of creating a new one.'
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Stripe to Airtable. A trigger fires from one place; an action lands in another.
Stripe triggers
Airtable actions
Charge Failed Trigger
Triggered when a direct charge fails in Stripe's legacy Charges API
Create base
Creates a new airtable base with specified tables and fields within a workspace; ensure field options are valid for their type.
Checkout Session Completed Trigger
Triggered when a checkout session is completed in Stripe
Create Comment
Creates a new comment on a specific record within an airtable base and table.
Invoice Payment Succeeded Trigger
Triggered when an invoice payment is successful in Stripe
Create Field
Creates a new field within a specified table in an airtable base.
Payment Intent Failed Trigger
Triggered when a payment intent fails in Stripe
Create multiple records
Creates multiple new records in a specified airtable table.
Product Created Trigger
Triggered when a product is created in Stripe
Create a record
Creates a new record in a specified airtable table; field values must conform to the table's column types.
Subscription Added Trigger
Triggered when a subscription is added in Stripe
Create table
Creates a new table within a specified existing airtable base, allowing definition of its name, description, and field structure.
Subscription Deleted Trigger
Triggered when a subscription is deleted in Stripe
Delete Comment
Deletes an existing comment from a specified record in an airtable table.
Delete multiple records
Deletes up to 10 specified records from a table within an airtable base.
Connect any two apps with Notis in the middle.
Not just Stripe and Airtable. Any combination from 985+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7 days free trial with 20$ free usage included.
No card. Works with personal or business Airtable.