My automation keep emailing the same emails the same thing

How To
1

Screenshot 2025-04-02 at 12.38.41 PM
Screenshot 2025-04-02 at 12.38.41 PM1920×1200 83 KB

Screenshot 2025-04-02 at 12.40.40 PM
Screenshot 2025-04-02 at 12.40.40 PM1920×1200 110 KB

Screenshot 2025-04-02 at 12.40.51 PM
Screenshot 2025-04-02 at 12.40.51 PM1920×1200 102 KB

Screenshot 2025-04-02 at 12.41.17 PM
Screenshot 2025-04-02 at 12.41.17 PM1920×1200 97.2 KB

So Goal: searches for all with specific status’s and ‘records’ field ‘Does not contain’ “HTML Sent”.

sends email, and changes the ‘records’ field to “HTML Sent”.

That should end the cycle! SHouldn’t it?

But I have had that same email, repetitively sending to the same emails, even though they have “HTML Sent” in the ‘records’ field. Very frustrating.

I even added a filter after the first module to ensure they wouldn’t get through. But they are. How can I fix this? Any help appreciated to help me understand what I have done wrong.

Summer

2

Hi @summer1

  1. Please share the JSON output of the Search Objects module.
  2. This filter is not working because you’re filtering an array of records, not a specific record.
    image
    image430×267 33.6 KB
3

