How do I extract information from this email?

Hi ​@SueMann 

Email parsing resources:

This doesn’t tell me HOW. I want to know the exact steps to follow in Zapier. 

I’ve tried: 

1. Formatter
2. Extract Pattern
3. Input: Body Plain
4. Pattern: Plan:\s*\$(\d+)
5. All other set to “True”

It does not work/extract the value. 

​@SueMann 

For us to have full context, post screenshots showing how your Zap steps are outlined and configured in EDIT mode with the field mappings/settings visible.

It may depend on which email body format you are using: HTML or TEXT

Attached

​@SueMann 

Can you post screenshots from Zap step 1 that show the DATA OUT for the Body Plain variable you are using in the Formatter step, so we have true context about the format/structure of the values.

This? 

​@SueMann 

The DATA OUT from Zap step 1 would come from the TEST tab.

What are the results from the Formatter step in the TEST tab after testing? (screenshot)

​@SueMann 

Worked when I tested with your RegEx pattern.

Variable Output 0 = 5

I can’t get it to do that. I get no output. 

And the input can’t be typed. It has to come from the body text of the email. 

​@SueMann 

Can you post screenshots from Zap step 1 that show the DATA OUT from the TEST tab for the Body Plain variable you are using in the Formatter step, so we have true context about the format/structure of the values?

Can you post screenshots showing the test results from the Formatter step in the TEST tab? (screenshot)

I did that- second attachment (Zap 2) Screenshots are there. 

​@SueMann 

Your previous screenshots do not show the DATA OUT from the TEST tab in Zap step 1, nor screenshots from the results of testing the Formatter step.

​@SueMann 

And what about screenshots for the DATA OUT from the TEST tab in the Formatter step?

Data out: 

 There is nothing to scroll either. 

Data In shows this: 

​@SueMann 

Did you try retesting the Formatter step?

If there is no match, then it should look like this:

yes. Multiple times. I continue to get: 

Strange. Now on Step 4 (Add to convertkit) it shows me this. But still blank in Data Out in Step 3. So maybe it is working now….? 

And it did indeed push to convert kit:

​@SueMann 

Try turning the Zap ON and testing live.

Check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace and troubleshoot: https://zapier.com/app/history/