Sync new Stripe subscriptions to Notion and Slack

Build a code workflow that logs every new Stripe subscription into a Notion customers database and announces it in Slack. The whole thing should be deterministic CRUD with no agent reasoning needed.

Trigger: poll Stripe for the new_subscription event. Whenever a new subscription is created, fire the workflow with that subscription's ID and customer ID.

Step 1. Use the Stripe Retrieve Subscription operation to fetch the full subscription object. Pull the plan or price nickname (call it the plan name), the recurring amount converted to monthly recurring revenue in dollars (MRR), the status, the start date as the signup date, and the customer ID.

Step 2. Use the Stripe Retrieve Customer operation against that customer ID to get the customer name and billing email.

Step 3. Use the Notion Query a Data Source operation against the customers database, filtering on the Stripe customer ID property equal to the customer ID from Stripe. If any page comes back, exit the workflow without writing or posting (this is the dedupe check).

Step 4. Use the Notion Create a Page operation to add a new page in the customers database. Map the properties: Name = customer name, Email = billing email, Plan = plan name, MRR = the dollar amount, Status = subscription status, Signup Date = signup date, Stripe Customer ID = the Stripe customer ID, and a Stripe Customer URL property linking to https://dashboard.stripe.com/customers/{customer_id}. Capture the new Notion page URL from the response.

Step 5. Use the Slack Send a Message operation to post to the #revenue channel (make this configurable at setup). The message should be a single line in the format: "New {plan} subscription: {customer name} (${mrr}/mo)" with the new Notion page URL linked at the end so anyone in the channel can click through to the customer record.

At setup, ask the user to pick: their Stripe account, the Notion customers database, the column names that map to Name, Email, Plan, MRR, Status, Signup Date, Stripe Customer ID, and Stripe Customer URL, and the Slack channel to post in.

Additional information

What does this prompt do?

Watches Stripe for new subscriptions and reacts the moment one is created.
Pulls the customer name, billing email, plan, and MRR from Stripe and files a structured row in your Notion customers database.
Skips duplicates by checking for an existing row with the same Stripe customer ID before creating a new one.
Posts a one-line announcement in your Slack revenue channel with a link back to the new Notion page.

What do I need to use this?

A Stripe account with permission to read customers and subscriptions.
A Notion workspace and a customers database with columns for name, email, plan, MRR, status, signup date, and Stripe customer ID.
A Slack workspace and a channel like #revenue where the announcement should land.

How can I customize it?

Change which Slack channel gets pinged, or send to multiple channels for different plan tiers.
Adjust the message format, for example highlight only paid plans above a certain MRR threshold.
Add or rename the Notion properties to match how your team tracks customers (region, AE owner, lifecycle stage, etc.).

Frequently asked questions

What does this do when someone subscribes for the second time?

Before creating a new Notion page, the workflow checks the customers database for an existing row with the same Stripe customer ID. If one already exists, it skips the create step so you don't get duplicate records.

Will this capture upgrades and downgrades?

It only fires on brand new subscriptions. Plan changes on existing subscriptions are a different event. You can clone this prompt and swap the trigger if you want to track those too.

Do I need a special Notion database template?

No, but your customers database should have columns for the fields you want to log, like name, email, plan, MRR, and Stripe customer ID. The workflow writes into the columns you choose during setup.

Can the Slack message link back to the Notion page?

Yes. After the Notion page is created, the workflow includes its URL in the Slack message so anyone in the channel can jump straight to the customer record.

How fast does it run after a new subscription?

The workflow checks Stripe on a short interval, so new subscriptions typically appear in Notion and Slack within a couple of minutes of being created.