Workflow question (I think Router)

[fisto]

I have an automation that looks up a spreadsheet row in Google Sheets.

If the data is found in Google Sheets, I want it to continue with the remaining actions.

If the data is not found in Google Sheets, I want it to do a different set of actions.

How can I achieve this?

 

[Pabblymember11]

Hey @fisto

As per your use case, you need to use the router action step and can establish the condition if data is found from the Google Sheets and the same if the data doesn't found.

Please check out the following screenshot for your better understanding. Kindly try this at your end and let us know if that works for you.

 

[fisto]

Thanks for your assistance. I'm running into another problem.

Basically I want pabbly to look up data in Google Sheets.

If Pabbly finds the result, it should continue with Router A.

If the result is not in the Google Sheet, it should continue with Router B.

However, when it finds the result, it gives a list of several variables, like in the screenshot below.

But if the data is not found in the Google Sheet, it just has a single line ResponseResult of Data not found.

But there are no variables that return in both situations, that change. So I can't send one result to Router A and the other to Router B.

 

[Pabbly13]

Hey @fisto !

Your task can be done on the basis of the Lookup value you are using.

• That is when the data is found, use its value to map in the "Router A" "Filter" as mentioned below-

• This will work when there is existing details.
• Now for "Router B" "Filter", do the mapping as mentioned below-

• The above Router will respond when there is no data found in the Lookup and will continue further as per your setting.

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