Question

Continue only if a Google Sheets column matches a different sheet's column

  • 23 February 2023
  • 1 reply
  • 14 views

Hello - I would like to send a follow up reminder text for those who have not completed step 2. Step 1’s data sits in a GSheet1-Tab A-column B and Step 2’s data sits in GSheet1-Tab B-column B. I’d only want to send the follow up text if the user’s info is not found in TabB-column B within 48 hours. I cannot figure out how to compare two sheets’ data

 

Thank you!


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Userlevel 7
Badge +14

Hi @sheilatc 

Good question.

 

Try these Zap steps with GSheets:

  1. Trigger: ???
  2. Action: Delay
    1. 48 hours
  3. Action: GSheets - Lookup Row
    1. Continue whether Row is found or not
  4. Action: Filter
    1. Only continue if Row is found in previous step
  5. Action: ???

 

###

 

I’d recommend using Airtable instead of GSheets.

Airtable has Formula fields that can be used to calculate the difference between 2 dates. e.g. static date VS NOW()

 

Airtable has Views.

Views can have Filters.

Views can be used to trigger Zaps.