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

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

youtube.com/watch?v=H0aBHNl2ICc

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

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-

youtube.com/watch?v=0umsoycOlfo

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.