# Parse data from Webhook issue

**URL:** <https://community.n8n.io/t/parse-data-from-webhook-issue/10194>\
**Category:** Questions\
**Tags:** data-transformation\
**Created:** [December 28, 2021, 12:30pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194 "2021-12-28T12:30:14Z")\
**Posts on this page:** 12\
**Page:** 1

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 12:30pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/1 "2021-12-28T12:30:15Z")

</div>

i have got data in the body in webhook, now I want each JSON output to send an email, now which nodes shall I use so that it can send an email, email will go to all JSON output one by one, when I tried then email went to only to first JSON output but I want to sent to all one by one how its possible, Webhook will have multiple JSON Output  
“body”: [

{

“name”: “name of client1”,

“email”: “emailid of client 1”,

“phone”: phone no of client 1,

“Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”: “Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”

},

{

“Name”: “client2”,

“email”: “client2email”,

“phone”: clientphone2,

“Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”: “Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”

},

{

“name”: “client 3”,

“email”: “client 3 email”,

“phone”: client 3 phone,

“Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”: “Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”

},

{

“name”: “client 4”,

“email”: “client 4 email”,

“phone”: client 4 phone,

“Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”: “Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd=OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09) Meeting ID: 82606406292 Passcode: soiim”

}

]

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [December 28, 2021, 12:48pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/2 "2021-12-28T12:48:06Z")

</div>

Hi @chandan988, I assume the email addresses are dummy ones? If not, you might want to redact them.

Assuming the `body` array field from your example is a top level field (and not nested in other fields), you could use a workflow like this to transform the single array field into individual n8n items and send out an email for each item:

 ![image](https://europe1.discourse-cdn.com/n8n/original/2X/b/b8f6d33aa700c6a6d2f61b08bbab7d4bede23a76.png)

> **Example Workflow**
>

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 12:52pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/3 "2021-12-28T12:52:54Z")

</div>

So, i want to add all JSON output to append google sheet so after list item node I can use spreadsheet append node and it will append all values , correct me if I am not wrong

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 12:55pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/4 "2021-12-28T12:55:59Z")

</div>

![image](https://europe1.discourse-cdn.com/n8n/original/2X/c/cc92a9cdf7c002f00be6b39e86ae11972325591d.png)  
i get error when i do

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [December 28, 2021, 1:02pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/5 "2021-12-28T13:02:52Z")

</div>

From the screenshot it looks like you have added an expression in the _Fields To Split Out_ field. Can you try resetting that value (by clicking on the little gears icon next to it) and enter the field name of your array (I think it’s `body`)?

Like so:

 ![image](https://europe1.discourse-cdn.com/n8n/original/2X/e/e8261a32aa93419e3a899766f745f3963c20d8bf.png)

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 2:53pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/6 "2021-12-28T14:53:43Z")

</div>

Yes i am able to do and data is in format as i wanted, But it sends to other node in single shot, can we control this speed to avoid issue ( ie sending too many request in single time ) for sending whatsapp or any any other httpsapi

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 2:59pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/7 "2021-12-28T14:59:28Z")

</div>

if data output json in this format which node to be used for parse data into correct format

“body”: {

“{“[name":“chandan”,“EmailID”:"chandan\_988@yahoo.com](mailto:name%22:%22chandan%22,%22EmailID%22:%22chandan_988@yahoo.com)”,“PhoneNo”:“7838808080”,“Batch Schedule”:“Live class on 28 Dec at 11 AM by Chandan sir [Launch Meeting - Zoom](https://us02web.zoom.us/j/82606406292?pwd)”: “OEhEbUgrblNzdWd5RDdrTVcwRm9zZz09 Meeting ID: 82606406292 Passcode: soiim”,“status”:“send”,“SpreadsheetName”:“Live Class Notifcation for Class”,“SpreadsheetID”:“1WVndpiWw5cLjiHo3PAYk9m9B0YB7ehsv2UzyRieFAng”,“SheetName”:“Sheet1”,“SheetID”:0,“TriggerColumn”:“E”,“RowIndex”:2}”

}

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 3:04pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/8 "2021-12-28T15:04:17Z")

</div>

![image](https://europe1.discourse-cdn.com/n8n/original/2X/9/940453d68525face8380a7d0ce7cb7e7ea6e84e2.png)

in this i am getting error this is not an array so any node I can use

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [December 28, 2021, 3:42pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/9 "2021-12-28T15:42:28Z")

</div>

So this looks like a very different data structure from what you have originally shared. It also doesn’t seem like valid JSON. Could you share a screenshot of the JSON data in n8n?

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 3:45pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/10 "2021-12-28T15:45:32Z")

</div>

![image](https://europe1.discourse-cdn.com/n8n/original/2X/c/cd63381d548abb9930e15c8f30e916f2cda2ab53.png)

---

<div class="post-metadata">

**Author:** ![MutedJam](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mutedjam/32/70851_2.png) [@MutedJam](https://community.n8n.io/u/MutedJam)\
**Post date:** [December 28, 2021, 4:08pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/11 "2021-12-28T16:08:30Z")

</div>

Woah, this looks like the body object has a stringified (but seemingly incomplete) JSON object as the first key. That’s absolutely wild and I can’t think of a good way of parsing it tbh. Any chance you can revert back to the previous format including a valid array? That was much more suitable for processing in n8n.

---

<div class="post-metadata">

**Author:** ![chandan988](https://avatars.discourse-cdn.com/v4/letter/c/cab0a1/32.png) [@chandan988](https://community.n8n.io/u/chandan988)\
**Post date:** [December 28, 2021, 4:10pm UTC](https://community.n8n.io/t/parse-data-from-webhook-issue/10194/12 "2021-12-28T16:10:12Z")

</div>

ok noted, thank you. will try with array format
