Skip to main content
Best answer

Email value from webhook sometimes showing up, sometimes not

  • Mar 15, 2025 7:32 PM UTC
  • 10 replies
  • 136 views

I’ve set up a webhook connection from RevenueCat, and it appears to be working in that I can see the email value on the same field each time, but it is not getting passed through to the destination consistently. 

 

First I tried setting up a zap to pull form the webhook into Klaviyo email marketing to add or update a user profile with purchase info from RevenueCat. It seems to work about half the time. The other half I get a response saying must include email. I can see that the email was clearly included in the webhook from RevenueCat though.

So then I tried setting up a zap to send from the RevenueCat webhook into a Google sheet, then from the Google sheet to Klaviyo in case the issue was with formatting on Klaviyo’s end. But I can now see that nothing is getting filled in on the Google sheet half the time. Other times it works perfectly and I can see the email. When I view the webhook info in Zapier i can see that the email was present in the webhook.

Any thoughts?

Best answer by Troy Tessalone

​@vinvalentino 

Looks like there are 2 different formats of data coming thru for subscriber_attributes:

  • $email
  • email

 

You can try mapping 2 variables to the same input field.

 

 

View original
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Mar 15, 2025 9:24 PM UTC

Hi ​@vinvalentino 

For us to have more info, post these screenshots:

  • how your Zap steps are outlined and configured in EDIT mode with the field mappings visibile
  • the DATA OUT from Zap step 1 in a Zap Run for a success example and for an error example

  • Author
  • Beginner
  • Mar 15, 2025 11:27 PM UTC

​@Troy Tessalone sure, here you go. Thanks for the super fast reply! Wasn’t expecting such a quick response!

 


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Answer
  • Mar 17, 2025 3:33 PM UTC

​@vinvalentino 

Looks like there are 2 different formats of data coming thru for subscriber_attributes:

  • $email
  • email

 

You can try mapping 2 variables to the same input field.

 

 


  • Author
  • Beginner
  • Mar 17, 2025 6:48 PM UTC

​@Troy Tessalone THANK YOU! I figured out how to do that and it works perfectly!


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • Mar 18, 2025 2:51 AM UTC

Wow! Thank you for confirming that Troy’s suggestion got the Zap running. This will significantly help our Community members to have as a reference for the same issue.


  • Author
  • Beginner
  • Mar 19, 2025 3:37 AM UTC

Hi ​@Troy Tessalone okay, one other question now that we’ve got it working. It seems like in some cases the webhook is sending fields for both $email and ‘email’, which is causing the email value being passed to klaviyo to be doubled. Like a user with the email max@domain.com would show up as max@domain.commax@doman.com

 

Is there a way to write a rule for that? I tried using the AI tool to do an email extract and pass that through but it didn’t seem to work.

 

Thanks again!

Vince


Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Zapier Orchestrator & Solution Partner
  • Mar 19, 2025 2:32 PM UTC

​@vinvalentino 

Add this Zap step: Formatter > Text > Extract Email


  • Author
  • Beginner
  • Mar 19, 2025 5:50 PM UTC

That’s what I was trying to do but in the data view it just showed email: {{{

I’ll give it another try.


  • Author
  • Beginner
  • Mar 19, 2025 6:27 PM UTC

I think I got it working, looking good on runs so far! Thanks again for all your patience and help!


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • Mar 20, 2025 2:10 AM UTC

Wow! Thank you for confirming that Troy’s resolution got the Zap running. This will significantly help our Community members to have as a reference for the same issue.