I have a process that:
- a Zap starts based on a trigger
- a google sheet row is found (i.e. lookup zap) based on an email address entered in the trigger event (#1)
- the google sheet row is updated with trigger event data; the google sheet row has a formula in it the calculates a “number of days between two dates”, which is impacted by the trigger event’s date
- do another google sheet “lookup” to get that calcuated value
- use that calculated value in additional zap steps
Step #4 seems unnecessary. Is there any way to get rid of step #4 (the 2nd lookup) in its current form as I already have the row # (step #2). I cannot figure out how to use a Row# in the lookup field of the google lookup zap task. The process works, but it feels bulky to me having to do the 2nd lookup.
I hope the above makes sense. Any help/thoughts is appreciated.