i need some help with my flow.
i get leads about workouts with trainers and i want to send the people who are signed the number of the trainer.
the flow is this:
lead - name, email, phone, place of work out
new row in google sheets
SMS to the new lead with the trainers name+phone number depending on the workout place.
couldnt make that happen...any suggestions?
thanks for helping me out!
If I’m understanding correctly, you’d like to send an SMS to leads with information that is dependent on the choice of location. Something like this:
Location A: Josh, 555-5555
Location B: Ashley, 444-4444
Location C: Sasha, 333-3333
I think your best friend in this case is going to be our Lookup table feature in the Formatter app. More info: https://zapier.com/help/create/format/create-lookup-tables-in-zaps
You look at the incoming value, and depending on what that is, you output a specific set of data. Can you take a look at that to see if it helps at all?