The Stripe connector can link charges, customers, invoices, prices, products, subscriptions, and balance transactions to PostHog.
Creating a Stripe API key
You need a Stripe API key to create a connector. Head to your Stripe dashboard > Developers > API keys, under Restricted keys, click + Create a restricted key.
You need to give your API key the following Read permissions:
| Resource Type | Required Read Permissions |
|---|---|
| Core | Balance transaction sources, Charges, Customer, Product, Disputes, Payouts |
| Billing | Invoice, Price, Subscription, Credit notes |
| Connected | All resources |
Adding a data source
- In PostHog, go to the Data pipeline page select the Sources tab.
- Click + New source button and select Stripe by clicking the Link button.
- In Stripe, get your Account ID by going to Settings > Business, selecting the Account details tab, and clicking your Account ID or pressing
⌘+Ito copy your ID. - Get your API key from the previous section
- Optional: Add a prefix to your table names
- Click Next
For Stripe tables, incremental syncs will only sync new records and not update existing records. This is a limitation of the Stripe API in which it's not possible to query for updated data.
The data warehouse then starts syncing your Stripe data. You can see details and progress in the data pipeline sources tab.