Google sheet update check for each value found

Hello

Still enjoying using N8N even it’s a challenge for mewith my poor knowledge of coding.

Describe the issue/error/question

The same as the title as I would like to update cells in google sheet every email found
I have simulated my mailbox where all emails need to be found by two sets in this test.

What is the error message (if any)?

The flow work for the only first one found
The node “GSheets_checkmail” find the first one and stop with it to update the correct cell
How could I have all found email ?

Please share the workflow

Share the output returned by the last node

This is the result:

[
{
"email": "300",
"checked": "TRUE"
},
{
"email": "206",
"checked": "FALSE"
},
{
"email": "[email protected]",
"checked": "FALSE"
},
{
"email": "[email protected]",
"checked": "TRUE"
}
]

Only the first one found have been checked

subsidiary question how can i create multiple emails in a set because I have created 2 sets to simulate?

Thank you for this help :wink:

Information on your n8n setup

  • n8n version: 0.182
  • Database you’re using (default: SQLite): Google sheet
  • Running n8n with the execution process [own(default), main]: default
  • Running n8n via [Docker, npm, n8n.cloud, desktop app]: desktop

Hey @terryble66,

Does the below work for you?

Hello @Jon yes it does ! thank you for the correction.