Iterator with Google Doc

Dear Community

We are trying to use
1. Webhook
2. Iterator
3. Google Doc
to populate a table in google doc from doc template. Any advise how we can do it?

We are not sure how we should name the fields {{ }} in Google doc to fill in the values from iterator

Google Doc link https://docs.google.com/document/d/1fBvXcGfAZYi_BwmyeKaSZQrgGEUJ2SMJr02mfc-ixtk/edit#

We have tried Format 1, but the fields required to be match does not look right. See Format 1 & Format 1 to Match Fields

We have tried Format 2, and the result is in Format 2 result.

We are restricting the number of rows to be 5 i.e 5 item max.

Any advise is welcome and willing to look for paid freelancer to help on this.

Attachments

This is the value from Webhook. Have amended the Key to follow the key in google doc table.

[{
"FeeName":"Uniform",
"Desc":"test 2",
"UP":100.00,
"Q":10,
"F":1000.00,
"T":80,
"D":0
}, {
"FeeName":"School Fee (Full Day)",
"Desc":"School Fee ",
"UP":1000.00,
"Q":1,
"F":1000.00,
"T":76,
"D":50
}, {
"FeeName":"Nursery Full Day",
"Desc":"Nursery Full Day",
"UP":1200.00,
"Q":1,
"F":1200.00,
"T":96,
"D":0
}, {
"FeeName":"test subsidy",
"Desc":"test description",
"UP":200.00,
"Q":1,
"F":200.00,
"T":0,
"D":0
}
, {
"FeeName":"Full Day WM",
"Desc":"For Day Working Mother",
"UP":300.00,
"Q":1,
"F":300.00,
"T":0,
"D":0
}
]

Is this correct?

Attachments

Hey @ichilddev

In Google Docs you should use the data labels in a unique manner instead of using a similar name for every parameter.

Please check the following screenshot and then try again accordingly.

We have tried and it is working fine.

Hey @ichilddev

In Google Docs you should use the data labels in a unique manner instead of using a similar name for every parameter.

Please check the following screenshot and then try again accordingly.

We have tried and it is working fine.

Meaning I have to mapped each value from webhook to the doc individually, and iterator won't populate line by line?