• Instructions to Ask a Question

    Click on the "Ask a Question" button and select the application for which you would like to ask questions.

    We have 5 different products namely - Pabbly Connect, Pabbly Subscription Billing, Pabbly Email Marketing, Pabbly Form Builder, Pabbly Email Verification.

    The turnaround time is 24 hrs (Business Hours - 10.00 AM to 6.00 PM IST, Except Saturday and Sunday). So your kind patience will be highly appreciated!

    🚀🚀Exclusive Discount Offer

    Just in case you're looking for any ongoing offers on Pabbly, you can check the one-time offers listed below. You just need to pay once and use the application forever -
     

    🔥 Pabbly Connect One Time Plan for $249 (🏆Lifetime Access) -  View offer 

    🔥 Pabbly Subscription Billing One Time Plan for $249 (🏆Lifetime Access) - View offer

Iterator with Google Doc

ichilddev

Member
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

  • Webhook.png
    Webhook.png
    102.6 KB · Views: 84
  • Iterator.png
    Iterator.png
    83.2 KB · Views: 78
  • Format 1.jpg
    Format 1.jpg
    77.8 KB · Views: 62
  • Format 1 to Match Fields.jpg
    Format 1 to Match Fields.jpg
    83 KB · Views: 72
  • Format 2.jpg
    Format 2.jpg
    82.9 KB · Views: 57
  • Format 2 Result.jpg
    Format 2 Result.jpg
    55.3 KB · Views: 69
Last edited:

ichilddev

Member
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

  • Format.jpg
    Format.jpg
    89 KB · Views: 66
Last edited:

Supreme

Well-known member
Staff member
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.


1672897735791.png



2023-01-05_11h18_40.png
 

Supreme

Well-known member
Staff member
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.
 
Top