Send Multiple Emails from G Sheet using Gmail

[umpl]

Your Task History ID

IjU3NjUwNTZiMDYzNDA0MzE1MjY4NTUzNTUxMzI1MTZhNTQzNTBmMzIi_pc

Below is what I want to accomplish:

I have a google sheet with client deadlines (date).
Everyday the scheduler checks clients whose deadline is on that day.
It filters them out. Let's say 10 clients with deadline today.
Now I want to send these client reminder emails.
I am using Gmail to do this. But Gmail is sending email to only first entry.
I want it to iterate and send reminder email to all entries with a deadline today.

Below is my flow:

 

[Preeti Paryani]

Hello @umpl,

Please capture the response in advanced format from the Google Sheets action by turning off the Simple Response toggle. Then, add the Iterator by Pabbly step, followed by the Gmail action. Map the values from the Iterator in the Gmail step.

This way, the automation will process all clients and send reminder emails to each of them. Kindly note, when you click Save & Send Test Request in the builder, the email will be sent only to the first entry, but during live execution it will send to all.