Weekly Automatic Customer List Audit
Every week, Notis pulls your entire Stripe customer list and keeps a Google Sheet in sync. One source of truth for all customers.
Trigger
Google Drive Changes
Triggers when changes are detected in a Google Drive.
Action
List customers
Retrieves a list of stripe customers, with options to filter by email, creation date, or test clock, and support for pagination.
Why this helps
Your Stripe customer list grows but you never have an updated roster. You don't know how many active customers you have or if there are duplicates.
- Always have an updated customer roster in one place
- Spot duplicate customer records in Stripe
- Track customer growth trends week over week
- Reduce manual work copying customer data
Setup
Build it in a few focused steps.
- 1Connect Google Drive and Stripe to Notis.
- 2Create an automation: 'Every week, pull my complete customer list from Stripe and keep my Drive sheet in sync.'
- 3Specify which columns to include (email, name, company, created date, subscription status).
- 4Select the trigger 'Notis Cron - Weekly' and choose day/time.
- 5Create or link a Google Sheet where Notis will write the customer list.
Questions about this workflow
Will this overwrite my sheet every week?
Notis appends new customers and updates existing ones, preserving any notes or custom columns you add. Your data stays safe.
Can it only sync new customers, not all of them?
You can configure it to append only new customers added since last week, or do a full sync. Full sync is recommended for accuracy.
What if I have thousands of customers?
Notis handles large lists efficiently and can split them across multiple sheets if needed. Pagination is handled automatically.
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 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 Stripe.