[
{
“object”: “page”,
“id”: “16942418-10b8-803c-b67c-cc4acf3108b7”,
“created_time”: “2024-12-27T07:15:00.000Z”,
“last_edited_time”: “2025-04-03T00:35:00.000Z”,
“created_by”: {
“object”: “user”,
“id”: “b94a227b-2ddb-4f4e-9279-71e182f7724f”
},
“last_edited_by”: {
“object”: “user”,
“id”: “b94a227b-2ddb-4f4e-9279-71e182f7724f”
},
“cover”: null,
“icon”: null,
“parent”: {
“type”: “database_id”,
“database_id”: “9e22d109-412c-4e44-a031-dabab788bc03”
},
“archived”: false,
“in_trash”: false,
“properties”: [
{
“id”: “A%3Eml”,
“type”: “checkbox”,
“checkbox”: false,
“label”: “Connected on linkedin”
},
{
“id”: “I%3EHD”,
“type”: “multi_select”,
“multi_select”: [
{
“id”: “Pr>h”,
“name”: “Architect”,
“color”: “purple”
}
],
“label”: “Business Type”
},
{
“id”: “ISzp”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Error Make.com”
},
{
“id”: “JH%40a”,
“type”: “select”,
“select”: {
“id”: “52410078-f985-41bf-a1bb-d51a29ae9dd7”,
“name”: “SB”,
“color”: “blue”
},
“label”: “By Who”
},
{
“id”: “Jwg%7B”,
“type”: “date”,
“date”: {
“start”: “2025-04-01”,
“end”: null,
“time_zone”: null
},
“label”: “Last Contacted”
},
{
“id”: “NWfy”,
“type”: “phone_number”,
“phone_number”: null,
“label”: “Phone”
},
{
“id”: “OJtH”,
“type”: “select”,
“select”: {
“id”: “TV?O”,
“name”: “Sent”,
“color”: “green”
},
“label”: “01/04 Marketing email stage”
},
{
“id”: “TX_%40”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Commercial”
},
{
“id”: “TwYT”,
“type”: “email”,
“email”: “summer@pt.digital”,
“label”: “Email”
},
{
“id”: “%5BMdm”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Role”
},
{
“id”: “%5EQfp”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Residential”
},
{
“id”: “aLgk”,
“type”: “select”,
“select”: {
“id”: “mxHQ”,
“name”: “Awaiting Reply”,
“color”: “orange”
},
“label”: “Status”
},
{
“id”: “oY%40%3E”,
“type”: “rich_text”,
“rich_text”: ,
“label”: "Practice "
},
{
“id”: “oncp”,
“type”: “files”,
“files”: ,
“label”: “Profile”
},
{
“id”: “qBJf”,
“type”: “date”,
“date”: {
“start”: “2025-01-16”,
“end”: null,
“time_zone”: null
},
“label”: “Contact Made”
},
{
“id”: “uTFD”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Records”
},
{
“id”: “wA%7C%7B”,
“type”: “url”,
“url”: null,
“label”: “Website”
},
{
“id”: “%7BEye”,
“type”: “url”,
“url”: null,
“label”: “Linkedin”
},
{
“id”: “title”,
“type”: “title”,
“title”: [
{
“type”: “text”,
“text”: {
“content”: “Summer-louise Bevan”,
“link”: null
},
“annotations”: {
“bold”: false,
“italic”: false,
“strikethrough”: false,
“underline”: false,
“code”: false,
“color”: “default”
},
“plain_text”: “Summer-louise Bevan”,
“href”: null
}
],
“label”: “Person”
},
{
“id”: “0ae4d2f4-b9b3-4bc7-a121-81b1c2969816”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Notes”
},
{
“id”: “46b34914-d9a1-4b01-8a65-e9befc3a15f4”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Head office”
},
{
“id”: “9134a533-6e35-4465-9a55-06601605ca4c”,
“type”: “multi_select”,
“multi_select”: ,
“label”: “Location”
},
{
“id”: “f02e15b1-836d-44e7-a901-1735b6dbd50e”,
“type”: “rich_text”,
“rich_text”: ,
“label”: “Local Office”
}
],
“url”: “https://www.notion.so/Summer-louise-Bevan-1694241810b8803cb67ccc4acf3108b7”,
“public_url”: null,
“properties_value”: {
“Connected on linkedin”: false,
“Business Type”: [
{
“id”: “Pr>h”,
“name”: “Architect”,
“color”: “purple”
}
],
“Error Make.com”: ,
“By Who”: {
“id”: “52410078-f985-41bf-a1bb-d51a29ae9dd7”,
“name”: “SB”,
“color”: “blue”
},
“Last Contacted”: {
“start”: “2025-04-01”,
“end”: null,
“time_zone”: null
},
“Phone”: null,
“01/04 Marketing email stage”: {
“id”: “TV?O”,
“name”: “Sent”,
“color”: “green”
},
“Commercial”: ,
“Email”: “summer@pt.digital”,
“Role”: ,
“Residential”: ,
“Status”: {
“id”: “mxHQ”,
“name”: “Awaiting Reply”,
“color”: “orange”
},
"Practice ": ,
“Profile”: ,
“Contact Made”: {
“start”: “2025-01-16”,
“end”: null,
“time_zone”: null
},
“Records”: ,
“Website”: null,
“Linkedin”: null,
“Person”: [
{
“type”: “text”,
“text”: {
“content”: “Summer-louise Bevan”,
“link”: null
},
“annotations”: {
“bold”: false,
“italic”: false,
“strikethrough”: false,
“underline”: false,
“code”: false,
“color”: “default”
},
“plain_text”: “Summer-louise Bevan”,
“href”: null
}
],
“Notes”: ,
“Head office”: ,
“Location”: ,
“Local Office”:
},
“IMTLENGTH”: 1,
“IMTINDEX”: 1
}
]

Hey there,
How are you?
Thanks for your help, I have set up another scenario in a similar fashion, and haven’t had this problem. I am not a professional by any means though so I understand I am at fault. I appreciate your advice.

4

Welcome to the Make community!

The above is not valid JSON. You can verify this by copy-pasting into jsonformatter.org

Could you please try providing the output bundle again with the following instructions?

1. This forum might have or already changed your text

When pasting text into this forum, you should format the example text using the rich-text editor, otherwise the forum software might modify the displayed text, and you might get incorrect answers from others because of it.

Some things this forum software might do to mangle your text:

– remove extra spaces (which may be necessary)
– convert links to titles (when copied is incorrect)
– incorrect joined links
– convert single and double quotes to smart angled quotes (“ ”)
– emojis
– etc.

This interferes with you receiving correct answers, because it:

– makes JSON invalid (you can check by copy-pasting into jsonformatter.org)
– makes incorrect text examples when we need to build a pattern for text parsing

