Conditional output to Google sheet

[Lars]

I'm automating FB leads -> Google sheet. One of the fields in the leads form is a yes/no and needs to be transformed to either a TRUE or a FALSE for output into a specific column in the sheet. I can't find the solution for this, any tips?

Thanks,
Lars.

 

[Pabbly13]

Hey @Lars !

You can make use of "Lookup" table after your "Facebook Leads" step as shown below-

Here is a video tutorial for reference-

Kindly check on this and let us know if this works for you.

 

[Lars]

Hey, excellent, thanks. And is there a way to trigger alternate steps depending on the result? Like IF a THEN GOTO STEP x?

 

[Pabbly13]

Hey @Lars !

Sure, you can check for the Router step, which will work for you as per the filter condition you will set up.

Kindly check on this video tutorial on how Routers can work for you-

Hope, this can work for you.

 

[Lars]

Hey @Lars !

Sure, you can check for the Router step, which will work for you as per the filter condition you will set up.

Kindly check on this video tutorial on how Routers can work for you-

Hope, this can work for you.

Right, but when I add that app I get an error that it should be the last step in the workflow. So what do I do if I want a router step in the middle of the workflow which jumps to step A or B depending on previous input?

 

[Pabbly13]

Hey @Lars !

The Router steps are always the last step.

So you need to make the router step in last and then add your steps inside the routes in order to execute further for each individual path.

For reference, you can check on this thread on how it is done- https://forum.pabbly.com/threads/ho...enrollment-efficiently-in-pabbly-connect.118/

Hope, this can work for you.

 

[Lars]

I see. And since it doesn't look like steps can be moved around, this means that I need to recreate steps that I've previously created and now realize I want to place in routed branches?

 

[Pabbly13]

Hey @Lars !

That's correct.

You will be required to make new steps inside the Router.