Workflow Not Working - Scheduler

[zest83]

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

Scheduler is set to Execute at 2.29 AM UTC

There were more 8 Tasks to be sent but they were not triggered as per todays Date - 24th May 2022

11:00 AM
11:15 AM
11:30 AM
11:45 AM
11:10 AM

1:53 PM
2:33 PM
2:00 PM

Only 1 Task was triggered
Task ID: IjE1Mzg0MjIxOCI_3D

The messages were not executed as per the time in the Google Sheet as per Todays Date

Please check Attachment



What do I do?

 

[Pabblymember11]

Hey @zest83

Kindly review your history log first with the action step which you are having in your workflow. According to your workflow, the date which you are passing in the Delay Until actions step is the old date from now.

Since the date is an old Delay Until the action step will not work.

 

[zest83]

But this sheet was working earlier!

I need to save & send test request... everytime I add new "date" to the sheet?

 

[zest83]

Does that make sense?

Coz Every time, I had new dates... Obviously, the Delay Date will show the OLDER date... because the test was done on a Older Date...

So what am I missing here?

 

[zest83]

Please could you check the workflow and tell me if the NEW - Send & test will work properly for the event tomorrow at 1.53 PM - Indian Standard Time

Request you to reply before 12 NOON - so I can improve the workflow as per your suggestions, if any!

 

[zest83]

This one workflow is getting very annoying.
Please check, there's something seriously wrong!

It works and then it stops!

Why does it stop randomly when we add new data to the Google Sheet with New Dates?

The SEND and Test was done during the testing phase and hence the date showed "the previous date" in the delay section - That's obvious isn't it...

What am I doing wrong here?

 

[zest83]

I am checking

MY IST to UTC time converter is showing wrong!

Google Sheet has Time input as 11 AM on 25th May 2022
11 AM IST is showing as 6:30 PM UTC

It should show up as 6:00 AM UTC

 

[zest83]

 

[zest83]

This Step is not making sense....

How is the sheet picking up the RESULT as 2022-05-24 18:30

When the time being fetched from the Google Sheet is 2022-05-25 11:30 (11.30 AM)

Also the Scheduler is set to trigger at 5.59 AM

 

[Pabblymember11]

Hey @zest83

What am I doing wrong here?

As per your workflow, all the designated dates are getting forward to the Delay Until action step, kindly correct the workflow which will only forward the date has the current date or date of the future.

 

[zest83]

We have done what you are saying!


The workflow works perfect after we do a SAVE & SEND TEST REQUEST for the 1st upcoming date!

And then fails for the next schedule date on the same google sheet

 

[Pabblymember11]

Hey @zest83

Please check the following thread for your similar workflow query.

Task Issue

https://connect.pabbly.com/task/history?filter_status=applied&filter_by_workflow_id=IjM1MTM0OSI_3D Please check this task History! The LAST STEP has not completed. The trigger time was 11.10 AM... All Steps are working perfect -- the previous one's executed correctly as well You will...

forum.pabbly.com

 

[zest83]

CLOSE This Thread please