Skip to main content

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?

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

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

 


@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.

 

 


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


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.


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


@vinvalentino 

Add this Zap step: Formatter > Text > Extract Email


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

I’ll give it another try.


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


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.