Pabbly Workflow with Iterator & Filter is Not Processing All WhatsApp Messages from Google Sheets

Hi Team,

We have created two scheduled workflows in Pabbly Connect:

• Workflow 1: Runs every Tuesday
• Workflow 2: Runs every Wednesday

Both workflows use the following logic:

1. 
   Fetch data from a Google Sheet.
2. Use an Iterator to process each row individually.
3. Apply a Filter condition to continue only if the value is greater than 0.
4. Send a WhatsApp message to each qualifying contact.

The workflows are executing as scheduled, but they are not sending WhatsApp messages to all eligible records in the Google Sheet. Only some contacts receive the messages, while others that meet the filter condition are skipped.

We have verified that:

• The Google Sheet contains valid data.
• The Iterator and Filter are configured correctly.
• The workflows are scheduled and triggering successfully.

Could you please help us identify why the Iterator is not processing all rows or why some WhatsApp messages are being skipped?

Kindly review the workflow execution logs and let us know if there are any limitations, configuration issues, or errors causing this behavior.

Thank you.

Hello,

Thank you for providing the workflow details.

Upon inspecting your task history logs, we observed that Pabbly Connect successfully processed all the rows and received a Success (200) response code from the WhatsApp API action step for each contact. The API returned Message_status: queued along with a valid Message Queue_id (e.g., 408b5dee-4e65-4b15-89c0-3c483960e773).

Since Pabbly Connect is successfully handing over the message payload to your WhatsApp API provider without any step failures, the messages are being queued on their end.

Could you please check your WhatsApp API provider's dashboard/software panel to see if there are any errors, rate limits, template rejections, or account-level restrictions being logged when delivering these queued messages?

Looking forward to your update so we can help resolve this further.

You can check it has iteration issue

Some of my Iteration Steps is not working

Hello,

Thank you for your response.

We re-inspected your execution logs in detail for Task History ID IjU3NjYwNTZjMDYzMTA0MzA1MjZkNTUzNTUxMzQ1MTYxNTQzMjBmMzgi_pc.

The Iterator step ran successfully and processed 945 iterations. However, the Gmail step failed due to an error in your Gmail step:

• Error: 429 - Too many concurrent requests for user / rateLimitExceeded

• Cause: Gmail has strict rate limits on how many emails can be sent concurrently within a short timeframe. When sending emails rapidly inside a high-volume loop, Gmail blocks further requests, which causes the workflow execution to stop at that iteration.

Because the Gmail step failed due to rate limits, the execution stopped, which is why the subsequent iterations were not completed and messages beyond row 945 were skipped..

Recommended Fix:

To prevent Gmail rate limiting from stopping your Iterator workflow:

1. Increase the Delay duration: Increase the time in your Delay by Pabbly step (placed before or after the Gmail step inside the Iterator loop) to spread out the email sending rate.

2. Use Pabbly Email Marketing or SMTP: For sending bulk/scheduled emails across hundreds of rows, we recommend using Email by Pabbly or an SMTP service (such as Amazon SES, SendGrid, etc.) rather than a standard Gmail/Google Workspace account, as Gmail is not designed for high-frequency automated batch emailing.

Once you adjust the delay or switch the email action, you can re-execute the workflow.

Please let us know if you need any further assistance!

Hi Can we connect on Google Meet.

I can explain you in detail

Or can you call me on : 9930761964 so that i can explain

Hello,

Thank you for speaking with us on the call.

As discussed, could you please share a few specific phone numbers of the contacts who did not receive the WhatsApp messages, along with the date/time of the run?

Once you provide those sample numbers, we will investigate the logs for those specific records and check what happened.

Looking forward to your response!

Hello,
To better understand your issue and your specific use case, we would like to schedule a call with you. You can pick a convenient time slot using the following link:
👉 Schedule a Support Call: https://www.draftmeet.com/book/lnk_bc545a34158067325eef38c80706f817
Once scheduled, we’ll discuss your workflow in detail and provide guidance to resolve the issue efficiently.
Looking forward to speaking with you.

Hello Ninad,

Thank you for your response!

We joined the scheduled Google Meet support call and waited for you as well, but it seems there was a connection issue or miscommunication that prevented us from connecting.

To assist you with the workflow issue we discussed earlier, I have created a modified flow directly inside your Pabbly Connect account to resolve the behavior. Please check your account to review the setup.

If you would still like to connect on a call to review the workflow together, kindly schedule a new time slot using the updated link below:

👉 Schedule a Support Call

Looking forward to assisting you further!