Hi All -
We have a team that does cleaning inspections for our properties. They go to a Google Form, select the name of the cleaner that executed the clean, then conduct the inspection. We use Form Publisher plug-in in Forms, which generates a PDF and emails it to Management. I’m currently using Zaps out of my email to then forward the PDF to the cleaner, based on the Subject (e.g. Cleaning Inspection Report For Frank Ricard).
The problem - while this works, based on my current Zap structure, each Forward is a new Zap, and I’m approaching my 20 zap limit. I’d like to have some sort of “if / then” but I can’t figure out how to do this. Like, “If Subject = Frank Ricard, Then email Frankthetank@gmail.com. Or if the Subject = My Boy Blue, Then email “firstname.lastname@example.org.” That way I don’t have to keep increasing my Zap plan as my cleaning team continues to grow.
Any ideas on how to do this, so I don’t have to continue increasing my Zap plan?
Best answer by nicksimardView original
Try using a Lookup Table: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
NOTE: You may need to use a Formatter > Text > Split step first to isolate the desired lookup value.
Here’s what that would look like in practice:
Hope this helps!