Hi there,
I’m new to Make.com so this may be a simple fix but I’ve looked over everything similar and just can’t get it to work.
I am trying to map each of the qty values to the correct column on a new row of a Google Sheet as well as one of the dates but if I try to do it manually I only see one of the collections within the data.metrics array.
I have tried multiple options including using an Iterator or a Get Multiple Variables module but have had no luck. The iterator came back with an empty array and I’m not entirely sure on a formula to put into the variables or whether that’s the right thing to do. I have attached the JSON, any advice on what to do would be amazing!
Webhook_JSON.txt (1.6 KB)
Could you just explain exactly what you’re trying to achieve with the automation?
Hello,
For this use “get” built-in function of make.
For example if you want to fetch 4th collection of properties array you will write like this
get(properties;4)
This will return the 4th object of the array.
And
get(properties;4.units)
This will return the value of units of 4th object of the array.
Hope this helps
Basically, every day I will have my nutrition data sent across to the web hood and I want it to then add a new row to a google sheet and add the correct nutrition quantity to the appropriate column eg, the protein quality to the protein column on the new row.
However, if I try and map it directly to Google Sheets it only provides me with the first collection - not all of them. If I try to use any other module to clean the data first it just returns an empty array like this:
Welcome to the Make community!
This part doesn’t look right,
Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —
Getting Started
Help Centre Basics
Articles & Videos
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
