JSON Parse to G Sheets

[Prenevine_Pillay]

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

[RBalani]

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.

[samliew]

Wrong:

You confused “get” with “map”.

Right:

Use the built-in function map to get the email.

{{ first(map(2.email; "email")) }}

Links

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 —

General

• Help Center | Tutorials
• Make Academy – learn Make and get your certificate ← CHECK THIS OUT
• Make Blog – get the latest updates
• Features & Pricing

Help Center Basics

• Mapping – What is mapping? What can I map? ← CHECK THIS OUT
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Tokens for parseDate | Tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI
• How to use Regex in Make