Google Sheets - Search Rows - Stop operation when no rows are returned?

[Monica_Shaw]

What is your goal?

Stop the scenario running when no rows are returned.

What is the problem?

I have a very simple scenario.
(1) I have a Google sheet containing content for social media, including post text, image URL, and a column where I can mark a post as “Ready to be published”
(2) I’m using Google Sheets Search Rows module to search the column “Ready to be published”
(3) This then hooks up to the Facebook module to post the content.
(4) I then update the associated Google Sheet row to say “Published”.

This works fine when I actually have something to search for. But when the Google Sheet module returns nothing, the scenario still proceeds to the Facebook module, which then throws an error (“Missing value of required parameter”).

Is this normal? I would have expected the scenario to stop running if it didn’t find any rows to pass to the next Module.

What have you tried so far?

I have a “Break” error handler attached to the Facebook module but this doesn’t feel like an elegant solution!

Screenshots: scenario setup, module configuration, errors

[Moid_shaikh]

The card hierarchy feels off, “Invoices” is getting lost under the heavy blue block, so give it a bit more visual weight for clearer scanning.

[Henk-Operative]

Hi @Monica_Shaw,

Welcome to the community! What I’d advise here is to add a filter right after the Google Sheets module, where you filter on Total number of bundels > 0. So only if there are more than 0 bundles, the scenario’s goes through with the execution.

Why does this happen? Well, the fact that a Search Rows module finds nothing might also be a result you want to work with. So the scenario doesn’t stop solely on 0 results.

Cheers,
Henk

[Monica_Shaw]

Thanks, Henk, I knew there’d be a simple solution to my problem!