Automatic confirmation WhatsApp from Google Sheets

[areamarketer]

Hi everyone, I hope you can help me.
I need to create an automation.
I have a form (https://www.getformly.com/)
When a user fills out the form, a row is automatically added to Google Sheets.
I connected Google Sheets to Pabbly.
In Pabbly Workflows I connected Google Sheets (1. Google Sheets: new or updated spreadsheet row) to WhatsApp Cloud API (2. WhatsApp Cloud API: send template message).

When I fill out the form, the phone number appears with the symbol ' before the area code ('+39). This creates problems for me with Pabbly because the phone number is not formatted correctly and it is not possible to send messages.
If I manually fill out Google Sheets everything works regularly. The number is sent to Pabbly and the messages are sent immediately.

I need to understand if there is an automation to add in the Pabbly workflow that allows me to "clean" the phone number from symbols that do not allow the automatic sending of WhatsApp messages. I tried to do this work directly on google sheets but I didn't get any results.

I created the connection between google sheets and Pabbly correctly. As I said above, if I fill out google sheets manually I receive whatsapp messages without any problem.

Can anyone help me solve it?
I attach screenshot
Thanks in advance!

 

[Preeti Paryani]

Hello @areamarketer

Please provide us with the workflow URL so we can better look into the issue and assist you accordingly.

 

[areamarketer]

Hi, thanks for the reply.
I'll insert the link of Pabbly, ok?

Pabbly - Online Marketing & Sales Software

Automate your sales and marketing with Pabbly. Unite email marketing, lead capture, WordPress themes, subscription all at one place.

connect.pabbly.com

 

[Preeti Paryani]

Hello @areamarketer

Please try adding a Number Formatter step to your workflow and set the action event to Spreadsheet Formula. Refer to the attached screenshot for guidance. Map the phone number from this step to the WhatsApp Send Message step and test the workflow.

Let us know if this resolves the issue or if you need further assistance!

 

[areamarketer]

Hi, thanks for your reply. Can you explain in simpler terms? I'm afraid I don't understand well. Thank you so much for your support.

 

[Preeti Paryani]

Hello @areamarketer

This step uses a Spreadsheet Formula called RIGHT, which extracts the 11 rightmost characters from the phone number. Since your number had a space, I’ve set the formula to return 11 characters to ensure proper formatting.

Please make sure to map the number returned by this step into the WhatsApp Send Message action. Once you've performed some tests, let us know if it works as expected or if you encounter any further issues. We're here to help if you need additional assistance!

 

[areamarketer]

I changed the value from 11 to 14 because the area code was missing.

RIGHT('39 392 1234567', 14)

It still doesn't work. I'll try to review everything again.

In the meantime, is there a way to remove the spaces from the phone number?

 

[areamarketer]

Hi, I tried everything. The whatsapp message is sent automatically only if I manually enter the data in the Google Sheets rows. If I use an automated method to fill in the google sheets rows, whatsapp messages are not sent. I really don't know how to solve it.

 

[Preeti Paryani]

Hello @areamarketer

You can replace the spaces {{space}} by replacing them with blank {{blank}}, refer to the attached screenshot for more info.

To make automation work, you need to enable 'Send On Event' if you're manually entering data into your Google Sheets. If the data added to your Google Sheets comes from another API or third-party application, you also need to enable 'Auto Send on Schedule'.

Note: If your data is being added from an external source/API, your workflow will take up to 1 hour to get triggered.

 

[areamarketer]

Hi, thanks for your reply.
Unfortunately if google sheets is compiled, I still do not receive whatsapp messages automatically.
I can not find the problem.

Pabbly

connect.pabbly.com

I tried everything. I also recreated the workflow from scratch.

Thank you in advance.

 

[Preeti Paryani]

Hello @areamarketer

We have created a detailed explanation video addressing your concerns. Please review the video at the following link: https://www.loom.com/share/50dc18147ff94453b1a5b3136648c305?sid=b786c64c-dace-4d5e-81f4-c55e2d06cb18.

Based on the explanation, we recommend setting up a new workflow from scratch rather than cloning the existing one to avoid any potential issues.