Can an approval row stop duplicate publishing when a workflow retries?
Status: Open · Asked by Jayne on · 0 views
I am looking at Pabbly Connect for an editorial review queue for MedProofs. Our health news section is still empty, so this is a setup question, not a failed live workflow.
The idea is a Google Sheets row with a source URL, draft ID and reviewer status. Only an approved row should move to publishing. I'd like to keep the actual review seperate from automation.
What I'm unsure about is retries.. If the publishing step succeeds but writing the result back to Sheets fails, could another run publish same draft again? A filter on approved status alone doesnt seem enough.
Would you use a stored draft ID plus a published timestamp, or is there a better way in Connect to make that check? also, if two runs pick up the row together, how do you keep them from both continuing? I havent built this yet and would rather settle that part first
Hello!
Thanks for explaining your use case.
To understand how this can be implemented in Pabbly Connect and suggest the best approach for handling retries and preventing duplicate publishing, we would first need to understand the exact workflow setup you have in mind.
Since the workflow has not been built yet, could you please share the apps you plan to integrate and the steps you want the workflow to perform, from the Google Sheets trigger through the publishing step?
If possible, you can also share a screenshot or a brief description of the workflow steps you are planning to use. Once we have these details, we can review the setup and guide you on how to handle the approval check, retries, and prevent the same draft from being published more than once.
Thanks & Regards,
Soumya Tripathi
Customer Support Lead
🌐 Pabbly.com