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

[veeco]

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 ?

 

[Pabbly13]

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-

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-

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.