Skip to main content

Hi all,

 

Forgive me, I still new to Zapier and I am trying to understand how I can achieve the following…

 

Google Gmail

Google Sheet

 

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.

 

Ta

Mik

 

 

 

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

  1. Trigger: GSheets - New/Updated Row (set the Trigger Column)
  2. Action: Filter (check if 1)
  3. Action: Gmail - Send Email
  4. Action: GSheets - Update Row

 

ZAP 2: Send Email Template 2 and Log in GSheets

  1. Trigger: GSheets - New/Updated Row (set the Trigger Column)
  2. Action: Filter (check if 2)
  3. Action: Gmail - Send Email
  4. Action: GSheets - Update Row

 

ZAP 3: Delay 20 Days and Check/Update GSheet

  1. Trigger: GSheets - New/Updated Row (set the trigger column)
  2. Action: Filter (check if 1)
  3. Action: Delay (20 Days)
  4. Action: GSheets - Lookup Row
  5. Action: Filter (check if Response column is blank)
  6. Action: GSheets - Update Row (set to 2)

 

ZAP 4: Check if there’s been an email response and update GSheets

  1. Trigger: Gmail - New Email / New Email Matching Search (e.g. certain Subject)
  2. Action: GSheets - Lookup Row (by email address)
  3. Action: GSheets - Update Row (set Response timestamp)

Hi @Michael.Thomas 

Just checking in. Did you manage to get this resolved?

Terms & Conditions