How do I update my spreadsheet when a subscription is cancelled in PayPal?

Question

I have clients on a paypal subscription, and can't figure out how to connect a cancellation of that to another zap (to add a line to my spreadsheet to note the cancellation)

I can do the spreadsheet part - that's fine - but there isn't an option on the paypal dropdown in zapier for the cancellation to trigger anything else. I tried having it look for a keyword in the cancellation email, but then it just puts the whole cancellation email in the spreadsheet. Not ideal

Do you know if I can have it look for a particular phrase and then note the words after that phrase? in the text it'll say "The recurring payment for Name is cancelled."

Can I have it look for "the recurring payment for" and then parse the next 2 words?

MohSwellam · Accepted Answer

Hi @bonnie.rd,What you can do in the Formatter by Zapier is the following:Event = TextTransform = Split TextInput would be the cancellation email (which Iassume you already have in the trigger result)Separator = the recurring payment forSegment Index = LastThis would output “Name is cancelled”Im not sure if that is what you need?

bonnie.rd · Answer

That worked! Thank you so much :)

Useful links

Code of conduct

Using the Community

Community expectations

Useful links

Code of conduct

Using the Community

Community expectations

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded