How to send email to each bundle output from Search Rows in Google Sheet

[Tiju_Mathew]

What are you trying to achieve?

Hi All,

I am just getting started with make.com. My purpose is to schedule a reminder email (every day or two) to all those who have payment status Not equal to ‘Paid’ in google sheet.
My trigger ‘Google Sheet Search Row’ criteria has given 5 bundles of output that has customers unpaid.

Now to send email to each members with their amount to pay, I need to map the data for each member and send separate emails. But it looks like the Gmail is mapping only first bundle instead of each at a time. Am I reading it wrong?

Also, it would be great, If I can have a condition that - > If a person is sent an email and still not paid, then sent a different email warming it up.

Please help me find out the right way to achieve this.

Thanks

Steps taken so far

Already have google sheets with the customer name, email id, amount to pay, payment status (INvoice Paid , Paid)
Created a scenario with Search Row trigger

Screenshots: scenario setup, module configuration, errors

[samliew]

Welcome to the Make community!

Simply put, you need a column to track which users have been sent each email.

So if you want to know which users have been sent an email, you need to add additional two columns, where you can update after each sent email.

Hope this helps! Let me know if there are any further questions or issues.

— @samliew

If you need further assistance, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

You can upload images here using the Upload icon in the text editor:

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

A. Upload as Text File

Save each bundle contents in your text editor as a bundle.txt file, and upload it here into this discussion thread.

B. Insert as Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the formatted bundles.
These are the two ways to format text so that it won’t be modified by the forum:

• Method 1: Type code block manually

  Add three backticks ``` before and after the content/bundle, like this:

  ```
  <sup>content goes here</sup>
  ```

• Method 2. Highlight and click the format button in the editor

  

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

[Tiju_Mathew]

Thank you for your response.

Further, my question was:

How to set the condition that: If all search results (bundles) from Search row trigger has Payment Status ‘Not Paid’ then Sent email to each of those customers.

Right now what I can see is the first bundle that can be mapped.

blueprint.json (40.1 KB)

From