Skip to main content

I want a new subscription signup in Stripe to emerge as a closed won opportunity in Salesforce that is tied to account and contact if it already exists.

As of now, the Account Name in SF does not match the Customer Name in Stripe. I need to split text and remove the ā€œā€™sā€ off the Customer Name in Stripe so it matches the Account Name in Salesforce, otherwise the Zap isnā€™t working.

Example: in Salesforce, the account name is Adam. In Stripe, the customer name is showing up asĀ ā€œAdamā€™s Account.ā€

I tried using the split text feature but itĀ isnā€™t working for apostrophes.

Any other recommendations on building a zap thatĀ can tie Stripe info to Salesforce opportunity w/ contact and account if it exists?

I have connected it by email but if that contact doesnā€™t exist yet we want to find or create an account record as well and thatā€™s where the zapĀ stops. Right now we have the following steps: 1. New Event in Stripe - New Customer Subscription Signup 2. Find Contact Record (based on email) 3. Find or Create Account Record 5. Update Account Record 6. Find Opportunity Record 7. Update Opportunity Record


Hi @thirtycapitalĀ 

Why arenā€™t you using email as the identifier? As far I know, almost everyone uses email to search for accounts or any associated records since email is going to be unique for everyone.

Also I just tested with split formatter and it works forĀ Adamā€™s AccountĀ using this as a separatorĀ ā€™Ā . Make sure you are using the right character because there are several that looks like thisĀ ā€™ .