
#1895-Webhook Workflow - Failed Messages Handling
Hello Team,
I am calling a webhook workflow from a Google Sheet. Each column is calling a different workflow, which is sending its different message template.
Now, the problem is that so many messages are not being delivered, but in Google Sheets, they remain as sent.
Shall there be any mechanism to identify whether the message was sent or not?
Solution #1:
Give an option to resend the failed messages. This requires manual management.
Solution #2 Use case:
As we are building an automation platform, this solution shall serve the purpose of importance.
There should be an API to get webhook workflow reports. If I can get a failed messages report for a Webhook URL, I can create a time-based trigger in Google Sheets, which will call the webhook URL report API and receive a list of failed messages. Then, I can use that data to resend WhatsApp messages to only failed numbers using App Script Code. This way, I can eliminate the need for manual work. My Google sheet can send failed messages again after 24 hours.
Example format: example.com/webhook-workflow-report?url=webhook_url&only-latest=true&status=failed (failed/success/all)
Parameters:
url -- to identify which webhook's report is being requestedonly-latest -- in order to above use case to fulfilled, I will only need the latest log for one phone number (if two logs are there for a phone number, check only the latest one to identify if the message attempt was failed or not)status -- this can define whether I only need failed messages or success messages, or allTHIS WILL OPEN NEW POSSIBILITIES OF FULLY AUTONOMOUS AUTOMATION
Hello
You can assign a label to the number after the webhook.
Then, use another script to check if number X has the label. If it doesn't, then nothing has been sent. Then schedule a new send.