What data does Datadrew pull from Stripe?

Connecting Stripe to Datadrew gives you access to your payment and revenue data, including charges, refunds, subscriptions, invoices, customers, disputes, and balance transactions. This data powers revenue analytics, churn tracking, and LTV calculations in your Datadrew dashboards.

Prerequisites

• A Stripe account (any plan)
• Admin or Developer access to the Stripe Dashboard
• An active Datadrew account (any plan)

Step-by-step: Generate your Stripe API key

1. Log in to your Stripe Dashboard.
2. Click Developers in the top navigation bar.
3. Select API keys from the left sidebar.
4. Under Standard keys, locate the Secret key row.
5. Click Reveal live key (or Reveal test key if you want to test first).
6. Copy the key. It will start with sk_live_ (production) or sk_test_ (test mode).

⚠️ Important: Use the Secret Key (starts with sk_), NOT the Publishable Key (starts with pk_). The Publishable Key does not have the permissions needed to read your data.

What to enter in Datadrew

1. In Datadrew, go to Settings → Integrations.
2. Find Stripe and click Connect.
3. Paste your Secret Key into the API Key field.
4. Click Save to complete the connection.

Official documentation

For more details on Stripe API keys, see the Stripe API Keys documentation.

Troubleshooting

• "Invalid API key" error: Make sure you copied the full Secret Key, including the sk_live_ or sk_test_ prefix. Do not include any extra spaces.
• No data appearing: If you used a test key (sk_test_), only test-mode data will sync. Switch to a live key for production data.
• "Permission denied" error: Ensure you have Admin or Developer access in Stripe. Standard team members may not be able to view API keys.
• Restricted keys: If you use a restricted key instead of a standard key, ensure it has Read permissions for all relevant resources (Charges, Customers, Subscriptions, Invoices, etc.).