Google Sheet and Semaphore

[armadabrandsops]

Hello! I'm looking to get information on a workflow if it's possible with pabbly.

We have a google sheet of orders that has one column for order status.
Each order will only have 1 status, but statuses can revolve from new, picked, fulfilled, shipped, delivered, cancelled,
I want to use this column as a trigger to send an SMS using Semaphore.

How do I do this?
I have already started with workflow testing, but my problem is that for teh Semaphore "Mobile Number" and "Message" field, I need those columns to reference a column on the google sheet since each order will have different phone numbers. How will I do this?

 

[Luv]

Hey @armadabrandsops

You can try using "Lookup Table" for your use case. Kindly refer to this video tutorial in order to learn more about Lookup Table module -

Let us know if it works for you.

 

[armadabrandsops]

Hey @armadabrandsops

You can try using "Lookup Table" for your use case. Kindly refer to this video tutorial in order to learn more about Lookup Table module -

Let us know if it works for you.

We will give this a try.