HI Community
Hope everyone is well
I am making an api call via HTTP, sending to JSON and trying to then store onto google sheets, I don’t seem to be getting the last part right, please see below
I need to get the cell highlighted in green, to be populated in google sheet (A)
no matter what I try, I get the below
Thank you all
If you are using the HTTP module, there’s no need to use the parse JSON module. If you want to parse JSON, you can select ‘Parse Response’ as ‘Yes’ in the HTTP module.
To populate an email in a particular cell in a google sheet map email directly.
You confused “get” with “map”.
Use the built-in function map to get the email.
{{ first(map(2.email; "email")) }}
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 —
parseDate | Tokens for formatDate