I think I have my zap mostly figured out but one thing that’s giving me issues is the Google sheet lookup step. I’m trying to return values between two date/time ranges but I haven’t figured out how to do that. My hunch is that a spreadsheet style formula or maybe search operators could do the trick but I haven’t been able to figure it out yet.
Some context on the zap: I’m trying to send sales info (item names and quantities) from Shopify to a google chat message at the conclusion of each shift with the end goal of allowing the employee to get a summary of what was sold so they know what to restock.