Google Sheets to Interact WhatsApp API + Routing delay days

Hi,

My Google Sheets are getting added with customer data in Sheet1=Main Sheet, now i have given the formula to divide the data into days the customer registered. (Sheet2=Monday), (Sheet3=Tuesday), (Sheet4=Wednesday)......, Now, I want to send specific messages to people who register each day. i have configured it now, but when i see the history, the data is not getting captured. getting random numbers captured and WhatsApp API (Task History) states "Please correct the following error - Either 'phoneNumber' with 'countryCode' Or 'fullPhoneNumber' is required"

Regards
Ashwin Babulkar

Hi @Rekha Babulkar,

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 any formula is added to the trigger column of the Google Sheet, then automation will not work.

Hi @Rekha Babulkar,

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 any formula is added to the trigger column of the Google Sheet, then automation will not work.

[TABLE]
[TR]
[TD]Date[/TD]
[TD]Name[/TD]
[TD]Email Address[/TD]
[TD]Phone Number[/TD]
[/TR]
[TR]
[TD]Sun Jul 28 12:20[/TD]
[TD]Ashwin BaXXXkar[/TD]
[TD][email hidden][/TD]
[TD]9186XXXX0760[/TD]
[/TR]
[/TABLE]

Hey @Rekha Babulkar !

In case you want to send data further by matching the dates, then you can check on this video tutorial for your reference-

youtube.com/watch?v=uYsk7WDQvlY

This can work for you.

Hey @Rekha Babulkar !

In case you want to send data further by matching the dates, then you can check on this video tutorial for your reference-

youtube.com/watch?v=uYsk7WDQvlY

This can work for you.

Here is my scenario: I have webinars scheduled on Wednesdays and Saturdays. If someone registers on Sunday, they should receive a welcome message, followed by a "3 days to go!" reminder. This sequence continues with a "2 days to go!" reminder sent a day later and a "Tomorrow is the day!" reminder sent two days later. On the day of the webinar (Wednesday), the users receive two reminder messages to join the webinar LIVE at 7pm.

For those who register on Thursday, they will receive a "2 days to go!" message, a "1 day to go!" message, and a "Today is the webinar!" message leading up to Saturday morning. I hope this clarifies my automation setup.

Hey @Rekha Babulkar !

As per your use case, you need to setup two workflows, one for Wednesday and one for Saturday.

You can refer to this video tutorial for the same-

youtube.com/watch?v=udp3ZyyMMsk:1705

This will work for you.