Library / Finance, Invoices & Accounting
Finance, Invoices & Accounting
Sync Stripe Charges to HubSpot Contacts
On a schedule, it totals Stripe charges per customer and creates or updates the matching HubSpot contacts with the amounts.
What it does
## Sync Stripe charges to HubSpot contacts This workflow pushes Stripe charges to HubSpot contacts. It uses the Stripe API to get all charges and the HubSpot API to update the contacts. The workflow will create a new HubSpot property to store the total amount charged. If the property already exists, it will update the property. ### How it works 1. On a schedule, the first Stripe node gets all charges. The default schedule is once a day at midnight. 2. Once the charges are returned, the second Stripe node gets extra customer information. 3. Once the customer information is returned, Merge data node will merge the customer information with the charges so that the next node Aggregate totals can calculate the total amount charged per contact. 4. Once we have the total amount charged per contact, the Create or update customer node will create a new HubSpot property to store the total amount charged. If the property already exists, it will update the property. Workflow written by [David Sha]({{ $env.WEBHOOK_URL }}
The steps
- If charge has customer
- Get customer
- On schedule
- Remove duplicate customers
- Aggregate `amount_captured`
- Aggregate totals
- Create or update customer
- Merge data
- Get all charges
- Get HubSpot field
- Create field in HubSpot
- Configure
- Skip field checking
- Do nothing
34 steps in total.
Similar automations
Data Sync & ETLSync Stripe Charges to HubSpot Contacts15 stepsData Sync & ETLSync Stripe charges to HubSpot contacts on a daily schedule15 stepsCRM & Sales PipelineSync Stripe Customers and Charges to Pipedrive21 stepsFinance, Invoices & AccountingUpdate HubSpot and Alert Slack on Paid Stripe Invoices8 steps