How to connect Memberstack JSON fields to Brevo using Make? Answered
Hey guys, anyone used Memberstack with Make to extract the Json data so that it can be used in other softwares ) brevo in my case. I have json data from each member that I would like to use within the email software but I cant seem to figure out how to connect the json fields.
Any help or resource on this would be greatly appreciated. 🙂
Comments
8 comments
Hey Praveer Srivastava, I think in your case, when you run the first module, you will be getting 3 arrays named genres, looking_for and available_time, do you want to pass on these values as text to the Brevo module? Or could you share how you want to pass on this data to the Brevo module, so that I can suggest a solution accordingly?
Hey A J Thanks for your message. So I can see the json values in the Memberstack module now ( see below ) But I dont know how to add each of the list as a separate category option for a new contact in Brevo.
I want when a new member is created they are auto added to Brevo with the custom fields + json fields under a category with multiple options
Another issue I am seeing is that the json values only show when the use the list a specific member using member ID but when I used the list all members its not showing the json values just the custom fields.
to show this issue more clearly, I have used this when member is updated on the trigger module and it shows the updated data correctly but again doesnt have the json values
compared to get a individual member: its shows me all the json values
Hey Praveer Srivastava, I just signed up for Brevo account and was testing your use-case. It turns out that Category type attribute is a single select by default in Brevo and I don't think passing multiple values is allowed in that case. Alternatively you could store the value as text and achieve this output for each contact (shown in screenshot).
But I believe for reporting or analysis purposes you may want to segment contacts based on the genres or other specific information that you store in JSON, so alternatively you could create columns for each genre / each category (in case its not too much work) and have the attribute type as boolean. So for example, if a user's genre array has Techno in it, then set the Techno field in Brevo to true and so on, therefore possibly you could make lists, segments based on such data in Brevo.
Yes, even I notice that updated module does not show JSON data, so you could add a Get Member module as a second module to get complete information and use it in the further steps.
Hope this helps.
Hey A J Thanks again! Yeah you are right the limitation is from the Brevo side. The reason I wanted this separately was to use this as a condition to trigger campaigns and automation but I think for what I need I can do it using Genre > Contains > ‘techno’ text value so trigger campaign etc.
How the Json Get member suggestion if I understand correctly you are saying I should have a List all members module > then a Get a member module and then the rest of the flow ? And I have multiple members data passed through ? Because at the moment it forces me to choose the specific member.
Not sure if thats what you meant ?
Yes, that condition could work in case you have many genres and many specific categories planned out and don't want to create separate columns for the options.
Yes, what I mean is you could get the Member ID from the Updated members module and map it in the Get Member module by enabling the Map toggle button, instead of having to select it manually. The screenshot below shows what I mean as well, here the Member ID mapped is from the Updated Members Module that I have in the workflow.
Hope this helps.
Cool yeah thats showing the json value in the brevo dropdown now !! 🎉 Now just got to figure out how to use it properly on the brevo side 😅
Thanks man! going to play around with this more as it will be useful for sending that data to other modules as well not just brevo
Yes definitely. Welcome 😇
Also one thing to note here is, you might need to select genres[] from the JSON module to map to Brevo so that all data in genres is passed and not just the Techno one.
Thanks AJ ! Yeah thats very helpful !
Please sign in to leave a comment.