I’m trying to connect a Mixpanel insights report to Google Sheets. The data from mixpanel comes in the format in the image. My issue is that it’s structured so that there’s something called Formula that contains emails which then each individually contain their respective values. I’m trying to output this in Sheets so that each row has 1 email and 1 value. However, I just can’t seem to figure out how to do it. Any suggestions?
You can use aggregator and iterator
Hi Sebby,
from what I can see this is just a collection of collections. What issue are you having exactly with mapping this to a google sheet module?
Hi Stoyan_Vatov, thanks for your question, Under Formula (which is under Series) there are collections, these are 1 email each (I’ve hidden the emails under the red lines) and then under all of them there’s “all” which contains a number. I would like to output a list of all the emails in one column and all the corresponding numbers in another column in Google Sheets. Do you have any suggestions on how to do this? 
Let me know if you need any other info!
and my problem is that I can’t figure out how to do this. I can get the values from “all”, but I can’t figure out a way to get both the emails and the values. I’m new to Make, any help would be greatly appreciated!
Can you send a screenshot of the google sheets module and how its configured? Also a screen shot of what options you can see when you try and map something there?
Thank you @Stoyan_Vatov for helping out! Please see attached the errors and the setup. I’ve just connected Mixpanel directly to Google Sheets and it’s just an empty sheet that I’m trying to send it to.
I managed to solve it in the end, by using a to_Array iterator on Formula, then turning it to JSON, parsing it and that way accessing the emails.
1 Like