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