How to add delay between every email sent and update the sheet after sending

Hi All,

I am new to n8n and no code platform. I am not a techy person either. What i wanted to achieve is this,

When a google sheet is updated with data such as email, name etc. I want to add an ageny who will do a quick reseach on the lead based on the information available in the google sheet. Once the research is done, I want to create a custom email based on the research and send emails. After sending the emails, i wanted to also update the sheet that the email was sent and when then flow runs again, it does not send to the same lead again.

What i have acheived is,

When the sheet is updated, the emails are sent out but its sending all at once and the sheet is not updating as “Sent” even after adding the sheet note (update row).

Any help here would be highly appreciated.

Thanks,
Al

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:

Use the Loop over Items and a Wait node.

1 Like

I am still unable to figure out how to add random delays in between email triggers. I was able to solve the updation part though.

You can use an expression for that - the following will set a random wait between 0 and 10 seconds:

image

While this is adding a delay before triggering the gmail send node, it is still not solving my issue. Its just creating a buffer before sending email. Buit this is still sendign all emails at once for all data sets.

Did you actually add the Loop over Items node? That allows you to process one item at a time, and add a wait to each one before going to the next.

Yes idid.

You have the ‘loop’ and ‘done’ branches mixed up.

How should it be to acheive the desirted result.

Like I said, place the items to be processed in the ‘loop’ branch, and set the Loop over Items batch size to 1. You can refer to the documentation for more information.

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.