How can I report bounced mails due to address not found etc from my gmail to my spreadsheet

[Victory_Tasktide]

What is your goal?

I want the mails that were sent out from my spreadsheet if bounced back or when bounced back due to invalid address etc to report as No in contacted column in my spreadsheet

What is the problem?

Only the watch emails module runs while the get email and others don’t

What have you tried so far?

I’ve tried text parser according to Ai but still to no avail, had to unlink them to try without it still nothing

Screenshots: scenario setup, module configuration, errors

[Karmic]

Please upload screenshots of your execution logs and include what settings you’re currently using in your modules. Thank you!

[Victory_Tasktide]

I first started with the Gmail (watch emails ) module, configure it to my Gmail account, Gmail filter, query I inputted subject: Delivery failed or Mail delivery failed. Then I linked it to the get email module, configured it to my email and the message id I mapped it from watch emails MESSAGE ID. Then I selected google sheets (search rows) configured it to my account and sheets, below I used the filter section, selected email column EQUAL TO I mapped the FROM EMAIL from get email module. Then I linked google sheets (update a row), configured it to my account and sheet, selected the row number and in the values I went to column that has Contacted and inputted No. the text parser is unlinked from all, same as iterator because I got confused and stuck

[Karmic]

Please upload a screenshot of the module settings itself. I can’t troubleshoot it properly if you won’t send it in.

[Victory_Tasktide]

Gmail-Watch emails

Gmail- Get email

Google sheets - Search rows

Google sheets-update rows

[Karmic]

Do you have bounced emails on your current email? Because if you don’t have one in your mailbox, It won’t proceed to get an email.

You can improve your Gmail (Watch Emails) module Query:
subject:(“Delivery Status Notification” OR “Delivery failed” OR “Undeliverable” OR “Mail delivery failed”)

Sorry for the late reply!

[Victory_Tasktide]

Yes I do have bounced emails and I can send more to myself and run it again for testing.

Okay, I will update my query now and give you the results

[Victory_Tasktide]

Hello, thanks for the assisting

I ran the updated query and all the modules ran except update a row which got me this error below, unlike my original request where only the watch email ran and stopped .

[Karmic]

Have you mapped the Row Number from Search Rows? Please show me how your full scenario looks like. Thanks!

[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).

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.

How to Take Proper Screenshots

Please do not use your phone to take a photograph of your screen!

• 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.

2. Scenario Blueprint

Providing your scenario will allow others to quickly recreate and see how you have set up the mappings in each module, and also allows us take screenshots or provide module exports of any solutions we have for you in return. This would benefit you in implementing our suggestions as you can view screenshots of the changes or paste corrected modules back into your scenario.

Need help❓View instructions ◀

A. Export Blueprint

In the scenario editor, click the three dots at the top-right, then select “Export blueprint”.

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

  Uploading an attachment here will look like this:
  blueprint.json (12.3 KB)

B. Create Public Share Link

In the scenario editor, click on the Share button:

Read more about the scenario sharing feature in the Help Centre.

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.

Hope this helps! If you are still having trouble, please provide more details.

— @samliew