Email automation search row double output

How To
1

Hi everyone,

I’m having some challenge with finalizing my email automation. Hope someone can help.

The Goal:

This scenario is an email automation that sends a response based on the lead’s input.

I have a scenario where the trigger monitors new emails and funnels them accordingly. The goal is for the scenario to recognize whether a response has been sent in the inbox on a given day. This is then compared with a matching email and whether this person has already received an initial email.

If a response has been received, it should be checked to determine what the response is and whether the person has chosen Option 1, Option 2, or Option 3.

If no response is received and it has been two days since the first email was sent, a follow-up email should be triggered.

The Issue:

Is that a response currently appears twice. It seems that the first search row module duplicates the output. Two operations are being executed, each with two bundles.

Is it possible to get unique bundles? The problem then escalates further because the ChatGPT module processes a duplicate response.

Scherm­afbeelding 2025-03-20 om 16.56.59
Scherm­afbeelding 2025-03-20 om 16.56.591142×848 104 KB

3

If you are only checking to see if it already exists in Google Sheets, simply set the Bundle Limit to 1.

583×409 43.5 KB

If you want the latest item, sort by row number.

583×354 39.3 KB

Then, in filters you can use the “Total Number of Bundles” variable to check if there are results/it already exists.

571×408 41.8 KB

For more information, see the Google Sheets page in the Make Help Centre, which covers the following:

  • Connect Google Sheets to Make
  • Set Up Google Sheets Webhooks
  • Build Google Sheets Scenarios
  • Tips & Tricks
  • Usage Limits

and also,

  • Create and configure a Google Cloud Platform project for Google Sheets
  • Sheets
  • Rows
  • Cells
  • Deleting Multiple Rows
  • How to Get Empty Cells from a Google Sheet
  • Add a Custom Button in a Sheet to Trigger a Scenario
  • Storing Dates in a Spreadsheet
  • Exploiting Google Sheets Functions
  • How to perform a custom function?
  • Posting and Getting Images from Google Sheets

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

— @samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

4

Hi Samliew,

Thank you for your reply. If I set the limit to 1 it only gives this 1 result twice.

I Also updated the blueprint

blueprint (3).json (476.9 KB)