Create Whatsapp Group based on new spreadsheet row ( Form is HTML and pushed to Google Spreadsheet)

[Webevolution]

Hi,
Im having issues what creating whatsapp groups. Current workflow is that a html form is filled on my client portal.
Then the whatapp groups should be created.This doesnt happend only when I manual push the event.
Is their a workaround?
Im aware that Pabbly has issues getting the event if its appscript loaded

 

[Preeti Paryani]

Hello @Webevolution,

Could you please provide us with the workflow URL with which you're facing this issue so we can better look into the issue and assist you further?

 

[Webevolution]

Hi Preeti,
I can but this is a public form, can you make it private?
further more,
You wont see anything happen in the automation because its not trigger because of the Googlesheet automation (Data is loaded via app script)

 

[ArshilAhmad]

For Google Sheets, we do not support formula-based triggers. The data must either be entered manually into the trigger column or through an API.

If the data is added to your spreadsheet through an App Script, it will not trigger the workflow.

 

[Webevolution]

what do you recommand? Current workflow is that the data is entered in the spreadsheet, so V-lookup is performand to add additional data, and the when sending all data. The whatapp group are created. I still need to add a delay for 10 sec for sending messages but that not possible using pabbly

 

[ArshilAhmad]

You have to enter the data in your spreadsheet either manually or through an API; there is no other workaround. It won't trigger if the data is added through formulas.

You can use a Delay step in your workflow, but it can only be set to a minimum of 1 minute, not lower than that