Iterator with Google Doc

[ichilddev]

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.

 

[ichilddev]

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?

 

[Supreme]

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.

 

[ichilddev]

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.


View attachment 19980


View attachment 19979

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

 

[Supreme]

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

Yes, you need to map the individual labels in terms to pass the data in every passed parameter in your Google Docs.