Workflow Not Working - Scheduler

Status: Closed · Asked by zest83 on · 0 views

zest83 — Question ·
https://connect.pabbly.com/workflow/mapping/IjM1MTM0OSI_3D

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?

Attachments

Scheduler Tasks.PNG
Pabblymember11 — Reply ·

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 — Reply ·

But this sheet was working earlier!

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

zest83 — Reply ·

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 — Reply ·

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 — Reply ·

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 — Reply ·
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 — Reply ·
zest83 — Reply ·

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 — Reply ·

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 — Reply ·

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

zest83 — Reply ·

CLOSE This Thread please

Back to all forum threads · Log in to reply