I need help with the Wait node

How do i achieve this:

  • On receipt of a slack message, name, email and comments are extracted from a channel.
  • the email in the now populated row is extracted.
  • AI agent node that drafts an email and sends to the Gmail tool
  • Gmail tool sends the mail to a client.
  • If there’s a response before 3 days, a message is sent to a Slack channel saying that the client has responded. Simultaneously, the ‘Status’ column of the row where the email was fetched from in a google sheet is updated from ‘awaiting reply’ to ‘replied’.
  • if there’s no response after 3 days, a follow-up mail is sent.
  • if there’s still no response after another 3 days, a slack channel is prompted

I’m stuck at the 5th point

Workflow

Share the output returned by the last node

Information on your n8n setup

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

So what exactly is your problem you need help with?

i can’t seem to get this part right. if you can look at the workflow and advice accordingly, i’d appreciate

Maybe don’t put into one workflow

Split the step 5 to another workflow then.

If sending email to user. Log the data to a google sheet to record which user receive the email.


Run daily trigger to check from the google sheet. Check if those user respond
If yes → send to slnd update the status
If no → send follow-up email and put the status to followup


Same trigger to detect the status : if followup more than 3 days → change to other status and notify slack.

2 Likes

Thank you. This worked.

1 Like

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