Auto-Log Subscription Cancellations for Churn Analysis
Every cancellation matters. Each subscription deletion auto-logs to Drive with the customer, plan, tenure, and cancellation date, building a churn analysis document over time.
Trigger
Subscription Deleted Trigger
Triggered when a subscription is deleted in Stripe
Action
Create Comment
Tool to create a comment on a file. use when you need to add a new comment to a specific file in google drive.
Why this helps
Subscriptions cancel but you don't track them systematically. You have no visibility into churn rate, reasons, or patterns. Insights stay locked in Stripe.
- Complete churn history organized in one place
- Easy to spot patterns in who cancels and when
- Data supports retention strategy improvements
- No manual logging needed
Setup
Build it in a few focused steps.
- 1Connect Stripe and Google Drive to Notis.
- 2Create a churn analysis document in Drive.
- 3Ask Notis: 'When a subscription is deleted in Stripe, log it to the churn analysis document with the customer name, plan, how long they subscribed, and the cancellation date.'
- 4Review the churn logs monthly to identify patterns.
- 5Test by canceling a subscription in Stripe.
Questions about this workflow
Can I include cancellation reasons?
Yes. If Stripe captures a cancellation reason, Notis includes it in the log. This builds a feedback history over time.
How do I calculate churn rate from this log?
The log is timestamped, so you can count cancellations per month and divide by active subscriptions to calculate rate.
Can I identify which products or plans have highest churn?
Yes. The log includes the plan name, so you can group cancellations by product or tier to see which ones leak customers.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Stripe to Google Drive. A trigger fires from one place; an action lands in another.
Stripe triggers
Google Drive actions
Charge Failed Trigger
Triggered when a direct charge fails in Stripe's legacy Charges API
Add file sharing preference
Modifies sharing permissions for an existing google drive file, granting a specified role to a user, group, domain, or 'anyone'.
Checkout Session Completed Trigger
Triggered when a checkout session is completed in Stripe
Copy file
Duplicates an existing file in google drive, identified by its `file id`.
Invoice Payment Succeeded Trigger
Triggered when an invoice payment is successful in Stripe
Create Comment
Tool to create a comment on a file. use when you need to add a new comment to a specific file in google drive.
Payment Intent Failed Trigger
Triggered when a payment intent fails in Stripe
Create Shared Drive
Tool to create a new shared drive. use when you need to programmatically create a new shared drive for collaboration or storage.
Product Created Trigger
Triggered when a product is created in Stripe
Create File or Folder
Creates a new file or folder with metadata. use to create empty files or folders, or files with content by providing it in the request body (though this action primarily focuses on metadata creation).
Subscription Added Trigger
Triggered when a subscription is added in Stripe
Create a File from Text
Creates a new file in google drive from provided text content (up to 10mb), supporting various formats including automatic conversion to google workspace types.
Subscription Deleted Trigger
Triggered when a subscription is deleted in Stripe
Create a folder
Creates a new folder in google drive, optionally within a parent folder specified by its id or name; if a parent name is provided but not found, the action will fail.
Create Reply
Tool to create a reply to a comment in google drive. use when you need to respond to an existing comment on a file.
Connect any two apps with Notis in the middle.
Not just Stripe and Google Drive. Any combination from 1,000+ 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 Google Drive.