• 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

Google Sheet to WhatsApp Cloud API (Bulk Message/Broadcast) with Dynamic Template

veeco

Member
Hello
I want to do Bulk Message/Broadcast from Google Sheet with WhatsApp Cloud Api.
I already watch the youtube guide:

But having bit problem on Dynamic Template.
so i have a column to set the template name i'd like to use... this i can map in pabbly connect
The language can alse get hardcoded

The problem is with Selected Template ID and mapping the variables

How to solve this ?
 

Attachments

  • 2022-08-18_09-25-51.png
    2022-08-18_09-25-51.png
    79.5 KB · Views: 89

Subin

Well-known member
Staff member
Hey @veeco !

You cannot pass the Template name inside the Template field.

If you want to make it dynamic, then you need to add the template id instead of the name-

1660809161430.png


Also, you can use the Lookup table, so that on one side you can add the template name and on the next side you can add the template id as shown below-

1660809471568.png


You can check on this video tutorial for the Lookup working-


Same you need to make one more Lookup table for using Language as well.

Do check and let us know if this works for you now.
 
Top