Forgive me, I still new to Zapier and I am trying to understand how I can achieve the following…
I’ve a google sheet that when a new google form entry is added, a new row is added.
If I set a cell to 1, then I want Zapier to sendout a template email realting to ‘1’
Once the email has been sent, I want the google sheet to update the date and time that email was sent. In effect I am trying to set a flag that an email went out.
I then what to set a scheule that looks that that flag. if 20 days has passed and there has been no repsonse, then set the flag to 2. This will then trigger an escalation email (if cell equals 1 AND has been sent), update the status to 2 and then record when that email went out.
Does this make sense?
If effect what I am trying to create is a chaser system where flags activate escaltion email for non-response.
I’m a bit loss on how to set this one up.
Seems like you’ll need a series of Zaps.
Some of this feedback may be subject to changed based on these questions.
What in the GSheet indicates there’s been an email response? (e.g. another column timestamp)
ZAP 1: Send Email Template 1 and Log in GSheets
ZAP 2: Send Email Template 2 and Log in GSheets
ZAP 3: Delay 20 Days and Check/Update GSheet
ZAP 4: Check if there’s been an email response and update GSheets
Just checking in. Did you manage to get this resolved?