Search returns no results, but scenario continues to next module

[Philippe_GRANDFOND]

What is your goal?

I want to send an email via Brevo using data from Google Sheets.

What is the problem?

When I have a new row in Google Sheets, sending via Brevo works (and adds the number 1 to a field in the row concerned). When an email address or date is missing (mandatory conditions: existing email, existing date, date entered = current date, field not containing the number 1), it should not attempt to send.

What have you tried so far?

The scenario (Make) launches even when the conditions are not met, which causes errors because the data required to send the email is missing. The scenario ends up being automatically deactivated.

Screenshots: scenario setup, module configuration, errors

Integration Google Sheets.blueprint(2).json (88.8 KB)

[Stoyan_Vatov]

Hey Philippe,

Screenshots work better than sharing the scenario. Can you show what triggers the scenario?

[samliew]

Welcome to the Make community!

We’d love to help, however, we require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors.

To allow others to assist you, please provide the following:

1. All Relevant Screenshots

We need to see what you’re working with to give you the best advice. Screenshots are important because Make is a visual editor — a picture provides us with more context.

It would help us identify the issue by having screenshots of:

• the full scenario, and the zoomed in parts of the scenario that you are referring to (if your scenario is huge),
• a full scenario run/execution from the history (showing output “speech” bubbles),
• relevant module fields (showing how you’ve used any built-in functions, and how you’ve mapped the variables),
• relevant filters between modules (showing which operators and any built-in functions you’ve used, and how you’ve mapped the variables),
• relevant module input/output bubbles,
• if applicable, any error messages,
• and if applicable, any external services (spreadsheet headers/ sample data/ regex101.com/ etc. to show the item/ record exists, and is set up correctly).

Need help❓View instructions ◀

We would appreciate it if you could directly upload screenshots here instead of linking to them outside of this forum. This allows us to zoom in on the image when clicked, and also having improved privacy from third-party sources.

Taking Screenshots

• Microsoft Windows: Take screenshots using the “Windows Snipping Tool”, by pressing either PrtSc or WinShiftS keys on your keyboard.
• MacOS: Take screenshots by pressing CommandShift4 keys on your keyboard.

Uploading Attachments

• Drag image files directly into the rich-text editor, or
• Click on the upload button in the editor toolbar to select files:
  

3. Properly-formatted Output Bundles from a Scenario Run

Please provide the input/output bundles of each of the relevant modules by running the scenario, or get the bundles from a previous run from the Scenario “History” tab.

Providing the bundles from a scenario run will allow others to replicate what is going on, especially if there are complex data structures (nested arrays and collections) and external services. This helps mapping the correct raw variable names from collections (instead of the label/display name).

Need help❓View instructions ◀

Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.

A. Upload a Text File

Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.

• You can upload files and images to this forum by clicking on the upload button:
  

  Uploading an attachment here will look like this:
  module1-input.txt (1.2 KB)
  module1-output.txt (3.4 KB)

B. Insert a Formatted Code Block

If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.

_{Formatting IS Important!}

Here are some ways to provide text content in a way that it won’t be modified by the forum.

• Method 1: Type code fence manually —
  Manually type three backticks ``` in a separate line before and after the content, like this,

  ```
  text goes here
  ```
  

• Method 2: Highlight the pasted content, then click the preformatted text/code button —
  

• Method 3: Upload your file elsewhere and share the public link —
  This method is only advised for large files exceeding the forum upload limit.

Sharing these details will make it easier for others to assist you, so that you can get better answers, faster.

— @samliew

[Philippe_GRANDFOND]

[Stoyan_Vatov]

Can you check the output of the search module?

[Philippe_GRANDFOND]

[Stoyan_Vatov]

So it didn’t find anything. Easiest will be to add a filter after the search module to check if there is output.

[samliew]

Make Academy

You can learn more about filters in these Make Academy units:

Expanding my first scenario

• Adding a Router
• Adding a Filter
• More options with Filters
• Overview of scheduling
• Run once

— @samliew