Updating a cell and sending a delayed email

What are you trying to achieve?

I have built a basic scenario where I am watching new rows in a google sheet and sending an email thereafter. I am stuck on the fact that now I want to go manually into the sheet review the row and add approved or denied in that specific cell. Thereafter I want to then send an email to a new person saying that it has been approved or denied.

I have tried a webhook and multiple other options but nothing seems to have worked.

Screenshots: scenario setup, module configuration, errors

Hello @Andrew_Wevell and welcome to the Make Community!

There are probably a few ways to handle this, but I’ll suggest one.

Why not have two separate scenarios?

  1. Google Sheets Watch New Rows → Email you to let you know there’s been an update
  2. Google Sheets Watch Changes (when your Appproved/Denied columns gets updated) → Send Email letting them know it’s been Approved or Denied
1 Like