Weekly Automatic Invoice Reconciliation
Every week, Notis reviews your pending invoices in Drive and pulls the complete list from Stripe. You get a summary without lifting a finger.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
List Invoices
Retrieves a list of stripe invoices, filterable by various criteria and paginatable using invoice id cursors obtained from previous responses.
Why this helps
You have invoices tracked in Google Drive and others in Stripe, and you never know if they're in sync. Clients claim they haven't been invoiced when they actually were.
- Know exactly which invoices are pending, paid, or overdue without manual checking
- Catch billing gaps where invoices in Drive weren't created in Stripe
- Spend minutes, not hours, on weekly invoice reconciliation
- Reduce billing errors from misaligned records
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Stripe to Notis.
- 2Create an automation: 'Every week, pull the list of invoices from my Stripe account and compare them with my Google Drive invoice tracker.'
- 3Select the trigger 'Notis Cron - Weekly' and choose your notification channel (email recommended for summaries).
- 4Customize the day and time (e.g., Monday mornings) and run the first report.
Questions about this workflow
How does Notis know which invoices to compare?
You specify your invoice folder in Drive and Notis runs a standard Stripe query. It then matches invoices by customer name, ID, or date range you define.
What if there are discrepancies?
Notis flags them in your weekly summary so you can investigate. For example: 'Invoice 123 is in Drive but not in Stripe yet.'
Can I get daily reports instead of weekly?
Yes. You can adjust the frequency to daily, but weekly is recommended to avoid alert fatigue while still catching issues quickly.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Google Drive to Stripe. A trigger fires from one place; an action lands in another.
Google Drive triggers
Stripe actions
Comment Added (Docs/Sheets/Slides)
Triggers when a new comment is added to Google Docs, Sheets, or Slides.
Cancel subscription
Cancels a customer's active stripe subscription at the end of the current billing period, with options to invoice immediately for metered usage and prorate charges for unused time.
File Created
Triggers when a new file is created in Google Drive.
Confirm payment intent
Confirms a stripe paymentintent to finalize a payment; a `return url` is necessary if the payment method requires customer redirection.
File Deleted or Trashed
Triggers when a file is moved to trash or permanently deleted in Drive.
Create Customer
Creates a new customer in stripe, required for creating charges or subscriptions; an email is highly recommended for customer communications.
File Shared (Permissions Added)
Triggers when new sharing permissions are granted to a file or folder. Uses Drive's `changes.list` endpoint with inline `permissions` in the `fields` mask so each change carries the file's current permission set provider-atomically. We diff that against `seen_permission_keys` to identify newly added grants. Drive page tokens are the primary cursor; if Drive rejects a stored token, the trigger raises `PollingTriggerError` without clearing state rather than silently re-baselining and dropping events. Limitation: truly ephemeral permissions (added and revoked between two polls without any other file modification in between) are not detected. Drive Activity API would catch those but requires an additional OAuth scope and a different payload contract.
Create an invoice
Creates a new draft stripe invoice for a customer; use to revise an existing invoice, bill for a specific subscription (which must belong to the customer), or apply detailed customizations.
File Updated
Triggers when a file's metadata or content changes in Google Drive.
Create payment intent
Creates a stripe paymentintent to initiate and process a customer's payment; using `application fee amount` for a connected account requires the `stripe-account` header.
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Create a price
Creates a new stripe price for a product, defining its charges (one-time or recurring) and billing scheme; requires either an existing `product` id or `product data`.
New File Matching Query
Triggers when a new Google Drive file matches a provided query. This is the legacy query-centric trigger: it preserves Drive API query config such as ``corpora`` / ``driveId`` aliases and emits the historical ``file_matching_query`` event type. ``FileCreatedTrigger`` covers the broader "new file" case and emits ``file_created``.
Create product
Creates a new product in stripe, encoding the request as `application/x-www-form-urlencoded` by flattening nested structures.
Create Refund
Creates a full or partial refund in stripe, targeting either a specific charge id or a payment intent id.
Connect any two apps with Notis in the middle.
Not just Google Drive and Stripe. 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 Stripe.