• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer
    • 🔥 Pabbly Chatflow — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

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: 138
  • Iterator.png
    Iterator.png
    83.2 KB · Views: 132
  • Format 1.jpg
    Format 1.jpg
    77.8 KB · Views: 110
  • Format 1 to Match Fields.jpg
    Format 1 to Match Fields.jpg
    83 KB · Views: 137
  • Format 2.jpg
    Format 2.jpg
    82.9 KB · Views: 107
  • Format 2 Result.jpg
    Format 2 Result.jpg
    55.3 KB · Views: 129
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: 113
Last edited:
P

Pabblymember11

Guest
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
 
P

Pabblymember11

Guest
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