2. To prevent this in future, please format text in code blocks

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:

    ```
    content goes here
    ```

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

3. You might need to re-copy the original text

Once the post has been submitted, it’s too late to format it since it’s already butchered, and you need to make a re-copy of the text, and format it before submitting the forum post.

Please let us know once you have corrected the issue. This will avoid others potentially providing wrong answers based on incorrect text in your question.

Thank you!

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.

5 
[
    {
        "object": "page",
        "id": "16942418-10b8-803c-b67c-cc4acf3108b7",
        "created_time": "2024-12-27T07:15:00.000Z",
        "last_edited_time": "2025-04-03T00:35:00.000Z",
        "created_by": {
            "object": "user",
            "id": "b94a227b-2ddb-4f4e-9279-71e182f7724f"
        },
        "last_edited_by": {
            "object": "user",
            "id": "b94a227b-2ddb-4f4e-9279-71e182f7724f"
        },
        "cover": null,
        "icon": null,
        "parent": {
            "type": "database_id",
            "database_id": "9e22d109-412c-4e44-a031-dabab788bc03"
        },
        "archived": false,
        "in_trash": false,
        "properties": [
            {
                "id": "A%3Eml",
                "type": "checkbox",
                "checkbox": false,
                "label": "Connected on linkedin"
            },
            {
                "id": "I%3EHD",
                "type": "multi_select",
                "multi_select": [
                    {
                        "id": "Pr>h",
                        "name": "Architect",
                        "color": "purple"
                    }
                ],
                "label": "Business Type"
            },
            {
                "id": "ISzp",
                "type": "rich_text",
                "rich_text": [],
                "label": "Error Make.com"
            },
            {
                "id": "JH%40a",
                "type": "select",
                "select": {
                    "id": "52410078-f985-41bf-a1bb-d51a29ae9dd7",
                    "name": "SB",
                    "color": "blue"
                },
                "label": "By Who"
            },
            {
                "id": "Jwg%7B",
                "type": "date",
                "date": {
                    "start": "2025-04-01",
                    "end": null,
                    "time_zone": null
                },
                "label": "Last Contacted"
            },
            {
                "id": "NWfy",
                "type": "phone_number",
                "phone_number": null,
                "label": "Phone"
            },
            {
                "id": "OJtH",
                "type": "select",
                "select": {
                    "id": "TV?O",
                    "name": "Sent",
                    "color": "green"
                },
                "label": "01/04 Marketing email stage"
            },
            {
                "id": "TX_%40",
                "type": "rich_text",
                "rich_text": [],
                "label": "Commercial"
            },
            {
                "id": "TwYT",
                "type": "email",
                "email": "summer@pt.digital",
                "label": "Email"
            },
            {
                "id": "%5BMdm",
                "type": "rich_text",
                "rich_text": [],
                "label": "Role"
            },
            {
                "id": "%5EQfp",
                "type": "rich_text",
                "rich_text": [],
                "label": "Residential"
            },
            {
                "id": "aLgk",
                "type": "select",
                "select": {
                    "id": "mxHQ",
                    "name": "Awaiting Reply",
                    "color": "orange"
                },
                "label": "Status"
            },
            {
                "id": "oY%40%3E",
                "type": "rich_text",
                "rich_text": [],
                "label": "Practice "
            },
            {
                "id": "oncp",
                "type": "files",
                "files": [],
                "label": "Profile"
            },
            {
                "id": "qBJf",
                "type": "date",
                "date": {
                    "start": "2025-01-16",
                    "end": null,
                    "time_zone": null
                },
                "label": "Contact Made"
            },
            {
                "id": "uTFD",
                "type": "rich_text",
                "rich_text": [],
                "label": "Records"
            },
            {
                "id": "wA%7C%7B",
                "type": "url",
                "url": null,
                "label": "Website"
            },
            {
                "id": "%7BEye",
                "type": "url",
                "url": null,
                "label": "Linkedin"
            },
            {
                "id": "title",
                "type": "title",
                "title": [
                    {
                        "type": "text",
                        "text": {
                            "content": "Summer-louise Bevan",
                            "link": null
                        },
                        "annotations": {
                            "bold": false,
                            "italic": false,
                            "strikethrough": false,
                            "underline": false,
                            "code": false,
                            "color": "default"
                        },
                        "plain_text": "Summer-louise Bevan",
                        "href": null
                    }
                ],
                "label": "Person"
            },
            {
                "id": "0ae4d2f4-b9b3-4bc7-a121-81b1c2969816",
                "type": "rich_text",
                "rich_text": [],
                "label": "Notes"
            },
            {
                "id": "46b34914-d9a1-4b01-8a65-e9befc3a15f4",
                "type": "rich_text",
                "rich_text": [],
                "label": "Head office"
            },
            {
                "id": "9134a533-6e35-4465-9a55-06601605ca4c",
                "type": "multi_select",
                "multi_select": [],
                "label": "Location"
            },
            {
                "id": "f02e15b1-836d-44e7-a901-1735b6dbd50e",
                "type": "rich_text",
                "rich_text": [],
                "label": "Local Office"
            }
        ],
        "url": "https://www.notion.so/Summer-louise-Bevan-1694241810b8803cb67ccc4acf3108b7",
        "public_url": null,
        "properties_value": {
            "Connected on linkedin": false,
            "Business Type": [
                {
                    "id": "Pr>h",
                    "name": "Architect",
                    "color": "purple"
                }
            ],
            "Error Make.com": [],
            "By Who": {
                "id": "52410078-f985-41bf-a1bb-d51a29ae9dd7",
                "name": "SB",
                "color": "blue"
            },
            "Last Contacted": {
                "start": "2025-04-01",
                "end": null,
                "time_zone": null
            },
            "Phone": null,
            "01/04 Marketing email stage": {
                "id": "TV?O",
                "name": "Sent",
                "color": "green"
            },
            "Commercial": [],
            "Email": "summer@pt.digital",
            "Role": [],
            "Residential": [],
            "Status": {
                "id": "mxHQ",
                "name": "Awaiting Reply",
                "color": "orange"
            },
            "Practice ": [],
            "Profile": [],
            "Contact Made": {
                "start": "2025-01-16",
                "end": null,
                "time_zone": null
            },
            "Records": [],
            "Website": null,
            "Linkedin": null,
            "Person": [
                {
                    "type": "text",
                    "text": {
                        "content": "Summer-louise Bevan",
                        "link": null
                    },
                    "annotations": {
                        "bold": false,
                        "italic": false,
                        "strikethrough": false,
                        "underline": false,
                        "code": false,
                        "color": "default"
                    },
                    "plain_text": "Summer-louise Bevan",
                    "href": null
                }
            ],
            "Notes": [],
            "Head office": [],
            "Location": [],
            "Local Office": []
        },
        "__IMTLENGTH__": 1,
        "__IMTINDEX__": 1
    }
]
6

Hi @summer1

In a Search Objects module, you filter the objects by the role field.

image
image394×699 77.3 KB

If you want to implement the same logic for a Make filter, you should get the value of the Role field first. The filter’s text operator can be Not equal to or Doesn’t contain.
image
image440×228 9.1 KB

Here is a function that you can copy/paste to your Make scenario. Just replace the Role array with the Role array from the Search Objects module.
{{first(map(17.properties_value.Role; “name”))}}

1 Like
7

OH MY GOODNESS! that was a mistake! I was meant to filter by Records (Rich Text) not Role! I had the filter set up with some as role and some as records. Do you think my scenario should work if I change that field from role to records? That should resolve the problem I had right?

it makes sense then, that it was sending the same emails to the same people, because the “HTML Sent” status was being put in the records field at the end of the scenario, and I had mistakenly specified the ‘role’ field from me CRM which naturally, didn’t have “HTML Sent”.
but if I had ‘record’ there, it would of caught it and stopped it.

That logic makes sense right?

thank you for pointing that out.

8

Hi @summer1

Yes, updating the filter field from role to records should do the trick.