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?