If you decide you want to build an integration between HubSpot and Stripe yourself instead of looking at a tool like ClearSync, we’d advise you to crack open a crisp seltzer and:
- (1) Read this beautiful article on calculating MRR from raw Stripe data.
- (2) Read this article on MRR source of truth.
Consider your Options for Syncing Stripe Data to HubSpot
Option 1: Manual Exports/Imports
It is possible to export data out of Stripe and import it into HubSpot.
- If you have the Stripe Sigma add-on, you can run powerful SQL queries based on templates that are provided.
- If not, you can export all Invoices from Stripe via the UI and attempt to match to HubSpot Contacts via Stripe Customer Email and Stripe Customer Name.
Option 2: Use Middleware like Zapier/Make
- Zapier has some pre-made templates to sync Stripe data to HubSpot. These templates simplify the integration by pushing data directly to the HubSpot Contact that represents the Stripe Billing Email.
- Make also has some pre-made templates, similarly syncing to HubSpot Contacts.
Option 3: Piggyback on a Data Warehouse Integration
If your product team has integrated Stripe into your product or buying experience, it’s probable that they’re already storing Stripe data in a data warehouse such as BigQuery or Redshift, which might also already be connected to HubSpot.
- Ideally, you can do some Stripe data transformations described in the articles above within your data warehouse and then push them to HubSpot on a Custom Object.
