I set workflow but it sheet not respond

[safargenie]

Your Task History ID

1

Hello Sir/ Ma'am
I set a workflow with whatsapp Api & google sheet. I want that when customer trip will start then before 1 day google sheet respond to customer whatsapp msg. I set workflow but it sheet not respond kindly check it and help us.
We provide our google sheet link Click Here & check
Our Google Sheet
Pabbly work flow check it

https://connect.pabbly.com/workflow/share/WBBRYwdQA2AASgRuUQ5XcFpOBwMDWlY0UElWRAcIUSkGSFMoUBEMZgtHBCYDRANiXhdQOgJeAzsMGFdTBlBTIF1HABJcX1AqWxYCeQVUW2hYBlF5B2Y#​

 

[Luv]

Hello @safargenie

It appears that the Delay date you entered is not in correct format. Kindly refer to the image below,

For rectifying this issue, you can use Date/Time Formatter to Format Date and Time Zone and the use that response in the delay. You can do the same as mentioned in the image below.

You can learn more about Date/Time Formatter here -

Let us know if this works for you.

 

[safargenie]

I'm Again try but it is not work please check it :

https://connect.pabbly.com/workflow...NDTVcSAEFCF5TIFJIAhBVVlAqVRhWLQZXDzxaBAIqAGE#

Sheet: https://connect.pabbly.com/workflow...NDTVcSAEFCF5TIFJIAhBVVlAqVRhWLQZXDzxaBAIqAGE#

 

[safargenie]

Dear Team,

I have been trying to do the steps advised by you. But things are not moving. I am sharing you the link of Workflow. Kindly check & advise.

Work Flow Link : https://connect.pabbly.com/workflow...aAztfSwEFAlQGdVBKUUNSUVQuUx4DeFMCCzgKVAcvUTA#

Google Sheet Link : https://docs.google.com/spreadsheets/d/1XqUCcyyVOKKgSczBq5CsGQIlNtOR6VhFT2lstGfrz8M/edit?usp=sharing

Thanks & Regards
Rahul.

 

[safargenie]

Dear Team,

I have been trying to do the steps advised by you. But things are not moving. I am sharing you the link of Workflow. Kindly check & advise.

Work Flow Link : https://connect.pabbly.com/workflow...aAztfSwEFAlQGdVBKUUNSUVQuUx4DeFMCCzgKVAcvUTA#

Google Sheet Link : https://docs.google.com/spreadsheets/d/1XqUCcyyVOKKgSczBq5CsGQIlNtOR6VhFT2lstGfrz8M/edit?usp=sharing

Thanks & Regards
Rahul.

 

[Luv]

Hey @safargenie

We have made a few changes in your workflow according to your requirement. Kindly make a few test entries for tomorrow or day after tomorrow and let us know if you get the messages delivered in time.

Awaiting your positive response.

 

[safargenie]

No. we are not found any positive result. Please try again.
Please Check again

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

Google Sheet

Allready Booked Client

docs.google.com

 

[Preeti Paryani]

Hello @safargenie

As we have checked on our end we have noticed that after subtracting one day from the trip start date, the calculated date and time falls before the workflow trigger time.

As a result, the message can't be sent further. Please refer to the attached screenshot for more information.